Invoice copy to Credit Memo Report

[Former Member]

Dear All ,

I need some query which provide the detail of A/P Invoices which are copied to A/P Credit Memo.

Thanks

--

Gangadhar

[Former Member · Accepted solution]

Hi GangaDhar

Try This

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

thanks

--

Ashish

[Former Member]

Hi,

Try this:

SELECT Distinct T0.DocNum, T0.DocDate, T0.CardCode, T0.CardName, T0.VatSum, T0.DocTotal

FROM OPCH T0

INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

where T1.TargetType = 19

Thanks,

Gordon