I want to develop a report having following columnsBP 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