Skip to Content
Nov 06, 2014 at 05:56 AM

Query to Fetch The record of Invoice and its payment including OB


Hello everyone,

I want to develop a report having following columns

BP Opening Balance INVOICE Invoice Total Payment Opening Balance Payment Open Recovery

In second Column "Opening Balance INVOICE", I want the balance of all open invoice less than my parameter date - Partial payment done on that invoice. and in the column "Opening Balance Payment", i want the sum of payment done by a BP less than my parameter date. and in column "Open Recovery", I want any payment occurred whose invoice is not in my parameter range but payment is in my parameter range.

Parameter is Date. that should be Monthly. like of 1st of August to 31st of August.

Thanks in advance