Circular reference for confirmed purchase order receipt

Ankitasaha3007
Ankitasaha3007
in Modeling

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

Ankitasaha3007_0-1648698301967.png

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

 

can anyone help me please!

 

Tagged:

Answers

  • Misbah
    Misbah

    @Ankitasaha3007 

     

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

     

    Misbah

    Miz Logix

  • Ankitasaha3007
    Ankitasaha3007

    @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

  • Misbah
    Misbah

    @Ankitasaha3007 

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

  • Ankitasaha3007
    Ankitasaha3007
    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
  • Misbah
    Misbah

    @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.

     

    Misbah

    Miz Logix

Categories