This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
module:report:forecasting [2014/08/08 17:53] target |
module:report:forecasting [2014/08/13 16:04] (current) target |
||
---|---|---|---|
Line 3: | Line 3: | ||
Forecast Report provides user a summarized information about the expected quantity of material upon consideration of inventory affecting records. | Forecast Report provides user a summarized information about the expected quantity of material upon consideration of inventory affecting records. | ||
- | Report Filters: | + | **Report Filters:** |
* Project Number - selection of projects you want to consider in forecast; | * Project Number - selection of projects you want to consider in forecast; | ||
Line 22: | Line 22: | ||
Note: no selected option means all records will be considered | Note: no selected option means all records will be considered | ||
- | Report Columns: | + | **Report Columns:** |
* Item - list of item code and description that pass the filter criteria; | * Item - list of item code and description that pass the filter criteria; | ||
* On Hand - major column header that shows current inventory balance according to selected warehouse and item class; | * On Hand - major column header that shows current inventory balance according to selected warehouse and item class; | ||
Line 28: | Line 28: | ||
* Incoming - shows the receiving job orders and its quantity; | * Incoming - shows the receiving job orders and its quantity; | ||
* Incoming Total (I) - tally of incoming quantities; | * Incoming Total (I) - tally of incoming quantities; | ||
- | * Unserved ("not served" | + | * Unserved ("not served" |
* Unserved Total (U) - balance of unserved (requested qty - prepared quantity); | * Unserved Total (U) - balance of unserved (requested qty - prepared quantity); | ||
* Potential - shows selected parts list which are not ordered for preparation; | * Potential - shows selected parts list which are not ordered for preparation; | ||
Line 37: | Line 37: | ||
* Ordered Total (O) - tally of Ordered quantities; | * Ordered Total (O) - tally of Ordered quantities; | ||
* Total (T) - tally of report columns using the formula: T=OH+I-U-P-R+O | * Total (T) - tally of report columns using the formula: T=OH+I-U-P-R+O | ||
+ | |||
+ | **Uses** | ||
+ | |||
+ | This report can be used by any user to check future or expected inventory for inventory ordering and allocation upon consideration of available variables. | ||
+ | |||
+ | To make sure forecast presents accurate total, all system profiles and reports status should be up to date in accordance with their actual state. | ||