Level 2 Sprint 3 Ending Inventory

Options
ebala@rogers.com
ebala@rogers.com Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor
in Planning & Modeling

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

Tagged:

Comments

  • ebala@rogers.com
    ebala@rogers.com Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

    Hi,

    It is working fine.

    Thanks,

    Bala

  • learncw1
    learncw1 Member, ALL USERS Posts: 5 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. 

     

Categories