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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.