Ideas for Acumatica

Feedback processing: 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. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or 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
  • Vladimir Panchenko commented
    20 Mar, 2019 08:11am

    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.

  • Vineet Bhatnagar commented
    14 Aug, 2018 03:11pm

    This is a much needed requirement.

  • Tim Rodman commented
    10 Jun, 2018 04:14am

    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.

  • dan_00 commented
    13 Apr, 2018 06:07am

    This would be quite helpful

  • Tim Rodman commented
    28 Jan, 2018 03:42pm

    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.

  • Douglas Johnson commented
    20 Dec, 2017 09:46pm

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

  • and 21 more