topic Re: Level 2 Sprint 3 Ending Inventory in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/112475#M27366

Hi,

It is working fine.

Thanks,

Bala

星期五,2021年6月25日12:22:05格林尼治时间 ebala@rogers.com 2021 - 06 - 25 - t12:22:05z Level 2 Sprint 3 Ending Inventory https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/112439#M27347

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

Fri, 25 Jun 2021 04:10:09 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/112439#M27347 ebala@rogers.com 2021-06-25T04:10:09Z
Re: Level 2 Sprint 3 Ending Inventory https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/112475#M27366

Hi,

It is working fine.

Thanks,

Bala

星期五,2021年6月25日12:22:05格林尼治时间 https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/112475#M27366 ebala@rogers.com 2021 - 06 - 25 - t12:22:05z
Re: Level 2 Sprint 3 Ending Inventory https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/125216#M31631

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. 

 

Thu, 18 Nov 2021 22:05:22 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-3-Ending-Inventory/m-p/125216#M31631 learncw1 2021-11-18T22:05:22Z