Report sorting

Thanks. I tried that and it works now!

Follow up question. Why doesn’t the report allow me to change the sort option? Anytime I change it it still prints in customer name sequence. For example I want to print the AR sorted by amount. The report does not allow me to remove the default sort by customer name and add a sort by amount. Do I have to remove all sorting in the report designer?

Sorting applies only for the details section of a report, but in customer summary report all the fields are defined in the group header which is why unable to sort the report in the UI.

@shmaryarichler 

For more understanding follow the below ticket. 

Why sorting in report designer does not work? Is it only effect for detail sections? | Community (acumatica.com)

Hey all, So I’m having issues trying to implement this on an Aging report. (AR631010) My client just wants to sort this report by Client name instead of ID. Every time I change the document to match the screens above the report just errors out. Any idea what I could be doing wrong? Thanks!

Try this one

Hello,

We have tried to ascend the AR Aging and AP Aging reports based on customer and supplier names.

In the grouping section of the report, both reports have a few grouping.

So, we had to change all ‘AccountCD’ fields to ‘AccName’.
And it worked perfectly! :)

Try this one

I need this and it worked perfectly! Thank you @dboes14