Welcome, Guest. Please Login.
11/02/24 at 07:37:55
News:
Home Help Search Login


Pages: 1
Send Topic Print
Field that indicates a PO is closed? (Read 282 times)
stew
Browser
*


Semper Fi

Posts: 36
Gender: male
Field that indicates a PO is closed?
11/19/07 at 10:57:19
 
Anyone know the field that would indicate the date a PO is fully recieved or the date that a PO is closed?
 
Tryint to write a couple reports and need this key field.
 
Thanks,
Back to top
 
 

EVO 9/27/07 update applied
Client/Server Win2003 Server
Pervasive SQL 2000i SP3
Email WWW stew   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Field that indicates a PO is closed?
Reply #1 - 11/19/07 at 13:02:09
 
BKAPHPO has the field BKAP.PO.PRTD = "C" for closed. and BKAPHPOL has lines for that receiver number with the BKAP.POL.ARD set to the DATE of the close.
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
Pages: 1
Send Topic Print