Invoice copy to Credit Memo Report
Dear All ,
I need some query which provide the detail of A/P Invoices which are copied to A/P Credit Memo.
SELECT OPCH.DocNum, OPCH.DocDate, OPCH.CardCode, OPCH.CardName, OPCH.VatSum, OPCH.DocTotal
FROM OPCH INNER JOIN
PCH1 ON OPCH.DocEntry = PCH1.DocEntry
where PCH1.TrgetEntry is not NULL