You use this program to produce a report which can be used as a tool to assist you in deciding which stock items must be purchased.
This decision can be based on the calculation of free stock or future free stock, together with the various criteria selected.
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Sequence |
Indicate the sequence in which to generate the report. |
||||||
Part category |
Indicate the part categories for which to generate the report.
Part categories are defined against stock items in the Stock Codes program. |
||||||
Report options |
|
Field | Description |
---|---|
Product class selection |
This enables you to include stock items for a selection of products classes in the report. If a specific product class is entered, then only stock items belonging to that product class are included in the valuation. |
Warehouse | Indicate the warehouse(s) to include in the report. |
Stock code selection | Indicate the stock code(s) to include in the report. |
Supplier selection |
Indicate the supplier(s) for which to include stock items in the report. |
Buyer selection |
Indicate the buyer(s) for which to include stock items in the report. |
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Include MPS items |
Indicate the stock items to be included based on their MPS status. A stock item is defined as an MPS item in the Stock Codes program.
|
||||||||||
Include statistical parts |
Statistical parts are items which have been excluded from the cumulative lead time calculation. As a result, if you are using Material Requirements Planning (MRP) you will not obtain adequate forward warning of the need to purchase these items. This report should be used to make purchases based on their independent historical demand profile, rather than rely on MRPs dependency-driven forecast.
|
||||||||||
Calculation |
Calculations can be applied to the accumulated values from all warehouses, or the values held against each individual warehouse. If printing a detailed report, then the calculation is applied to each warehouse and details for the warehouse are only printed for those warehouses matching the selection criteria. If printing a summary report, then the calculation is applied to the totals of all warehouses for a given stock code and only those stock codes matching the selection criteria are printed. |
||||||||||
Criteria |
|
||||||||||
Based on | This option only applies when the
Criteria is not
All.
|
||||||||||
Buying rule |
Select the buying rules of the stock items to include in the report. Buying rules are defined against stock items at the Batching rule field of the Stock Codes program. Items can either be included for all buying rules, or only for a single buying rule. |
||||||||||
ABC code |
Indicate the ABC classification code of the items to include in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The Usage fields M-12 through to M-01 indicate the last 12 months' quantities sold and issued, where M-12 indicates the total quantity sold and issued 12 months ago and M-01 indicates the total quantity sold and issued last month. These figures balance to the Prev sold/issued values for the corresponding months in the Warehouse History listview of the Inventory Query program.
The quantity reserved for WIP allocations is taken into account in the report when Reserve stock for confirmed jobs is enabled (Work in Progress Setup).