Solved

Reporting Sorting Option

  • 10 February 2022
  • 2 replies
  • 247 views

Userlevel 3
Badge

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...

icon

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:

https://help-2021r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=5adbb4bd-4347-4f81-a1ff-4d4d47d1fb1b

 

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. 

Reply


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