Create an A/R Payment History by Invoice report with Open Balance of each invoice in Saved Search.
Create a transaction Saved Search by navigating to
Report> Saved Search> All Saved Search > New> Transaction Search
In Criteria, add fields like
Type : is invoice ( To fetch all the invoices in the account)
Mainline : is true
Date
In Results tab, add fields like,
Name: Summary type: Group (To display Customer/Project Name in each in each transaction)
Document No.: Summary type: Group (To display Document No. of each transaction)
Date: Summary type: Group (To display date mentioned in each transaction)
Type: Summary type: Group (To display the transaction type)
Due Date/Receive By: Summary type: Group (To display the due date mentioned in the invoice)
Days Open : Summary type: Group(to display number of days taken by the customer to pay the invoice amount)
Amount : Summary type:(To display the amount in the invoice)
Applying Link Amount: Summary type: Sum (To display the amount paid to the invoice)
Formula Numeric: Summary type: Minimum, Formula: {amount}-NVL(SUM({applyinglinkamount}),0) (To display the Open Balance for each invoice)
Click Save.
Search Result obtained will be:
