Circular reference for confirmed purchase order receipt

I am getting an error in my Sprint 3 activity Create Inventory Ordering Module.when i am writing the formula for confirmed Purchased order receipt i am getting circular reference.


my formula = IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0


can anyone help me please!



  • @Ankitasaha3007 


    I think issue is with Beginning Balance Inventory Line. Share the formula of all lines until Ending Inventory line item



    Miz Logix

  • @Misbah 

    beginning inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

    forecast demand - 'DEM03 Demand Forecast'.Final Forecast
    po submitted - IF NOT Submit Purchase Order Request? THEN 0 ELSE 1
    Confirmed po delivery - POST(PO Submitted, Final Shipping Time Weeks)

    Ending inventory- Beginning Inventory + Confirm Purchase Order Receipt - Forecast Demand

  • @Ankitasaha3007 

    so far so good, everything looks ok to me. Let'e check Final Shipment Amount line item.

  • IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
  • @Ankitasaha3007 


    This too looks ok to me.


    Since I am not able to look at each line item of your module. I would recommend you to check the formula for each line which is being shown on your error window.



    Miz Logix