Circular reference for confirmed purchase order receipt

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!

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…