Credit Memo query

[Former Member]

Hi Experts,

My Client need a query that will show Credit Memo's and which Delivery Documents this is linked to.

How can I get this link if the Delivery was copied to a Invoice and the Invoice to the Credit Memo?

Thanks,

Marli

[Former Member · Accepted solution]

Hi Marli,

You may try:

SELECT Distinct T0.DocNum, T0.DocDate, T0.CardCode, T3.DocNum 'DLN #'

FROM dbo.ORIN T0

INNER JOIN dbo.INV1 T1 ON T1.TrgetEntry = T0.DocEntry

INNER JOIN dbo.dln1 T2 ON T2.TrgetEntry = T1.DocEntry

INNER JOIN dbo.odln T3 ON T3.DocEntry = T2.DocEntry

WHERE T3.DocNum LIKE '[%0\]%'

Thanks,

Gordon