Skip to main content
Solved

How to Use Acumatica GI Filter OR logic

  • 24 August 2022
  • 5 replies
  • 477 views

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. 

 

5 replies

Naveen Boga
Rank
Userlevel 7
Badge +19

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

 

 

Naveen B
Laura02
Rank
Badge +18

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.

Laura ~ Klear Systems, Inc. Irvine, CA. ~
cdiaz
Rank
Userlevel 1

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

 

Naveen Boga
Rank
Userlevel 7
Badge +19

@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?

Naveen B
cdiaz
Rank
Userlevel 1

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

 

Reply


Terms & ConditionsCookie settings