This grid displays the sales and various figures related to each inventory item as a whole or by specific warehouse. Min SOH and Dollar value, Safety Min and Max and Budgets values can be inserted by ticking the specific warehouse which enables these fields. An Auto Set Value box is enabled when Specific Warehouse is ticked and the option selected from the list box. The command is executed by selecting Go
Last Year information is controlled by the System Configuration setting in System tab > CurrentFinancialStart. This is updated by the process Application Roll Over or can be manually changed.
The Inventory setting BudgetUnitAndDollarsAreTied determines if entering one value updates the other or not.
| Field | Description |
|---|---|
| Period No | Period 1-12 for the current financial year |
| Month | Each month related to the current financial year |
| Unit Sales | The number of units sold per financial period |
| Dollar Sales | Dollar value of sales per financial period |
| Min. SOH | Enter the minimum stock level for this part |
| Min. Dollar Value | Enter the minimum value |
| Safety Min. | Enter the minimum safety quantity |
| Safety Max | Enter the maximum safety quantity |
| Budget Units | Enter a budget quantity |
| Budget Dollars | Enter a budget value |
| Last Year Units & Dollars | Units sold last year |
| BOM Usages | Quantity used by Bill of Materials |
| Last Year BOM | Quantity used by Bill of Materials last year |
| BOM Finished Goods | Bill of Materials Finished quantities |
| Last Year BOM Finished Goods | Bill Of Materials Finished quantities for last year |
| Job Usages | Quantities used for Job Costing |
| Last Year Job Usages | Quantities used for Job Costing for last year |
| Job Finished | Quantities used in finished jobs |
| Last Year Job | Quantities used in finished jobs last year |
Copyright © 2012 Jiwa Financials. All rights reserved.