220.127.116.11 Update INV01 Inventory Ordering to Allow Override of Order Amount
I got a circular reference for the below action.
- Redirect the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item instead.)
This is the original formula for Confirmed Purchase Order Receipt
IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0
Since final shipment amount is a function of starting function - demand + confirmed purchase order receipt. I do not understand how could we replace this offset with final shipment amount.
Here are the formula for other calculations