Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

What Is The Difference Between MAS90, MAS200, MAS200SQL and MAS90 Online?

November 16, 2011 by Wayne Schulz

As I’ve met with many of our customers one question everyone has is — “what’s the difference between MAS90, MAS200, MAS200 SQL and MAS90 Online”?

I thought I’d take just a minute to explain the differences between the four current flavors of MAS90.

What Is The Difference Between MAS90, MAS200, MAS200 SQL and MAS90 Online

MAS90: This is the most common version used by our customers. The program is based on a business basic database language (Providex) and is typically used by companies with up to 20 concurrent users (although this is not a hard and fast rule).

The current version of MAS90 is 4.50. Every MAS90 module has undergone an upgrade (details) to reach this version (often referred to as framework because the underlying data tables changed in the upgraded modules) with the exception of the MRP, Work Order, Job Cost, Timecard and Payroll where the UI (user interface) changed but the tables did not.

MAS200: All of the above MAS90 information applies to MAS200. The screens, reports, underlying data tables and functionality of MAS200 is identical to MAS90.

What’s different about MAS200 is speed. The product used to be called MAS 90 Client Server before it was given the name MAS 200.

Processing with MAS 200 is offloaded to a Microsoft Server so every operation within the program usually runs much faster than MAS90.

While there’s no hard and fast rule of when you must use MAS200 (anyone who tells you different is giving a sale pitch) we typically see customers look at MAS200 when they have 20 or more users or significant issues with speed.

Although it appears due to the client server nature of MAS200 that you should be able to have remote users operating over a thin client — in practice most customers run MAS 200 over a remote desktop environment similar to Citrix or Terminal Server.

MAS200 SQL: All of the above applies with the added benefit that an IT department can make use of SQL data tables as the underlying file storage. Because of some behind the scenes processing that occurs to get the data between native Providex and SQL we have NOT heard that MAS200 SQL is a faster alternative than ‘regular’ MAS200.

MAS90 Online: This is MAS90 hosted by Sage in a secure data environment. For a fee of about $ 170 per user per month you access most MAS90 modules (notably absent is Payroll) and eliminate the need to maintain your own server to run MAS90.

 

[gravityform id=”3″ name=”Consulting Request: MAS 90 or MAS 200″]

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: mas200, mas200sql, mas90online, Sage 100 ERP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

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

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.