0 Replies Latest reply: Dec 17, 2012 8:37 AM by Janne Vauhkonen RSS

    Forecast report

      Hi

       

      I am trying to build up an inventory forecast report. I have three tables: there is current stock level in one, demand forecast in one (-->decrease inventory) and planned production orders (--> increase inventory). Demand forecast and planned production orders are by period.

       

      What kind of script I need to come up with periodic inventories. (current inventory + cumulative production orders - cumulative demand)? Please see the example below.

       

             Current periodPeriod 1Period 2Period 3
      Beginning inventory5000
      Demand-2000-3000-1000
      Production 050000
      Periodic inventory300050004000

       

       

      Thanks already beforehand!

       

      Regards

      Janne