sage 100cloud | Schulz Consulting

Sage 100 Supported Versions As of December 2019

December 18, 2019 by Wayne Schulz

Sage North America has revamped their Sage 100 supported versions listing making it simpler to understand when various releases reach their end of support date.

Previously, Sage would stagger the support end dates based on the type of support a release was entitled to.

This meant, for example, there would be a different support end date for:
– Phone support
– Product updates
– Hotfixes
– IRD ( Interim Release Download )

With this change, Sage will now list one support end date per release. Typically this appears to be about a 3-year support cycle for each version ( Sage 100 2017, for example, is due to come off support with the release of version 2020 estimated for March 2020 ).

The change is more to clarify and make the support end date clearer and does not appear to shorten or otherwise materially change the amount of time your release is fully supported by Sage.

With the introduction of subscription pricing ( aka Sage 100cloud ) within the past few years, Sage has been urging users to remain current on the latest release.

While each company will upgrade at their own pace, we feel that an upgrade at least every two years ( ideally annually ) is recommended for most businesses. This means if you have third-party integrations you should verify that these companies have their versions ready on the same timeline as Sage releases each version.

Log into the Sage knowledgebase to view the Sage 100 Supported versions.

Sage 100cloud Payroll 2.1x Over Withholding for Checks Dated 12/31/2019

December 17, 2019 by Wayne Schulz

We have seen multiple reports from Sage 100 Payroll users where a payroll check dated on 12/31/2019 via Sage 100cloud Payroll 2.1x has too much federal tax withholding.

UPDATE: Sage has published a hot-fix for Payroll versions 2.19.4 and 2.20

In some cases, reports have mentioned federal income tax withholding that is $100 or more than the prior payroll check.

Sage has an issue report on this which they documented as:

Tax Calculation – New W4 Dependent Amt, Other Income & Deductions Values not pulled into Calculation when check date is 12/31/2019 or 01/01/2020

Federal tax withheld changes on checks dated 12/31/2019 or 01/01/2020

Federal tax calculation amount is wrong on checks dated 12/31/2019 or 01/01/2020

W-4 exemptions are ignored when generating payroll check dated 12/31/2019 or 01/01/2020

According to this knowledgebase entry, expect a hot-fix to be issued around the same time as Sage releases Payroll 2.20 which is expected on or about December 19, 2019.

State Sales Tax Guides for North America 2019-2020

November 25, 2019 by Wayne Schulz

Sales tax service provider Avalara has created a comprehensive website showing sales tax rules for each state in the United States.

You’ll notice some states are omitted, such as Delaware, Montana, Oregon, and New Hampshire. A fifth, Alaska, has no state-level sales tax but allows municipalities to impose the retail-level tax.

Sales Tax Quick Reference

There is also a quick reference download available for each state charging sales tax. This guide would be handy for distributing to accounting staff for a quick overview of filing dates and requirements.

Sage 100 Integrated Sales Tax

Users of Sage 100 and Sage 100cloud also have the option of incorporating sales tax processing directly into their Sage 100 system. The Avalara integration replaces the manually created sales tax codes and will compute and file sales tax returns to most states on your behalf.

Streamlined Sales Tax ( SST )

If you are making sales in multiple states and aren’t yet registered – here’s an additional option Avalara offers called Streamlined Sales Tax ( info below via their website ) .

Created in 1999, the Streamlined Sales and Use Tax Agreement is the result of a cooperative effort between state and local governments and the business community. The goal of SST is to simplify sales and use tax collection and administration for all sellers and all types of commerce by making sales tax administration requirements less burdensome. Participating states must simplify and centralize aspects of sales tax administration. For some companies, SST offers critical tools to help address ever-changing sales tax regulations. For others, the benefits of SST are less obvious.

The active members of SST are: Arkansas, Georgia, Indiana, Iowa, Kansas, Kentucky, Michigan, Minnesota, Nebraska, Nevada, New Jersey, North Carolina, North Dakota, Ohio, Oklahoma, Pennsylvania,* Rhode Island, South Dakota, Tennessee, Utah, Vermont, Washington, West Virginia, Wisconsin, and Wyoming.

For more information on sales tax compliance integration for Sage 100 and Sage 100cloud please contact us.

30 Ways to Fix Sage 100 “Data is not selected for report printing”

October 8, 2019 by Wayne Schulz

If you are working in Sage 100 or Sage 100cloud and encounter the message “Data is not selected for report printing” while trying to print a form or a report then you should look at this Sage knowledgebase article.

This comprehensive article lists 30 different reasons for the “Data is not selected” message as well as links to specific knowledge articles which can help you resolve any problems.

In some cases you may be recieving the message because there truly is no dataa to print ( if , say, your Sales Order has the “print picking sheet” box UN-checked ).

However, there are some other reasons that Sage outlines where you can also run into this issue unexpectedly and the steps to take to resolve the problem and get your Sage 100 form or report printing as expected.

Some issues that this article covers include:

Report settings have been filtered such that there are no eligible records
Corrupted, damaged, or missing SY_ReportEngine.pvc file
Report Settings for one Sage 100 user have changed
Previously known issue that has been patched in latest updates
Return of Goods Entry print box not checked
Data Corruption
Blank Records in the Masterfile that need to be deleted
E-mail PDF Delivery Option is not selected for vendor
Print Invoices checkbox not checked in AR or SO Invoice Defaults
Damaged User profile
“Default Special Items to Drop Ship” selected in SO Options
Using MultiBin and there are items not distributed to bins
Line items on Sales Order are Backordered or Quantity Ordered is zero (0)
SO_SalesOrderPrint.m4t data file may be corrupted
SY_ReportOption.m4t file contains corrupted values after upgrading to version 2015
Bank Reconciliation and Accounts Payable module not Integrated
E-mail was not selected for customer in Paperless setup
History files have been removed due to Years to Retain options
Need to Rebuild Sort Files for Work Order module
Module code was incorrectly entered
Prospect does not have a Customer ID
Reported issue which Sage Engineering is Currently Reviewing

For a full list of the issues related to this printing message please visit the Sage knowledgebase here – Error: “Data is not selected for Report Printing”

These Are The Supported Versions of Sage 100cloud As of October 1, 2019

September 30, 2019 by Wayne Schulz

As of October 1, 2019 the following Sage 100cloud versions are eligible for support directly from Sage.

Depending upon the Sage 100cloud version ( these dates also apply to the Sage 100 perpetual license) the level of support varies.

There Are Four Primary Types of Sage 100cloud Support:

Product Updates – Self-instlling bundle of fixes as well as some feature enhancements. These are typically issued on a regular basis throughought the year.

IRD – Interim Release Download – a special annual update which readies the verison of Sage 100cloud for year-end tax processing ( Accounts Payable and Payroll ) – expected release date mid-December 2019

Hot-Fixes – typically quick fixes which are issued urgently to fix a problem when the fix can’t wait until the next product update or when the version may not be eligible for product updates but is eligible for hot-fix.

Phone Support – the longest running support benefit is phone support which allows those with a Sage Business Care plan to call Sage directly.

The official Sage chart outlining the Sage 100cloud product versions which they suppport is available here.

Sage 100cloud Supported Versions – 10/1/2019

Product Updates, IRD, Hot-Fixes & Phone Support

Sage 100 2019

IRD, Hot-Fixes & Phone Support

Sage 100 2018

IRD & Phone Support

Sage 100 2017

If you are using Payroll with Sage 100cloud, this is the last year that Sage 100 2017 will be eligible for payroll updates coming into the 2019 year-end.

Users of the updated Payroll 2.x will want to update to version 2.2 ( expected mid-December 2019 release date ) which will be required for processing payroll taxes for 2019.

Schulz Consulting offers Sage 100cloud Support for one low fixed price. If requested, we can also price in an annual upgrade ( typically every other year ). Contact us here for more information.