Skip to Content

Customer statement Query with Invoice details /UDF's

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers