INV01 Inventory Ordering, Confirmed PO delivery and Confirm Purchase order receipt NEW FUNCTION

Evodekan

hello Folks!

i need a guidance

the formula of Confirmed PO delivery and Confirm Purchase order receipt NEW FUNCTION line items

here what i have used:

Confirmed PO delivery: POST(PO Submitted, Final Shipping Time Weeks)

Confirm Purchase order receipt: POST(Final Shipment Amount, Final Shipping Time Weeks)

Accepted answers

JaredDolich

@Evodekan

Confirmed PO delivery equation is correct.

However, you might want to adjust your Confirm Purchase Order Receipt formula a bit by adding a conditional. Realistically, you only want this formula to calculate if the delivery value is not zero. Much more efficient that way.

Yours:

Confirm Purchase order receipt: POST(Final Shipment Amount, Final Shipping Time Weeks)

Correct:

Confirm Purchase Order Receipt: IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

Compare to this:

DCA

All comments

JaredDolich

@Evodekan

Confirmed PO delivery equation is correct.

Yours:

Confirm Purchase order receipt: POST(Final Shipment Amount, Final Shipping Time Weeks)

Correct:

Confirm Purchase Order Receipt: IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

Compare to this:

DCA

Evodekan

I appreciate so much Sir! this formula working well thank you for your help.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…