Skip to Content
0
Former Member
Oct 29, 2012 at 04:15 PM

Customer Statement

44 Views

Hi Guys,

I can across this query by Gordon Du, I would however like this to only show Unreconciled Invoices or Credit Notes, does anyone know how to alter this as such ?

Basically my customer needs a Statement to send to their customers showing all unreconcilled Invoices and Credit Notes Only along with the Customers Address:

SELECT T1.CardCode, T1.CardName, T0.DocDate as 'Posting Date', T0.DocNum as 'AR Invoice Number',

T0.DocTotal as 'AR Invoice Total', T0.DocTotalFC as 'AR Invoice Total FC', T1.DocDate as 'Payment Date',

T1.DocNum as 'Incoming Payment Number ', T1.CashSum, T1.TrsfrSum, T1.CreditSum,

T2.DueDate as 'Check Due Date' , T2.CheckNum as 'Check Number', T2.CheckSum as 'Amount', T3.SlpName

FROM OINV T0 INNER JOIN ORCT T1 ON T0.ReceiptNum = T1.DocEntry LEFT JOIN RCT1 T2 ON T1.DocNum = T2.DocNum

Left Join OSLP T3 ON T3.SlpCode= T0.SlpCode

where T0.DocDate >=[%0] and T0.DocDate <=[%1]

Kind regards

Sean Martin