Skip to main content
Solved

Cartesian problem?

  • 27 September 2024
  • 2 replies
  • 25 views

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!

 

 

Best answer by lauraj46

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

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

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • Answer
  • September 27, 2024

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


  • Author
  • Jr Varsity I
  • 7 replies
  • September 27, 2024

@lauraj46 

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


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