Description: This report lists the dollar value and quantity of the inventory on hand (Stock on Hand ONLY – i.e. EXCLUDING unprocessed orders) . The quantity and unit cost per part number is displayed together with back order quantities and outstanding purchase order quantities. Serial numbers are also displayed where applicable.
Parameters can be set for part number, classification codes, status, supplier and product expiry. The report can be grouped and sub-totaled by warehouse, classification, category 1-5,supplier,Bin Location and Part no.
| Report Criteria | Enter Required Values |
|---|---|
| Select Physical Warehouse | Physical Warehouse |
| Select Logical Warehouse | Logical Warehouse |
| Select Starting Part No | Select from drop down list. |
| Select Ending Part No | Select from drop down list. |
| Select Starting Classification | Select from drop down list. |
| Select Ending Classification | Select from drop down list. |
| Select Starting Inventory Status | Normal ;Discontinued;Delete ;Slow ;Obsolete |
| Select Ending Inventory Status | Normal ;Discontinued;Delete ;Slow ;Obsolete |
| Select Starting Supplier | Select from drop down list. |
| Select Ending Supplier | Select from drop down list. |
| Show Parts With No Suppler | Yes / No |
| Product Expiry Date Restriction | Products – All;Products – With An Expiry Date;Products – Not Using Expiry Dates. |
| Enter Ending Expiry Date | 30/08/2002 |
| Select First Grouping | Physical Warehouse;Logical Warehouse; Classification; Category 1 -5; Supplier Account Number: Supplier Name; Bin Location; Part No; None |
| Select Second Grouping | Physical Warehouse;Logical Warehouse; Classification; Category 1 -5; Supplier Account Number: Supplier Name; Bin Location; Part No; None. |
| Select Third Grouping | Physical Warehouse;Logical Warehouse; Classification; Category 1 -5; Supplier Account Number: Supplier Name; Bin Location; Part No; None. |
| Show 0 Value Rows | Yes / No |
| Show Individual Stock Lines | Yes / No |
| Show 0 Value Stock Lines | Yes / No |
| Report Style | Summarised; Detail |
Copyright © 2012 Jiwa Financials. All rights reserved.