By using this website, you agree to our Terms of Use (click here)
I'm having order of operations issues in the generic inquiry where I want a field to calculate after it has been grouped. The fix for me would be to save the table somewhere to then be able to bring the table back into generic inquiry as a mergeable table into the GI interface.
In summary, is it possible to get a GI to show up here?
Thanks!
Using a Generic Inquiry in another Generic Inquiry isn't supported yet, but there is a feature request that you can go out and vote on.
It sounds like what you're trying to do is a subquery. It's possible to do subqueries if you create a SQL View, then connect it to a custom DAC as Doug Johnson outlines in this post:
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view