ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Remove orphaned PO Lines
http://www.istechforum.com/YaBB.pl?num=1399314156

Message started by David Waldmann on 05/05/14 at 11:22:36

Title: Remove orphaned PO Lines
Post by David Waldmann on 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?

Title: Re: Remove orphaned PO Lines
Post by Kelloggs on 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

;)

Kelloggs

Title: Re: Remove orphaned PO Lines
Post by David Waldmann on 05/05/14 at 13:22:29

Yup, that pointed out the culprits.
Thanks!!