REPORT ENTITY DETAILS report is useful to report Entity Data. You can’t filter customer balance on this report. Preparing a report based on Customer Account transactions and summarize transaction amounts will be a better idea. I prepared a report but.added few features to simplify syntax. That will work on next update.
[REPORT 2:2, 1]
@{REPORT ENTITY DETAILS:E.AccountId:(ET=Customers):,}
@{REPORT ENTITY DETAILS:E.Name:Entity.AccountId == $1}
{REPORT ACCOUNT TRANSACTION DETAILS: BBI.$1.sum:(STAI=$1):$2|{0}}
PS: Second parameter list is useful to capture Entity Name instead of using account name.
– BBI (Balance By Id) returns transaction balance for the account id.
– STAI parameter allows us the filter account transactions by source or target account id.