×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Custom filters operand

Custom filters operand

Custom filters operand

(OP)
Hi All,

I'm new to mas90. I am trying to create a custom filter report of all inventory items that don't have the word "discontinued" in it. Unfortunately there is no "not contains" operand. How would I go about getting the report to return all inventory items that does not contain the word "discontinue"?

Thank you for your help!

RE: Custom filters operand

Is this a Crystal report?

Sage 300 ERP Certified Consultant
www.adssglobal.net

RE: Custom filters operand

(OP)
I'm not sure. It's a filtered View of existing inventory on the screen output and not printed report, if that helps any. Forgive my vague explanation as I'm a complete newbie to mas90.

RE: Custom filters operand

I assume you're looking at an item list in the lookup. You cannot filter on the description, if the description contains the word "discontinued". If the item's Product Type field has been set to Discontinued then you can create a Customer filter, add Product Type and then add a filter on Product Type Not Equal To D.

Sage 300 ERP Certified Consultant
www.adssglobal.net

RE: Custom filters operand

(OP)
Ettiene,

Thank you for the info.

Unfortunately when creating the filter, there is no operand 'Not Equal To' as one of the choices. The drop down box choice has Less Than, Greater Than, Equal To, Before Date, After Date and a few other except Not Equal To.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close