Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

There is No Sage 100 IRD for 2020

January 6, 2021 by Wayne Schulz

Sage has updated their support knowledgebase to make it clear that there is no separate IRD ( Interim Release Download ) for Sage 100 2020.

These downloads are typically released in December and include updates to accommodate year-end tax changes.

According to Sage:

There is no end of year IRD (Interim Release Download) for the year-end 2020. This update was not needed for the 1099s as the changes for 2020 were made in the latest versions released with changes to the NEC (NonEmployee Compensation) Forms.

Make sure you have versions 2020.1, 2019.4, 2018.10 installed and the Aatrix forms have been updated.

If you have 3rd party modifications for Production Management or IRP see kb 107739

Changes to the Payroll versions are no longer done for year-end through the IRD but rather the Product Updates for Payroll. Latest version for year 2020 is Payroll v2.21.0.0.

Filed Under: Payroll 2.0, Sage 100 ERP, sage 100cloud Tagged With: ird

Is Your Sage 100 Payroll Year-End Processing Slowly?

January 5, 2021 by Wayne Schulz

Are you closing your Payroll module in Sage 100 and notice that it’s taking a long time? This may be even more pronounced if you were previously using an older version of Payroll and upgraded to Sage’s Payroll 2.x.

According to Sage:

In “legacy” Sage 100 payroll (versions 2017 and older), data tables holding quarterly and YTD numbers were simply reset by the program and completely cleared out. Only the Perpetual History and the efiling data tables would retain detailed information on prior-year payroll amounts.

In “Payroll 2.0” (Business Framework coding, versions 2018 and newer), all data tables track much more detailed information and it is retained in all tables year over year. When year-end processing is run in these newer versions, the program must comb through the many detail records and purge only those records older than the required retention setting as set in Payroll Options. Large amounts of employee data and history will cause a lengthier processing time, and many customers have reported longer processing time the first year-end that is run in the new version.

Sage further advises you not stop any period end while it’s in processing. You should allow the process to finish because stopping midway through risks data corruption.

The latest Sage 100 Payroll 2.21 may be downloaded from here ( login required )

Filed Under: Payroll 2.0, Sage 100 ERP, sage 100 payroll Tagged With: payroll, sage 100

How Does Sage 100 Payroll Count Active Employees?

May 16, 2020 by Wayne Schulz

The Sage 100 payroll subscription is priced annually based upon the number of active employees. Since August 1, 2017, there have been two tier schedules depending upon whether you are a new or existing ( purchased before April 2016 ) user of payroll.

 

The on-going price paid for a payroll subscription is based upon the number of active employees paid by your company.

Here is Sage’s definition of an active employee via their knowledgebase.

Tier Count Calculation

The tax calculation process is what populates the SY_Metering.m4t table.

It does not matter if you have printed or updated checks.

If they were in payroll when the tax calculation was run they count. If payroll data entry was cleared after-tax calculation was run, they were already counted.

The count is cleared on the first of every month and starts over.

Each employee is counted once based on their encrypted EmployeeKey$. No matter how many times you pay that employee in a month they are only counted once. The tier limit counts all Company Codes in the installation for that account. Usually, test companies are a copy of live data so it does not increase unless new employees are added to that company code.


The messages you receive depend on the timing and status below.

  1. You are given a grace period of 45 days after you first exceed your tier count limit.
  2. In the 45 days grace period, you are allowed to exceed the 100 until the expire date.
  3. After the expiration date, you are able to continue to perform tax calculation for your tier limit.

Once the unique employee ID’s reach the tier count, tax calculation will be unable to perform tax calculation.


There are 2 solutions:

  1. Remove extra employees in Payroll Data Entry.
  2. Contact the sales team to purchase a higher tier.

Filed Under: Payroll 2.0 Tagged With: payroll tier

FAQ: Emergency Paid Sick Leave and Emergency Family Medical Leave associated with the HR_6201 – Families First Coronavirus Response Act (FFCRA) in Sage 100

April 9, 2020 by Wayne Schulz

Sage has released a four-page document answering the most frequently asked questions about the Emergency Paid Sick Leave and Emergency Family Medical Leave rules associated with HR 6201.

This short guide provides additional information on how to set up Sage 100 Payroll 2.20.x to function properly with the next earnings codes.

For a full copy of the FAQ visit the Sage Knowledgebase here and scroll to the bottom and select FAQ FFCRA for Sage 100.pdf.

Filed Under: Payroll 2.0 Tagged With: payroll

Sage 100 Payroll 2.20 Download Links ( Including Hot-Fixes )

December 24, 2019 by Wayne Schulz

Sage just released Sage 100 Payroll 2.20 which includes important updates required for your first payroll of 2020.

Note: You’ll be able to see these new filing statuses in Employee maintenance after installing the payroll tax update that will be released in mid-December, 2019.

However, the withholding tax will not calculate correctly until you have upgraded to Sage 100 Payroll 2.20.

  • HH1 — Head of Household 2020 or Later
  • HH2 — Head of Household 2020 Ckbx (checkbox) 2c
  • MJ1 — Married FJ (filing jointly) 2020 or Later
  • MJ2 — Married FJ 2020 Ckbx 2c
  • NR1 — NR (nonresident) Alien 2020 or Later
  • NR2 — NR Alien 2020 Ckbx 2c
  • S1 — Single 2020 or Later
  • S2 — Single 2020 Ckbx 2c

Sage 100 Payroll 2.20 Upgrade Links

Documentation:
Sage 100 Payroll 2.20 Tax Tables 12/24/2019 – Read What’s New

Sage 100 Product Documentation – Visit Website

Downloads:

Sage 100 Payroll 2.20 – Download Link

You do NOT need to upgrade your core Sage 100 2018 or 2019 modules. The payroll update installs independently of core modules.

Tax Table Updates:

These are all delivered over the web. To install a tax table update follow these instructions:


To verify whether you have the latest tax update installed:

  1. Select Payroll > Utilities > Payroll Tax Update.
  2. Click Proceed to download and install the latest tax update.
  3. To access this task, the Allow Payroll Tax Update security event check box must be selected for your role in Role Maintenance. Select Payroll > Utilities > Payroll Tax Update.

Download and apply these hotfixes:


Payroll 2.20.0 Program Fix PR6016T – Download
Tax Calculation—A New Property is Required (-10424) For New Jersey Employee Disability Capped Wages to calculate correctly. Note: Install Payroll Tax Table dated 12/24/2019 as well in order to calculate properly.

Payroll 2.20.0 Program Fix PR 6017T – Download
This addresses an issue where Social Security wages and taxes are not calculating for new tax profiles after installing Sage 100 Payroll 2.20 and the Tax Update deployed 12/12/2019.

Payroll 2.20.0 Program Fix PR6018T– Download
When renumbering employees from one department to another and using an alpha character in the department code (i.e., A1, A2, 3C, 4F, etc) a message will pop-up: 3C is not numeric.

Payroll 2.20.0 Program Fix PR6019T– Download
NJ Family Leave Insurance tax do not pull into boxes 18 and 19 on W2 form.

Sage 100 Payroll 2.20.0 Program Fix PR6020T – Download

Employee Medicare rate is missing on the Quarterly Tax Report which causes the employee Calculated Medicare Taxes to calculate incorrectly
Error: ” No tax drill down records are found.” occurs when drilling down into Employee Other Taxes in some scenarios
Ohio local taxes and wages are not appearing on W-2 boxes 18 and 19 or combined with other local taxes

Resolves the following issues:

Open Reported Issues:

Renumbering Employees ( RESOLVED WITH PR6018T – link above )
Payroll 2.20 may prevent renumbering an employee from one department to another with the error ” the employee number already exists in department xx”

Payroll 2.20 Quarterly Tax Report Missing Employee Medicare Tax Rate ( INFORMATIONAL ONLY ) – Engineering is currently reviewing. This does not affect the calculation; it is calculating correctly at the 1.45%. It is just showing 0.00% under Tax Rates – Link

Filed Under: Payroll 2.0, Sage 100 ERP, Sage 100c

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next Page »

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

Loading Comments...

You must be logged in to post a comment.