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 period | Period 1 | Period 2 | Period 3 |
|---|
| Beginning inventory | 5000 | | | |
| Demand | | -2000 | -3000 | -1000 |
| Production | | 0 | 5000 | 0 |
| Periodic inventory | | 3000 | 5000 | 4000 |
| | | | |
Thanks already beforehand!
Regards
Janne
