single PO item multiple AP Invoices

[kedalenechong]

Hi All

How to trace and list in Query a single item in PO with 10 Quantities copied to multiple AP Invoices with only one most recent Target Document Entry Number displayed in Target Key Reference?

Kedalene Chong

[hdolenec · Accepted solution]

You are correct that purchase order will only show most recent AP invoice in Target reference, however, every AP invoice will show the correct PO reference in Base data. So join BaseType, BaseEntry and BaseLine from PCH1 to ObjType, DocEntry and LineNum from POR1.

[kedalenechong · Accepted solution]

Thanks for the tip! SELECT T0."DocNum", T0."DocEntry",T0."DocType", T0."CANCELED", T0."DocStatus", T0."DocDate", T0."CardCode", T0."NumAtCard", T1."ItemCode", T1."BaseType", T1."BaseRef" FROM OPCH T0 INNER JOIN PCH1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T1."BaseRef" =[%0]