ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> PO-I-H - Vendor On-Time Performance
http://www.istechforum.com/YaBB.pl?num=1454510506

Message started by TGerak on 02/03/16 at 07:41:46

Title: PO-I-H - Vendor On-Time Performance
Post by TGerak on 02/03/16 at 07:41:46

Can anyone point me to the data fields where the Estimated, Actual and Promise dates for line items live?  I see that BKAPHPOL has the closed PO lines.  I seem to recall that the BKAP.POL.ARD holds the Promise date until the line item gets received.  At that point, it is overwritten by the actual receipt date.  Knowing that the vendor on-time performance can be generated for estimated or promise, it must live on somewhere.

Is anyone using this data?

Title: Re: PO-I-H - Vendor On-Time Performance
Post by Lynn_Pantic on 02/04/16 at 09:58:43

In the open PO the BKAP.POL.ARD is the promise date.  Upon receipt it is moved to position 78 of the BKAP.POL.EXTRA field

Title: Re: PO-I-H - Vendor On-Time Performance
Post by TGerak on 02/05/16 at 14:50:27

Fantastic.  That knowledge, coupled with this formula =MID([@[BKAP_POL_EXTRA],78,8) returns the standalone date.

Thank you.

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.