
In Business Central, we are reviewing the Customer Trial Balance and Aged Accounts Receivable reports and want to filter both reports by Customer Posting Group. Although these reports include a Customer Posting Group filter, it only filters based on the default posting group on the Customer record.
However, we need to filter by the Customer Posting Group that was actually used on each transaction. We can achieve this when working directly with Customer Ledger Entries, but this doesn’t appear to be possible within the standard versions of these two reports.
Aside from creating a custom report, is there any way to filter the Aged Accounts Receivable or Customer Trial Balance reports using the transaction‑level Customer Posting Group?
Look forward to a response.