Circular reference for confirmed purchase order receipt

Options
Ankitasaha3007
Ankitasaha3007 Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & 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:

Comments

  • Ankitasaha3007
    Ankitasaha3007 Member, ALL USERS Posts: 5 Occasional Contributor

    @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
    Ankitasaha3007 Member, ALL USERS Posts: 5 Occasional Contributor
    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

Categories