Skip to main content
Solved

Using a generic inquiry as a data source in another generic inquiry

  • 4 November 2022
  • 8 replies
  • 750 views

Forum|alt.badge.img
  • Freshman I
  • 42 replies

Is it possible to use a GI as part of the data source / table in another GI.

Background:

We sell our products in an online store, we also have a customer that sells our products on their online store and we fulfill and ship these orders. This customer is also a distributer for us. 

At the end of each month we report the total sales (wholesale and online store) for this customer. The issue is the Online store orders come into our system as retail orders. We currently manually combine the sales numbers at the end of each month. 

I have a GI that pulls the Wholesale sales and a separate GI that pulls the online (retail) sales numbers.

Is there a way that I can use the online (retail) GI as one of the data sources (tables) in the wholesale GI, similar to a nested query in SQL, so we just have one GI to run that give us the combined sales numbers?

Thank you!

Best answer by BenjaminCrisman

Hi @Del! In order to do something like this you would need to make a custom table, though it might work with just a SQL view to get one side of the transactions.

Then when you create the GI you have the data set already calculated and can incorporate it to combine the amounts.

Otherwise I think you would need to make a report to show this kind of data which can run subreports which are very similar to nested queries.

View original
Did this topic help you find an answer to your question?

8 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • Answer
  • November 4, 2022

Hi @Del! In order to do something like this you would need to make a custom table, though it might work with just a SQL view to get one side of the transactions.

Then when you create the GI you have the data set already calculated and can incorporate it to combine the amounts.

Otherwise I think you would need to make a report to show this kind of data which can run subreports which are very similar to nested queries.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 42 replies
  • November 4, 2022

Thank you!

I will investigate the customer table.


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • November 8, 2022
Del wrote:

Thank you!

I will investigate the customer table.

Hi @Del! just to make sure based on this last response, the need will be a custom table, not Customer table.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 42 replies
  • November 9, 2022

BenjaminCrisman

Just my excellent typing skills πŸ˜

Thank you!


Forum|alt.badge.img+1

@BenjaminCrisman, do you know if adding this functionality is on the roadmap (being able to use a GI as the source for another GI)?

It would be REALLY helpful.


Doug Johnson
Community Manager
Forum|alt.badge.img+4
  • Acumatica VP, Product Management
  • 585 replies
  • February 9, 2023

@donnadeskins55 Yes. This is a highly important and highly requested item. We are currently planning it for an upcoming release. If you have not already voted for it, please do: https://community.acumatica.com/ideas/allow-generic-inquiries-to-be-used-as-table-for-generic-inquiry-2715 


Forum|alt.badge.img+1

Thanks @Doug Johnson! Can’t wait for that to be released πŸ˜Š


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1178 replies
  • February 9, 2023

@Doug Johnson any idea about the release timeline.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings