Skip to main content
Solved

generic inquiry condition not working

  • Oct 25, 2022 8:38 PM UTC
  • 3 replies
  • 213 views
  • Translate All

Forum|alt.badge.img

hi, i’m sure i’m just not doing this correctly but i have some conditions in place and would not like to show cancelled or invoiced sales orders. however the cancelled is coming up for this customer. 

does anyone know what i am doing wrong?

 

Best answer by Laura03

Hi, Try Operator = And  on line 3.

View original

3 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Oct 25, 2022 8:54 PM UTC

Hi, Try Operator = And  on line 3.

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Oct 26, 2022 12:26 PM UTC

hi @laura01, thank you. seems to have worked. i didnt think using And there would make sense.

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Oct 26, 2022 12:42 PM UTC

Yay!  I’m glad it worked.

And works with Not Equal. One value can be not - two different things; not this and not that. 

When we use Equal…. then we usually want Operator = Or because one value cannot be Equal to 2 different things. 

Translate