Hello Xperts
I would like to make my AR INVOICE report to consider also the DBO.ORIN A/R Credit
How can i make it show also the ORIN documents?
This is the A/R invoice report that i've made:
SELECT T1.DocNum , T1.CardCode,T1.CardName ,T1.BPCHCODE,T4.CARDNAME FROM OINV T1 INNER JOIN OCRD T2 ON T1.CardCode = T2.CardCode INNER JOIN OCRY T3 ON T2.Country = T3.Code LEFT JOIN OCRD T4 ON T4.CARDCODE = T1.BPCHCODE WHERE ((T3.Name = '[%0]') or ( [%0] =''))
Thank you !
D.Medalion