Account Receivable in Custom Report

1

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

2

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.

3

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

image
image789×1004 36.2 KB

Result as per requirement
image
image796×700 54.3 KB

now just want to have the closing balance of customer.

4

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?