Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

MAS 90 Address Cleanup Utility: Convert Mixed Case To All Upper or Lower Case

October 13, 2010 by Wayne Schulz

mas90 uppercase utility sage.jpg

If you’ve ever had more than one person manage the entry of customers and vendor addresses then you may have run into an issue where the address block is partly capitalized.

For example you may notice that the name and street address are in lowercase while the city and state portion are in all uppercase. This might be because Sage performs an automatic lookup on the city/state based on the zip code you enter. When the city and state information is found it will be inserted to your system using either all uppercase or mixed (upper and lower) — depending upon the option you set.

The problem that can occur is when the person doing the data entry is entering a customer or vendor address in all capital letters while the zip code lookup is filling the city/state information in mixed case (or vice versa).

Luckily as Brett Zimmerman from my 90 Minds Consulting Group points out — there is a fix! Check the link below for the directions and utility (included free with MAS 90 and MAS 200) to correct the address capitalizations in MAS 90 or MAS 200.

MAS90 Address Capitalization Utility

Filed Under: Hidden Options, mas200, Sage 100 ERP Tagged With: address, capitalization, hidden utility, mas200, Sage 100 ERP

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023
  • DataSelf ETL+ v2023.07 for Sage 100 Announced
  • Version History of Sage 100 Accounting Software
  • What Happens if Sage 100 Goes Read-Only?
  • Sage 100 Knowledgebase Updated
  • Top Sage 100 New Features – Versions 4.4 through 2023
  • The Wayfair Ruling at Five: Why 72% of Businesses Still Struggle with Economic Nexus
  • AVALARA UPDATE: Sales Tax Holiday Changes in Florida
  • Sage 100 & CRM – May 2023 Update

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in