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

Evodekan
Occasional Contributor

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

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)
 
2 REPLIES 2
JaredDolich
Master Anaplanner/Community Boss

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

@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:

JaredDolich_0-1617818362711.png

 

 

DCA

JaredDolich_1-1617818362718.png

 

 


Jared Dolich
Evodekan
Occasional Contributor

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

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