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.

Allow Generic Inquiries to be used as table for Generic Inquiry

Allowing an existing GI to be used as a data source in a second GI would provide subquery capabilities for Generic Inquiries.  Also, a Base GI could be used for other GIs without having to rebuild it each time it is needed.

  • Darrell Scott
  • Apr 13 2017
  • Future consideration
  • Attach files
  • Tim Rodman commented
    17 Apr, 2019 08:49am

    I think this gets even more important with the likelihood that SQL Views won't be allowed in the future due to multi-tenant compliance. Doing a subquery to do things like go off and sum up records in another Generic Inquiry is a very common need. I get that there are performance concerns, but there are a number of things in Acumatica that can cause performance concerns if not used properly (with great power comes great responsibility). This would just be another one of those things.

  • Vladimir Panchenko commented
    22 Jun, 2018 11:09am

    Thank you for your idea. We'll consider it in the future, but I'd like to note that complex subqueries can have some performance implications.

  • and 17 more