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.

Generic Inquiry Functions In Grouping, Sorting, and Parameters to Allow Subqueries

Currently, Acumatica 5.3 allows functions in the Condtiions "Value" field.

It would be much more complete to be able to create complex queries that can take parameters--like SQL queries can--to have functions, even subqueries, in the Grouping, Sorting, and Parameters tabs' Data Field column.

  • Ahmed Bahar
  • Jul 15 2016
  • Shipped
  • Attach files
  • Vladimir Panchenko commented
    11 Oct, 2018 02:34pm

    Shipped in 2018R2.

  • Jeffrey Patch commented
    23 Jun, 2018 02:28am

     I agree, its very difficult to do much more than basic inquiries.  For instance try setting up running total.

  • Vladimir Panchenko commented
    4 Jun, 2018 09:02am

    Thank you for your idea. We'll consider implementing it in the future.