Reporting Sorting Option

  • 10 February 2022
  • 2 replies

Userlevel 3

Is it possible to create a report where one of the parameters (?) or options is the user can select how they want the report sorted?

Example: I have a Sales Order based report, some of my users want to see the report sorted by Sales Order # and some of my users want to see the report sorted by Ship On date...


Best answer by Ahmed 10 February 2022, 19:47

View original

2 replies

Badge +1

@sarah this isn’t possible but you can have each user create their own Template after selecting the sorting conditions:

More info on report templates here:


Userlevel 5
Badge +2

Just noticed in some reports there are existing formulas that could be selected in the sorting conditions. No idea if this actually works but it would be worth a try. You just need to enter a formula for selecting the required sort field based on a parameter. 


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved