Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Sage ERP MAS 200 SQL Overview and Available Modules

November 3, 2010 by Wayne Schulz

Last week I picked up on a Tweet from Alok Tyagi who is the VP of R&D for Sage North America and responsible for their mid-market enterprise products. He announced that MAS 200 4.5 RDB (aka MAS200 SQL) has been RTM.

RTM is not-so-secret code for “Release To Manufacturing” – aka being done and ready to ship.

In honor of the RTM of Sage ERP MAS 200 SQL v4.5 – Sage has issued a one page capabilities brochure that officially outlines the modules which will be available in the SQL release.

As expected the available modules include those from Sage which are already at the 4.x standards. The complete list is:

Accounts Payable
Accounts Receivable
Bank Reconciliation
General Ledger
Crystal Reports
Custom Office
eBusiness Web Services
Paperless Office
Visual Integrator
Bar Code
Bill of Materials
Credit Card Processing
Inventory Management
Purchase Order
Return Merchandise Authorization
Sales Order
Sales Tax by Avalara
StarShip Freight
StarShip Parcel

The full brochure is availabe below:

Sage ERP MAS 200 SQL Overview and Available Modules

Filed Under: mas200, Sage 100 ERP, Sage software Tagged With: mas200 sql, rdb, sage, sql

Sage Common Payroll Announced For MAS200 SQL, MAS500, ABRA, ERP X3 and ACCPAC

October 22, 2010 by Wayne Schulz

Sage today made official that they’ll be rolling out a common payroll based on their SData communication protocol. This common payroll fills a hole in the Sage MAS 200 SQL release (due November 2010) where legacy (non 4.x standard modules which include payroll) cannot be used with the MAS 200 SQL release.

By creating a common payroll solution Sage hopes to cut down development costs that are soaring as the government continues to change employer tax laws. Each change in tax law requires Sage to update payroll (usually at the very end of the year when everyone is busiest), test the changes, and quickly distribute those upgrades to end users.

Under the Sage Common Payroll initiative the ACCPAC SQL Payroll will be used by at least four Sage products (ABRA SQL v10.1, MAS500 v7.3, ERP X3 v6.1, MAS200 SQL 4.45).

Integration levels will vary depending upon product with only Accpac and ABRA receiving level 3 or very robust integration.

Here’s Sage’s Official Announcement:

Common Payroll is the Sage ERP Accpac payroll module which has been enhanced to become a best-of-breed SQL Server-based payroll that can serve the needs of many of our Sage North America customers. With over 4000 payroll customers in the US and Canada, the Sage ERP Accpac payroll module has a strong track record of providing value to small and medium sized businesses.

Using Sage ERP Accpac payroll as the foundation and the new common sData communication protocol to facilitate connectivity, the new Common Payroll module will offer the tightest level of integration possible between payroll and all of our ERP solutions.

How will a Common Payroll support Sage’s strategy to maximize our assets and reduce redundancies? One example lies in the hundreds of new tax changes that are mandated each year. In 2009 there were more than 200 changes released and that number is expected to increase in 2010. To keep on top of these changes, Sage spends a great deal of money each year to maintain our 12 unique payroll modules, and in some cases, multiple versions for each product. Imagine how much we could accomplish by removing this redundancy of effort, provide the updates in a form that could be used by all our products, and instead leverage our resources to provide customers with greater value, such as new connected services. And because the payroll-related connected services such employee benefit services would only need to be developed once, it would mean they could be made available immediately to all our customers with little to no incremental effort required by individual product teams.

The Common Payroll initiative also supports our goal for providing an Extraordinary Customer Experience as we focus our efforts on developing a single best-of-breed solution that surpasses the functionality and ease of use found in our current payroll modules. This new, unified payroll module will not only scale as a business grows, but if a customer needs to upgrade to another Sage ERP (enterprise resource planning) product, the payroll data will seamlessly migrate.

Common Payroll integration will soon be on the roadmaps for many of our other products, so stay tuned for details. You can rest assured that the native payroll module will continue to be enhanced, sold and supported for those products where it doesn’t make sense to adopt a common payroll.

The Common Payroll integration is an important step toward achieving our objectives and providing your clients with greater value. Projects like Common Payroll not only generate substantial savings and leverage best practices, but enable us to deliver a common experience to our mutual clients.

Filed Under: Abra, mas200, Sage 100 ERP, Sage 500 ERP, Sage software, schulz consulting, Technology Tagged With: common, payroll, sage, sql

MAS 200 SQL v4.45 Pre-Release Guide

July 26, 2010 by Wayne Schulz

There’s a new version of MAS 200 for SQL that’s due out by the end of 2010. Slated for beta in July 2010 followed by a controlled release this version will replace the old MAS 200 SQL which had remained at version 3.74.

Not all modules will initially be available. According to the pre-release guide (see below) only those modules at the version 4.x framework will work with the new MAS 200 SQL.

There also initially will not be any third party conversion tools. Customers using an earlier 3.74 version of MAS 200 SQL will be responsible for their data migration.

Sage MAS 200 SQL Pre-Release Guide v4.45

Filed Under: mas200 Tagged With: mas200, sql

MAS 200 SQL 4.45: A Huge Step Forward In Speed Of Reporting And Integration Ease

June 15, 2010 by Wayne Schulz

In a blog post on his site yesterday, Doug Deane President DSD Business Systems describes a recent visit that two of his top technical people made to Sage North America headquarters where they received an early look at the MAS200 SQL 4.45 release.

The session apparently afforded an opportunity to grill Sage development staff about the capabilities in MAS 200 SQL 4.45 and Jon Reiter (pictured below) and Jim Woodhead, both of DSD Business Systems, came away suitably impressed.

According to Doug’s post a small group of channel partners were invited to spend time with Sage in Irvine to provide feedback on the MAS 200 SQL 4.4 product prior to it’s release.

Some of Doug’s comments:

Very large datasets were tested quickly on external custom Crystal Reports
BIE (Business Insights Explorer) was fast
Because there are no SQL Server stored procedures a single code base will be maintained which allows for smoother integration with and support by third party products.

Read Doug’s full post at Sage MAS200 SQL – A Huge Step Forward

Filed Under: mas200, Sage 100 ERP Tagged With: dsd business systems, sage, Sage 100 ERP, Sage MAS 200 SQL, sql

DSD Business Systems SQL Mirroring YouTube Demo

May 13, 2009 by Wayne Schulz

Would you like to have the advantage of the significant performance improvement offered by SQL data tables? Well you can with an enhancement for Sage MAS 90 or 200 that mirrors your data tables into SQL in real time.

SQL Mirroring for Sage MAS 90 and MAS 200 product that DSD Business Systems has offered for the past few years that they were demonstrating at Insights 2009.

From DSD Business Systems’ Product Page:

SQL Mirroring allows a user (version 4.05 to 4.30) to choose which Sage MAS 90 and Sage MAS 200 Data files to be mirrored directly into a SQL Database in “Real Time” . This means as the records are added, updated, or removed from the native Providex Database, a live record will be mirrored to your chosen SQL Database.The user may use Crystal reports to report directly from the SQL database.

For Sage MAS 90 and Sage MAS 200 Form Printing, if the module is a “Business Framework” module, then the Crystal Work Files are mirrored to SQL automatically.

NOTE: The SQL Mirroring product only writes, removes, and updates the SQL Database, but doesn’t read from it. Therefore, if you use another application to write to the SQL Database, those changes will NOT be reflected back into MAS90.

We’ve used this at a client who mirrored some large MAS 90 tables and the setup was easy (about 30 minutes tops) and once running the process is seamless with the tables mirroring in the background with no intervention on the users part.

Naturally reporting off the SQL tables is lightning fast and as noted in the product description any of the framework modules can have their Crystal Reports take advantage of SQL Mirroring.

Link – DSD Business Systems SQL Mirroring for Sage MAS 90 and 200

Filed Under: MAS 90 Add Ons, Master Developers, Sage 100 ERP Tagged With: dsd business systems, jim woodhead, mas200, Sage 100 ERP, sql, SQL Mirroring, Wayne Schulz

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • Next Page »
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

  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
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