I have tried this, but I faced issue on Customers with Sub-customers.
If payment is recorded in Parent Customer and applied to invoices in Sub-customers, the invoices applied is not included in this report. Only payment transaction will show.
Is there any solution to this?