Tips & Tricks #137 Data Lookup Options

By lcordova | Oct 3rd, 10 | Categories: Tips & Tricks, 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.


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 for options on contacting our Support Center.

wordpress View Other Tips & Tricks twitter Follow Us on Twitter
linkedin Join us on Linked-In Subscribe to our Feed

About the Author

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!”

Recent Posts