Welcome, Guest. Please Login.
05/08/25 at 18:51:17
News:
Home Help Search Login


Pages: 1
Send Topic Print
Remove orphaned PO Lines (Read 598 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Remove orphaned PO Lines
05/05/14 at 11:22:36
 
On my Open PO report there are two lines not associated with a Vendor, PO # 0 and Ord Date of 00/00/00.
 
Ord Qty and Open Qty are positive and equal numbers, cost is in line.
 
It seems to me that these lines were created and not deleted when the PO was closed without saving, probably during a crash.
 
I've looked at BKAPPOL but can't see where they're coming from.
 
Any ideas?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Remove orphaned PO Lines
Reply #1 - 05/05/14 at 11:36:30
 
POs LINES WITH NO PO HEADER
 
SELECT
BKAPPOL.BKAP_POL_PONM,  
BKAPPOL.BKAP_POL_CNTR
FROM BKAPPO RIGHT JOIN BKAPPOL ON BKAPPO.BKAP_PO_NUM = BKAPPOL.BKAP_POL_PONM
WHERE (((BKAPPO.BKAP_PO_NUM) Is Null));
 
 
SELECT
BKAPHPOL.BKAP_POL_PONM,  
BKAPHPOL.BKAP_POL_CNTR
FROM BKAPHPO RIGHT JOIN BKAPHPOL ON BKAPHPO.BKAP_PO_NUM = BKAPHPOL.BKAP_POL_PONM
WHERE (((BKAPHPO.BKAP_PO_NUM) Is Null))
 
Try both queries
 
 Wink
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Remove orphaned PO Lines
Reply #2 - 05/05/14 at 13:22:29
 
Yup, that pointed out the culprits.
Thanks!!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print