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. 

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
  • Vladimir Panchenko commented
    June 22, 2018 11:09

    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.

  • Tim Rodman commented
    April 17, 2019 08:49

    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.