Skip to main content

Hi all, 

I’m trying to summarize two columns from two different tables, but the GI is counting summing by the total number of rows in each of my many side tables. 

Is this something doable in a GI or should this be more of a report? Thanks in advanced!

 

 

Hi @jamest62 ,

Joining multiple details tables will result in a cartesian product as you have seen.  Here are two options to accomplish this:

  1. Use the report designer and subreports
  2. As of 2024 R1, Acumatica supports the use of GIs as data sources for other GIs.  See this thread for further discussion and an example:

Hope this helps!

Laura

@lauraj46 

Thanks for the quick reply. That is what I was thinking also. 

Reply


Terms & ConditionsCookie settings