User Tools

Site Tools


module:report:forecasting

Differences

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

Link to this comparison view

Next revision
Previous revision
module:report:forecasting [2014/08/08 16:15]
target created
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:** 
-Project No reference project no under the selection department/employee/status+  * Item list of item code and description that pass the filter criteria; 
-Client Company company name of selected clients+  * On Hand major column header that shows current inventory balance according to selected warehouse and item class
-Project Title registered project name+  * On Hand Total (OH) tally of inventory on hand that can be used or consumed immediately
-Currency currency used in the project value+  * Incoming shows the receiving job orders and its quantity
-Project Value value of project as stated in Total on offer value (must be updated regularly)+  * Incoming Total (I) tally of incoming quantities; 
 +  * 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.1407485734.txt.gz · Last modified: 2014/08/08 16:15 by target