Account Receivable in Custom Report

Hi All,
can we have Receivable Balances of Customers in custom report?
i have tried but :pensive:.

Please post an image of your best attempt. Also could you and clarify what feature missing from the built in customer reports your are trying to achieve.

Requirement is to get the last amount received from customer.
Custom Report Edit Mode


Result as per requirement

now just want to have the closing balance of customer.

You cannot do that because a closing balance is not a transaction. Custom reports list transactions. You may get what you want by grouping by account. But why not use a transaction type customer statement?