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)

 

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

 

 

Evodekan

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