I need a query on Collections (Incoming payments) against Invoices, assuming that I have AR of 15Crs as on 31-03-15, I need to generate a report how much has been collected against open AR as on 31-03-15 month on month, for this I’ve written a query as follows:
T0.DocTotal as ‘AR Invoice Total’,
T2.CheckNum as ‘Cheque Number’
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
From the above query I am not getting the desired output, suppose if there are multiple incoming payments against invoice this query is not listing the number of incoming payments against invoice.
Can anyone help me to resolve my issue.
Thanks in advance