The AR Balance by Customer report (AR632500) does not correctly follow the expected sorting

Date: 23/10/2025

Status: Awaiting Fix

Reference: CE00062562

Issue 

The AR Balance by Customer report (AR632500) does not correctly follow the expected sorting behavior when the "Consolidate data by parent account" option is selected. Specifically, the transactions listed do not sort by Posted Date or Document Date as expected; instead, they appear in a seemingly random order. Additionally, modifying the sorting filters on the form does not affect the output, indicating that the sorting logic is not functioning properly in this context.

Workaround

To show hidden branch grouping:

1. Need to have installed Report Designer

2. On AR632500 click Edit Report

3. Open downloaded file in the Report Designer

4. Login

5. In report designer seek for (Header of groupBranch)

6. In its properties, set Visible = True