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 Ending Part No |
|
|
Select Starting Classification |
|
|
Select Ending Classification |
|
|
Select Starting Inventory Status |
Normal ;Discontinued;Delete ;Slow ;Obsolete |
|
Select Ending Inventory Status |
Normal ;Discontinued;Delete ;Slow ;Obsolete |
| Select Starting Supplier | |
| Select Ending Supplier | |
| 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/2012 |
| Select First Grouping | Physical Warehouse;Logical Warehouse; Classification; Category1 -5; Supplier Account Number: Supplier Name; Bin Location; Part No; None |
| Select Second Grouping | Physical Warehouse;Logical Warehouse; Classification; Category1 -5; Supplier Account Number: Supplier Name; Bin Location; Part No; None |
| Select Third Grouping | Physical Warehouse;Logical Warehouse; Classification; Category1 -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.