User Tools

Site Tools


module:report:forecasting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 shows the receiving job orders and its quantity
-  * Currency currency used in the project value+  * Incoming Total (I) tally of incoming quantities; 
-  * Project Value value of project as stated in Total on offer value (must be updated regularly+  * Unserved ("not served") - compares system total requested quantity and prepared quantity; used to cover late preparation reports
-  * +  * Unserved Total (U) balance of unserved (requested qty - prepared quantity); 
 +  * 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 Total (R- tally of remaining quantities; 
 +  * 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. 
    
module/report/forecasting.1407487566.txt.gz · Last modified: 2014/08/08 16:46 by target