Circular reference for confirmed purchase order receipt

Ankitasaha3007

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.

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

 

can anyone help me please!

 

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

@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

@Ankitasaha3007 

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

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

@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