- 马克的新
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- 永久链接
- Report Inappropriate Content
06-24-202111:10 PM
06-24-202111:10 PM
Level 2 Sprint 3 Ending Inventory
Hi,
I am getting circular referencing error when use the formula to calculate the ending inventory as follows:
Ending Inventory = Beginning Inventory + Confrim Purchase Order Receipt- Forecast Demand
Error Message:
Circular references: Ending Inventory, Safety Stock Exception Count, Confirm Purchase Order Receipt, Beginning Inventory, Reorder Flag, Suggested Order Amount for the Month
Every thing works fine, except the "Ending Inventory".
Any help?
Thanks,
Ba
Labels:
- Labels:
- Calculation Functions
- 马克的新
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- 永久链接
- Report Inappropriate Content
06-25-202107:22 AM
06-25-202107:22 AM
Hi,
It is working fine.
Thanks,
Bala
- 马克的新
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- 永久链接
- Report Inappropriate Content
11-18-202104:05 PM
11-18-202104:05 PM
I got stuck at this point too but realised by Suggested Order Amount For The Month was causing the issue downstream - I had referenced to the DEM03 Final Forecast - rather than the Final Demand in the INV01 Module.
Not sure why this worked but it did.