Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

In Report Designer, allow Aggregation operations on Report Variables

Currently, you can't include a Report Variable in a Group Section with an aggregation operation performed on it (Sum, Count, etc.).

Here is a screenshot that shows the error that you get when you create a simple variable in the Detail Section of the report and then try to perform a Sum operation on it in a Group Section of the report:

http://i.imgur.com/N3RjxpN.png

Variables can often contain complicated business logic that would be cumbersome to have to reproduce in every place that you want to perform aggregation. It would be MUCH SIMPLER to simply be able to aggregate on the variables themselves.

  • Tim Rodman
  • Oct 23 2015
  • Future consideration
  • Attach files
  • Guest commented
    October 23, 2015 16:40

    Using variables makes the report more understandable for the next person who needs to change it,

  • Robert Lightner commented
    October 23, 2015 18:41

    I couldn't agree more - Would make life easier

  • Vladimir Panchenko commented
    January 31, 2019 18:08

    Thanks Tim, we'll think about implementing it in the future.