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 period||Period 1||Period 2||Period 3|
Thanks already beforehand!