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.

Expansion Field Option in Column Sets

I would like to run a report that populates columns with values for subaccounts so that we can do a horizontal comparison of subaccount activity. I can expand it in the the row sets and that is helpful but there are many times we need to do that horizontal comparison in our internal reports. Please add this functionality if possible. Thank you.

  • Guest
  • Apr 15 2019
ARM
  • Attach files
  • Gabriel Michaud commented
    19 Aug, 2019 07:08pm

    Hi,

     

    This can be achieved by using Velixo Reports and Excel VBA; we have done a similar project with another Acumatica customer recently, their report dynamically creates a hundreds of columns with subtotals. We'll write a blog post that describes this process, but in the meantime feel free to check out the product at https://www.velixo.com.

     

    Gabriel