Hi Everyone,

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:

Select T0.DocDate,

          T0.DocNum,

          T1.CardName,

          T1.DocDate,

          T1.DocNum,

          T0.DocTotal as ‘AR Invoice Total’,

          T1.TrsfrSum,

          T1.CashSum,

          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

Srinivas

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply