Forum Discussion
Opening and Closing Inventory Balance - Forecasting
Hi all, new to the forum. Im having trouble dealing with closing balance of inventory when the forward forecast results in negatives. I have: -current starting Inventory -monthly sales foreca...
Hi,
Share a simple dataset and show the expected result there.
Thanks For responding. This is what Im getting:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec OPENING INV 120 20 120 20 -80 -180 -280 20 -80 -180 -280 -380 FORECAST 100 100 100 100 100 100 100 100 100 100 100 100 PURCHASES 0 200 0 0 0 0 400 0 0 0 0 0 ENDING INV 20 120 20 -80 -180 -280 20 -80 -180 -280 -380 -480 FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE This is the desired result:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec OPENING INV 120 20 120 20 0 0 0 300 200 100 0 0 FORECAST 100 100 100 100 100 100 100 100 100 100 100 100 PURCHASES 0 200 0 0 0 0 400 0 0 0 0 0 ENDING INV 20 120 20 0 0 0 300 200 100 0 0 0 FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE FUTURE Hi,
Share the link from where i can download your PBI file.
Hi, unfortunately im unable to share files as per my company's privacy policies.
