Skip to main content
Solved

How to Use Acumatica GI Filter OR logic


cdiaz
Jr Varsity I
  • Jr Varsity I
  • 6 replies

I am trying to make a Shared filter for open orders where the order type is one of these: (RA, RB, RE, RI, RS)
I have tried many combinations of And/Or but I’m still seeing sales orders with type “SO” in my results.

What is the correct way to use these operators? They are not in the documentation

 

Best answer by cdiaz

This is working now. The GI I’m filtering appears to have multiple fields for OrderType. 
 

 

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

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • August 24, 2022

Hi @cdiaz  Order Type cannot be both. Can you make the below condition from AND to OR and verify?

 

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • August 24, 2022

Hi, inside the parentheses, all operators should be OR. It’s unclear why SO would be included. Maybe add, outside your parentheses, AND Order Type Does not Equal SO.


cdiaz
Jr Varsity I
  • Author
  • Jr Varsity I
  • 6 replies
  • August 24, 2022

Thanks Naveen, I am still seeing SO in the results with this configuration:

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • August 24, 2022

@cdiaz It should work as per the conditions but not sure what is happening here.

Can you please also add one more condition as indicated Laura and verify

OrderType Does Not Equal SO → outside parenthesis?


cdiaz
Jr Varsity I
  • Author
  • Jr Varsity I
  • 6 replies
  • Answer
  • August 24, 2022

This is working now. The GI I’m filtering appears to have multiple fields for OrderType. 
 

 


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