Solved

Using conditions in the GI relations table

  • 9 February 2024
  • 3 replies
  • 54 views

Userlevel 3
Badge

I attended a fascinating summit session given by Steve Hoglum in which he discussed how to optimize GIs by applying conditions in the GI relations table, if I am remembering correctly. I downloaded the presentation PDF but I couldn’t find what I was looking for.

Again, if I remember correctly, he suggested adding conditions in the relations table, something like this:

Did I remember correctly? If so what is the format for dates?

icon

Best answer by frederickodendaal77 9 February 2024, 18:46

View original

3 replies

Userlevel 3
Badge

Hi @michael73 , you remembered correctly. What would be even easier is to use a parameter for the date. So you could do something like this:

 

But it is important that your join is an inner join. So you might want to do this relation on the customer join like so because that can be an inner join:

 

 

Here is the parameter:

 

 

Userlevel 3
Badge

So the Parameter achieves the same thing as doing it at the relation level? In other words it will not get ALL the data then apply conditions but will rather get data that is within parameters like a where clause in SQL?

Userlevel 3
Badge

@michael73 That’s correct, it will only pull data based on the date you select for your parameter. The parameter just replaces the date you wanted to hardcode

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved