My AR Aging and AR Aged Period Sensitive reports do not sort in alphabetical order by customer name but rather by the Customer ID in chronological order and it drives our accounting team crazy. We have a bunch of customer names that are everywhere on the report instead of them being laid out in a concise manner.
Tried to reach out and have this fixed but I am having no luck. Can someone advise on this please?
In the Grouping area of the Report Designer you should see the current grouping/sorting configured based on the Customer ID, updating this to the Customer name field should give you what you’re looking for.
In Report Designer, click to open the Grouping Collection
Then open the Collection Editor for group4
In the collection Editor for group4, click the ellipses at the end of the expression to open the expression editor.
In the expression editor switch out the AcctCD fields with the respective AcctName fields.
Once this is done, it may work, but like will need to check the next group under group4, groupCustomer, and switch out the AcctCD reference there also:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.