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 16:46] 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; | ||
| - | * On Hand Total - tally of inventory on hand that can be used or consumed immediately; | + | * On Hand Total (OH) - tally of inventory on hand that can be used or consumed immediately; |
| - | * Inv - registered project name; | + | * Incoming |
| - | * Currency | + | * Incoming Total (I) - tally of incoming quantities; |
| - | * Project Value - value of project as stated | + | * Unserved ("not served" |
| - | * | + | * Unserved Total (U) - balance |
| + | * Potential - shows selected parts list which are not ordered for preparation; | ||
| + | * Potential Total (P) - tally of potential quantities; | ||
| + | * Remaining - items in part list but not yet requested for preparation | ||
| + | * Remaining | ||
| + | * Ordered - shows selected inventory orders; | ||
| + | * Ordered Total (O) - tally of Ordered quantities; | ||
| + | * 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. | ||