Sage 100

What I want to do is suppress a text field displaying deposit information on a S/O when the payment type is NOT any of the ones below, i.e. I want the suppression criteria to be:  suppress when payment type is NOT AMEX, MC OR VISA.  

{SO_SalesOrderWrk.PaymentType} in ["AMEX","MC","VISA"]

What is the proper syntax for conditionally suppressing the field?

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Not ({SO_SalesOrderWrk.PaymentType} in ["AMEX","MC","VISA"])

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

Thanks Mary Jo!  Why do I forget to google some of this stuff?

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 06-11-2019 16:45
From: Mary Jo Krueger
Subject: Crystal syntax for suppression of a field

Not ({SO_SalesOrderWrk.PaymentType} in ["AMEX","MC","VISA"])

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

Because you have 90Minds people to help you :)

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

Original Message:
Sent: 06-11-2019 16:47
From: Barbara Goldstein
Subject: Crystal syntax for suppression of a field

Thanks Mary Jo!  Why do I forget to google some of this stuff?

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------


Original Message:
Sent: 06-11-2019 16:45
From: Mary Jo Krueger
Subject: Crystal syntax for suppression of a field

Not ({SO_SalesOrderWrk.PaymentType} in ["AMEX","MC","VISA"])

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176

You're right, and an even faster response than Googling!  90Minds is the BEST!

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 06-11-2019 16:50
From: Mary Jo Krueger
Subject: Crystal syntax for suppression of a field

Because you have 90Minds people to help you :)

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------


Original Message:
Sent: 06-11-2019 16:47
From: Barbara Goldstein
Subject: Crystal syntax for suppression of a field

Thanks Mary Jo!  Why do I forget to google some of this stuff?

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221


Original Message:
Sent: 06-11-2019 16:45
From: Mary Jo Krueger
Subject: Crystal syntax for suppression of a field

Not ({SO_SalesOrderWrk.PaymentType} in ["AMEX","MC","VISA"])

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176