Skip to main content
Answer

generic inquiry condition not working

  • October 25, 2022
  • 3 replies
  • 164 views
M
Jr Varsity III
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.

    Laura03

    3 replies

    Laura03
    Captain II
    Forum|alt.badge.img+19
    • Laura03
    • Captain II
    • Answer
    • October 25, 2022

    Hi, Try Operator = And  on line 3.

    ~ Laura Barber, WM Synergy
    Chris Hackett
    M
    Jr Varsity III
    Forum|alt.badge.img
    • mna10
    • Author
    • Jr Varsity III
    • October 26, 2022

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

    Laura03
    Chris Hackett
    Laura03
    Captain II
    Forum|alt.badge.img+19
    • Laura03
    • Captain II
    • October 26, 2022

    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. 

    ~ Laura Barber, WM Synergy
    M
    Terms & ConditionsCookie settingsAccessibility statement
    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