---
title: "Tips & Tricks #137 Data Lookup Options | BCS ProSoft"
description: There are a number of special filters available to select data in MAS 90/200 beyond the standard ranges. For example, if you want to find all invoices in the A/R Invoice History file that are […]
---
Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)
[](https://www.bcsprosoft.com/)
- Products
- Deltek
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/)
- [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/)
- [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/)
- [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/)
- Sage
- [Sage Intacct](https://bcsprosoft.com/sage-intacct/)
- [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/)
- [Sage CRM](https://www.bcsprosoft.com/sage-crm/)
- [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral)
- [Services](https://www.bcsprosoft.com/services/)
- Resources
- Blog
- [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/)
- [Sage Blog](https://blog.bcsprosoft.com/tag/sage)
- [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite)
- Whitepapers
- [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/)
- [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/)
- [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/)
- Product Guides
- [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/)
- [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/)
- [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/)
- Webinars
- [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/)
- [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/)
- [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/)
- Company
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/bcs-referral/)
- [Contact Us](https://www.bcsprosoft.com/contact/)
# Tips & Tricks #137 Data Lookup Options
By [lcordova](https://blog.bcsprosoft.com/author/lcordova) | Oct 3rd, 10 | Categories: [Tips & Tricks](https://blog.bcsprosoft.com/tag/tips-tricks), [Pending Update](https://blog.bcsprosoft.com/tag/pending-update)
There are a number of special filters available to select data in MAS 90/200 beyond the standard ranges. For example, if you want to find all invoices in the A/R Invoice History file that are associated with Customers “A”, “B”, and “D”, but NOT customer “C”, you in the Value field, you would enter, “A,B,D,” (Make sure you put a comma on the end of the string). The result would be all invoices for Customers A, B, and D, but not C.
This feature is available in the Advanced Lookup Engine (ALE) as well as any reports or forms that offer a selection/filter option.
[](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/filter.png)
Entering
## About the Tips & Tricks Series
BCS ProSoft is proud to offer you these Tips & Tricks for MAS 90 and MAS 200. These tips were drawn from our extensive technical support knowledge base as well as from the comprehensive experience or our team. Each tip is outlined in detail, including pictures and or drawings where appropriate. There are a couple of things to note in order to use these tips effectively. All tips are written for Sage MAS 90 and Sage MAS 200 versions 4.1 and higher. Some tips should be used with great care and caution. If you are ever in any doubt as to how to use the information provided, please contact our Award Winning Support Center. [Click here](http://www.bcsprosoft.com/support/) for options on contacting our Support Center.
| [](https://www.bcsprosoft.com/category/rental/) | [View Other Tips & Tricks](http://www.bcsprosoft.com/blog/sage-100/) |  | Follow Us on Twitter |
| --- | --- | --- | --- |
| [](http://www.linkedin.com/ppl/webprofile?vmi=&id=48273840&pvs=pp&authToken=bux9&authType=name&locale=en_US&trk=ppro_viewmore&lnk=vw_pprofile) | [Join us on Linked-In](http://www.linkedin.com/companies/251171) | [](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/hatRSS_50X50-May-18-2021-05-59-25-82-PM.png) | [Subscribe to our Feed](http://feeds.feedburner.com/BcsProsoft/Xutx) |
## About the Author
[](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/LauraCordova-2.jpg)Senior Consultant, Laura Cordova has been an important member of the BCS ProSoft team since 2006. Laura grew up in Juarez, Mexico and came to the U.S. to attend college. She got her BS in Computer Sciece from UT El Paso and remained in the U.S. to work in the accounting and business management field. According to Laura, “I love my job because every day I get to work with new clients and help solve new problems!”
Laura’s family still lives in Mexico and she enjoys visiting as often as she possibly can. When she’s not traveling to Juarez, she loves to read (primarily self improvement books) and also enjoys movies (but nothing scary, thank you!). Spanish is Laura’s first language, which can be a blessing and a curse, “There are many Spanish speakers in South Texas and I enjoy working with them, but I learned accounting and computers in English, so if I’m working with a Spanish speaker, sometimes I struggle to translate the MAS 90 words into Spanish!”
#### Share this post with a friend or coworker!
-
-
-
- [mailto:?subject=Tips%20&%20Tricks%20#137%20Data%20Lookup%20Options&body=https://blog.bcsprosoft.com/tips-tricks-137-data-lookup-options](mailto:?subject=Tips%20&%20Tricks%20#137%20Data%20Lookup%20Options&body=https://blog.bcsprosoft.com/tips-tricks-137-data-lookup-options)
### Related posts
[Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/extend-the-functionality-of-your-sage-intacct-solution-learn-more-at-wednesday-wisdom)
Mar 24th, 21
[Services Sales Tax Spreads Through States](https://blog.bcsprosoft.com/services-sales-tax-spreads-states)
Feb 8th, 21
[The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/sage-intacct-budgeting-planning-series)
Nov 19th, 20
[Survey Results, Expert Speakers, and Industry Insights – Sage Intacct Hospitality Hangout Has It All](https://blog.bcsprosoft.com/hospitality-hangout)
Sep 17th, 20
[The Sage Intacct Healthcare Hangout is Back!](https://blog.bcsprosoft.com/healthcare-hangout-2)
Sep 15th, 20
[Hurricane Laura – Is Your Business Prepared?](https://blog.bcsprosoft.com/hurricane-laura-is-your-business-prepared)
Aug 26th, 20
This is a search field with an auto-suggest feature attached.
- There are no suggestions because the search field is empty.
### Recent Posts
### Who is BCS ProSoft?
We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/)
BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico.
### **Products**
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/)
- [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/)
### **Company**
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/calendar/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/)
© Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)