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. 

Ability to do a total of subtotaled lines in Generic Inquiry

tAbility to total several subtotals in a generic inquiry.  Currently two separate generic inquires are being used one showing a list of subtotals (by creating a group for each location for example) and then one with a total of the listed subtotals by not using a grouping but rather totaling all of the ungrouped data.

  • Guest
  • Aug 13 2015
  • Future consideration
  • Attach files
  • Douglas Johnson commented
    December 20, 2017 21:46

    Workaround: you can currently to this by using the new Pivot Table feature.

  • Tim Rodman commented
    January 28, 2018 15:42

    If you could just add a line underneath the last record of a Generic Inquiry with maybe a gray background, that would be cool.

     

    Then, when exporting the Generic Inquiry to Excel, if the export routine could use the SUM Excel formula in the Total cell values rather than just exporting the static total values, that would be even cooler.

  • dan_00 commented
    April 13, 2018 06:07

    This would be quite helpful

  • Tim Rodman commented
    June 10, 2018 04:14

    Actually, what if this could be implemented like a read-only parameter where the parameter could accept any aggregation formula. The reason to implement as a parameter would be so you could choose where to place each aggregate value on the top of the grid among the parameters. This is how some out-of-the box inquires are already constructed where there are total values included in the same area as the parameters on top.

  • Vineet Bhatnagar commented
    August 14, 2018 15:11

    This is a much needed requirement.

  • Vladimir Panchenko commented
    March 20, 2019 08:11

    We've added support for top-level totals in Generic Inquiries in 2019R1 release.

    Sub-totals is a nice feature, and we'll definitely consider implementing it in the future.