Sage 100 ERP

Sage 100 2019.2+ – No Prompt For Daily Transaction Register? Here’s Why

August 26, 2020 by Wayne Schulz Leave a Comment

If you have entered transactions into Sage 100 and suddenly realize you are able to update those transactions all the way through to the general ledger without being prompted to update your Daily Transaction Register – there’s a reason.

Beginning with Sage 100 2019.2 a role maintenance option has been added to Allow Automatic Update of Daily Transaction Register.

What this does is eliminate the final prompt asking if you want to update all the way through the general ledger ( which is what printing the Daily transaction register does ).

If this has impacted your Sage 100 AND you are using Sage 100 2019.2 or higher then the resolution is to modify role maintenance to either add or remove the security event which allows automatic updating of the Daily Transaction Register.

Free Webinar 8/12/20: Creating Dashboards Using Sage Intelligence Reporting

August 10, 2020 by Wayne Schulz

Join Sage on Wednesday, August 12, 2020 for a free webinar spotlighting how you can use Sage Intelligence Reporting to create dashboards for viewing your Sage 100cloud data.

This one-hour session will also be made available as a recording so even if you can’t attend on Wednesday, sign up and you’ll receive a copy of the recording.

How To Upgrade Older MAS 90 3.6x to Current Sage 100cloud

August 4, 2020 by Wayne Schulz

Occasionally we run into very old versions of Sage 100. These are typically defined as any version 3.x.

Thankfully, you can upgrade all of your existing data without no re-keying. Here’s how.

First, I recommend you start off at version 3.71 or higher. If you are on an earlier version you should upgrade to 3.71. I found it was sometimes possible to install 3.71 on top of ( aka in place ) the older release. If you install over the prior Sage version be certain to take a full backup first.

Next, upgrade from 3.71 to 4.3. This is the last release of Sage which offered “Upgrade Level 3 Data”.

Next, upgrade 4.3 to either 4.5 PU 8 ( the higher version may be needed if you have third-party enhancements or payroll ) and then 2017.

I found on a system with no enhancements or payroll I was able to go MAS 90 3.6x to MAS 90 3.71 to Sage 100 4.3 to Sage 100 2017 to Sage 100 2020.

Be sure you make backups of your original MAS 90 data and program files before you begin.

Finding source files for each of these versions is a bit of a project so you may want to enlist the help of your Sage partner.

Sage Suggests Performing SQL Compliance Check By August 31

July 31, 2020 by Wayne Schulz

Sage has emailed partners suggesting that they check their customer sites who may have purchased the Microsoft SQL product from Sage to ensure compliance with Microsoft licensing.

This request only applies to the SQL product itself when licensed through Sage. If you license Microsoft SQL through Microsoft then the regular licensing requirements apply.

The core issue appears to be ( as outlined in the Sage email )

Under the Microsoft EULA, customers and partners can only use SQL as part of a unified Sage solution and in a dedicated environment, not a commercial hosting environment.

This only applies to partners and customers that are using the SQL license purchased through Sage. If a Sage partner has purchased a separate Microsoft SQL license apart from the Microsoft SQL license purchased through Sage, this message does not apply to you (provided you are operating in compliance with the separate Microsoft SQL license agreement).

Sage issued two flowcharts to aid in determining whether a site is in compliance

There appear to be two issues with licensing which Microsoft is reviewing

The SQL license purchased through Sage cannot be used in a hosting environment.
The SQL license purchased through Sage cannot be used with other ( non-Sage ) applications.

This issue only applies to SQL licenses purchased through Sage. If you purchased SQL separately through Microsoft or another non-Sage source then the terms of that licensing agreement would apply.

For additional information, please review the Microsoft ISV licensing site or contact your Sage partner.

Contact Us