3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount

GAPER
GAPER
in Modeling

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

image.png

Thank you.

Best Answer

Answers

  • gaurav
    gaurav

    Hi @GAPER use POST function in Confirmed Purchase Order Receipt.

    your formula will look like POST(Final Shipment Amount, Final Shipping Time Weeks).

    Cheers

  • GAPER
    GAPER
    image.png

    Master Kumar, it still show circular reference so i wonder if there are anything wrong in other lines….

    Thanks

  • GAPER
    GAPER

    I think i have fixed the issue - I used a wrong if case for the final shippment amount

Categories