Skip to Content
0
Former Member
Jan 23, 2012 at 09:26 AM

Make my A/R invoice report consider A/R credit

28 Views

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