Schulz Consulting

Consulting and Upgrades

Does Sage sell SQL Runtime Licenses for Sage 100 Premium?

by Leave a Comment

Sage offers SQL runtime licenses for users of Sage 100 Premium in an on-premises environment. These may be ordered from Sage who then provide all necessary registration information.

Please note the important restriction to this license as it may only be used for on-premises implementations with dedicated hardware. All servers and other devices must be fully physically dedicated to the end user. For SQL licenses to be used in a hosted environment you must purchase a full unrestricted SQL license from a Microsoft reseller.

Sage Transitions Billing for Sage AP Automation to Beanworks Effective 10/1/2022

by Leave a Comment

Effective October 1, 2022 Sage will transition the account renewal and billing process for Sage AP Automation for Sage 100 and Sage 300 to the application’s developer Beanworks.

Customers will be contacted by Beanworks to sign a revised agreement and provide banking information for their renewal within the next 60 days.

Beanworks marketed Sage AP Automation through a white label relationship with Sage. In March 2021 Beanworks was acquired in a $100 million deal by Quadient.

Join Our Weekly Sage 100 Newsletter

Every Thursday we publish a newsletter covering Sage 100 news. Enter your information below to receive our next issue.

By clicking submit, you agree to share your email address with the site owner and Mailchimp to receive marketing, updates, and other emails from the site owner. Use the unsubscribe link in those emails to opt out at any time.

Sage 100 FAQ on OAuth and TLS 1.2

by Leave a Comment

Here is some information on two frequently asked questions regarding the Microsoft OAuth requirements (effective 10/1/2022) and the requirement to use TLS 1.2 to reach Sage licensing servers (effective September 2023).

For a more detailed explanation of the Microsoft OAuth changes please see – Deprecation of Basic authentication in Exchange Online

By October 1, 2022 users who rely on Microsoft for emailing Paperless Office documents will need to adopt Sage 100 version 2021.4+ or 2022.1+.

If you are not emailing documents from Sage 100 then you have until September 2023 to adopt 2021.4+ or 2022.1+.

(Note: Technically it appears from this post that Sage 100 2019.4+ are TLS 1.2 compatible, however we recommend you upgrade to 2021.4+ or 2022.1+ for maximum future compatibility).

In each case the easiest resolution is to be on a supported version of Sage 100. If you are on the latest product update for Sage 100 version 2021 or 2022 then you shouldn’t need to take further action.

Sage 100 OAuth and TLS 1.2 Required Due Dates

On October 1, 2022, Microsoft® will disable Basic Authentication for email services and will require the use of Modern Authentication for Microsoft Exchange Server and Office 365.

Sage KB 116301: How to configure Sage 100 OAuth E-Mail settings for use with a Microsoft 365 App Registration

Note: Google® ended support of Basic Authentication (less secure apps) on May 30, 2022.

Sage KB 115141: How to connect Sage 100 to Gmail using OAuth 2.0

Any Sage 100 site using Basic Authentication with Microsoft email services will experience interruptions with their Sage 100 in-product email services. To avoid related issues, Sage 100 customers should upgrade to at least 2021.4 or 2022.1 version by October 1, 2022.

Recommendation: Upgrade to the latest release of Sage 100 2021.x or 2022.x where x is the latest product update.

Read the July 28, 2022 Sage FAQ on OAuth here

Sage FAQ on TLS 1.2

Effective September 2023, Sage servers will stop accepting communication from Sage 100 and Sage 300 product versions using Transport Layer Security (TLS) 1.0 and 1.1.

TLS is a security protocol that creates encryption paths over computer networks to help ensure that online communications and information cannot be intercepted. Regulatory standards have increasingly required the adoption of TLS 1.2 and the subsequent deprecation of TLS 1.0 and 1.1 due to known security risks.

Any customer on product versions using TLS 1.0 and 1.1 will require an upgrade to their Sage 100 and Sage 300 software to prevent a disruption in the use of their software.

By clicking submit, you agree to share your email address with the site owner and Mailchimp to receive marketing, updates, and other emails from the site owner. Use the unsubscribe link in those emails to opt out at any time.

If a Sage 100 user does not upgrade their software by September 2023, they will begin receiving warning messages when accessing Sage 100 due to the inability to communicate with Sage servers. The software will revert to read-only mode and restrict access.

Read the July 25, 2022 Sage FAQ on TLS 1.2 here

Recommendation: Upgrade to Sage 100 2021.x or 2022.x although Sage’s website indicates that 2019.4+ is compatible with the TLS changes..

  • Sage Production Management enhancements
  • Simplified role security capabilities
  • Automation in reversing an entire accounts payable (AP) check run

Check back with us periodically for the latest updates to these two important changes.

Sage Sets Summer 2023 Deadline for Sage 100 TLS 1.2 Requirement

by Leave a Comment

Sage has begun to contact customers via their online knowledgebase and alert them about an upcoming change. In order for your Sage 100 accounting software to continue contacting the Sage licensing servers you must be on a supported version of Sage 100.

From the Sage KB 116278

In the summer of 2023, Sage will be making changes to your license verification to utilize a current Transport Layer Security (TLS) protocol recommended by third-party standards organizations. This measure is required as older versions of TLS do not meet current security standards and can pose a security risk. If you have a subscription business care plan and are not on a Supported Version of Sage 100, your software will convert to read-only mode.

What does this mean?:

Sage will be updating their internal licensing servers to use TLS 1.2. This is a a widely adopted security protocol designed to facilitate privacy and data security for communications over the Internet.

Previous versions ( prior to Sage 100 2019 ) utilize only older TLS 1.0 or 1.1. Starting in the summer of 2023 you will need to be on a supported version of Sage 100 which offers TLS 1.2 or your ability to maintain a license is jeopardized as Sage states that those who are not on current versions will find their system converted to a read-only mode.

Recommendation:

Our recommendation is upgrade to Sage 100 2021.4+ or 2022.1+ for maximum compatibility.

Resources:

Using Microsoft Exchange with Sage 100 and Paperless Office ( KB 116280)
Sage 100 product licensing and Transport Layer Security ( KB 116278 )

Sage 100 Supported Versions

Sage Issues Patch for “Unable to draw folder control” Issue in 2022.1 and 2021.4

by

Sage today issued a pair of patches which address what appears to be a bug with Custom Office enhanced screens which have an additional tab. During the application of Sage 1002 2022 product update 1 or Sage 100 20221 product update 4 users impacted by this bug saw an error “Unable to draw folder control”.

This was first reported in this Sage City post – Error Unable to draw Folder control – Issue with customized panels in 2022 Product update 1

Sage issued patches for both Sage 100 2022.1 and Sage 100 2021.4 which resolves this issue. No other versions of Sage 100 were impacted by the bug.

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.