Welcome, Guest. Please Login.
05/08/25 at 13:24:40
News:
Home Help Search Login


Pages: 1
Send Topic Print
PO-I-H - Vendor On-Time Performance (Read 2549 times)
TGerak
Full Member
***


DBA Classic Since
2000!

Posts: 186
PO-I-H - Vendor On-Time Performance
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?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: PO-I-H - Vendor On-Time Performance
Reply #1 - 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
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
TGerak
Full Member
***


DBA Classic Since
2000!

Posts: 186
Re: PO-I-H - Vendor On-Time Performance
Reply #2 - 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.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print