Skip to Content

Customer statement Query with Invoice details /UDF's

Apr 25, 2017 at 07:31 PM


avatar image

Hi Experts,

I have a few queries with customer statements but non that show just the balance due and columns from the invoice and credits example Advertiser Name, Campaign Name etc. I want to see the 30 60 90 over 121 past due but also want to see the invoice detail is that possible? And how would I join the fields to bring in the invoice details?

Using this query on these joins does not give details

FROM JDT1 T0 INNER JOIN OCRD T1 ON T0.ShortName = T1.CardCode AND T1.CardType = 'C' WHERE T0.IntrnMatch = '0' AND T0.BalDueDeb != T0.BalDueCred

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers