ebala@rogers.com
Occasional Contributor

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

2 REPLIES2
ebala@rogers.com
Occasional Contributor

Hi,

It is working fine.

Thanks,

Bala

learncw1
Occasional Contributor

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.