Sage 100

Consulting and Upgrades

Sage 100 2022 Requires New Activation Key for Production Management Installation

by Leave a Comment

Sage 100 2022 was released on April 18, 2022. While this release includes some new enhancements, the major focus has been on more widely introducing Production Management as the replacement for Work Order Processing.

In order to install Production Management with Sage 100 version 2022, you will need to retrieve new activation keys.

New activation keys are found online using these instructions:

How to register Sage 100 or How to find, register or enter product registration keys for Sage 100 user licenses and application modules

If you are moving from Work Order to Production Management you may wish to first review this Work Order vs Production Management comparison guide.

Feature comparison guide for Sage 100 Production Management vs. Work Order

What File Prerequisites are Required by Sage 100 v2021?

by

The following is a list of the Microsoft prerequisites required by Sage 100. Prerequisites are installed when the installation is run through the Autorun.exe application. You can also manually install prerequisites from the Prerequisites folder under the installation image/CD (for Sage 100 workstation clients its located under the …mas90\wksetup\ folder)

Sage 100 2021 (includes the same Prerequisites as Sage 100 2018, plus the following)

  • .Microsoft .NET Framework 4.72 or higher (see Related Resources)
  • Microsoft Edge Webview

Sage 100 2019 – 2020 (includes the same Prerequisites as Sage 100 2018, plus the following)

  • .Microsoft Visual C++ 2017 Runtime Libraries (Prerequisites\VC2017\vcredist_x86.exe)

Sage 100 2018 (includes the same Prerequisites as Sage 100 2014 – 2016, plus the following)

  • .NET Framework 4.6 or higher (See Related Resources)
  • Microsoft Visual C++ 2005 Runtime Libraries (Prerequisites\VC 2005 SP1 Redist\vcredist_x86.exe), (Prerequisites\VCRedist\vcredist_x86.exe)
  • Microsoft Visual C++ 2010 Runtime Libraries (Prerequisites\VC2010\vcredist_x86.exe)
  • Microsoft Visual Studio 2010 for Office Runtime (Prerequisites\VSTO Runtime\vstor40_x64.exe (vstor40_x86.exe, for Windows 32-bit OS)
  • Microsoft SQL Server Compact 3.5 SP2 (Prerequisites\MsSqlServerCE\SSCERuntime_x86-ENU.msi)

Sage 100 2017

  • .NET Framework 3.5 SP1 (See Related Resources).
  • NET Framework 4.5.2 or higher (See Related Resources)
  • Microsoft Visual C++ 2005 Runtime Libraries (Prerequisites\VC 2005 SP1 Redist\vcredist_x86.exe), (Prerequisites\VCRedist\vcredist_x86.exe)
  • Microsoft Visual C++ 2010 Runtime Libraries (Prerequisites\VC2010\vcredist_x86.exe)
  • Microsoft Visual Studio 2010 for Office Runtime (Prerequisites\VSTO Runtime\vstor40_x64.exe (vstor40_x86.exe, for Windows 32-bit OS)
  • Microsoft SQL Server Compact 3.5 SP2 (Prerequisites\MsSqlServerCE\SSCERuntime_x86-ENU.msi)

Sage 100 2014 – 2016

  • .NET Framework 3.5 SP1 (See Related Resources)
  • .NET Framework 4.0 (See Related Resources)
  • Microsoft Visual C++ 2005 Runtime Libraries (Prerequisites\VC 2005 SP1 Redist\vcredist_x86.exe), (Prerequisites\VCRedist\vcredist_x86.exe)
  • Microsoft Visual C++ 2010 Runtime Libraries (Prerequisites\VC2010\vcredist_x86.exe)
  • Microsoft Visual Studio 2010 for Office Runtime (Prerequisites\VSTO Runtime\vstor40_x64.exe (vstor40_x86.exe, for Windows 32-bit OS)
  • Microsoft SQL Server Compact 3.5 SP2 (Prerequisites\MsSqlServerCE\SSCERuntime_x86-ENU.msi)

Sage 100 2013 (retired)

  • .NET Framework 3.5 SP1 (See Related Resources)
  • .NET Framework 4.0 (See Related Resources)
  • Microsoft Visual C++ 2005 Runtime Libraries (Prerequisites\VC 2005 SP1 Redist\vcredist_x86.exe), (Prerequisites\VCRedist\vcredist_x86.exe)
  • Microsoft Visual C++ 2010 Runtime Libraries (Prerequisites\vcredist_x86.exe)

Information on file prerequisites via Sage knowledgebase article 52544

Error #0 Sage 100 – When Printing Registers After Microsoft Update

by

Several users have experienced an issue with “Error #0: Record/File Busy” when trying to update a Sage 100 register.

This message appears suddenly and it seems related to Microsoft’s March 8, 2022—KB5011503 (OS Build 17763.2686) security patch.

The resolution is fairly simple. You should add Sage 100 File\Folder exclusions to Microsoft Defender (Security) on the Sage 100 Application Server.

The following are the files to exclude from Microsoft Defender scanning:

In your Antivirus product ( Sage KB # 45806 ):

  • Disable any aggressive or continuous (also known as on-access, constant, real-time, or “network scanning“) monitoring or scanning of Sage 100 (formerly Sage MAS 90 or 200) programs if they exist:
    • “..\MAS90\Home\Pvxwin32.exe“
    • “..\MAS90\Home\pvxiosvr.exe“
    • “..\MAS90\Launcher\Launch32.exe“
    • “..\MAS90\Launcher\Launcher.old.exe“
  • Exclude the “..\MAS90” directory and sub-directories and contents on the server where Sage 100 is installed.
    • Note: Do the same for the workstations, if using Sage 100 Advanced or Premium editions (formerly Sage MAS 200 and Sage MAS 200 SQL editions) – default workstation install location is: C:\Sage\Sage 100 Workstation\.
  • On Sage 100cloud workstations, including Standard, there are local folders created for Sage 100: exclude the Crystal Reports install (default: C:\Program Files (x86)\SAP BusinessObjects) and Common Components folder (Sage 100 2019 and earlier = C:\Program Files (x86)\Common Files\Sage. Sage 100 2020 & later = C:\ProgramData\Sage\Common Components).
  • On Sage 100cloud workstations exclude the “Sage 100” folder under the Windows user’s Documents folder.
  • Exclude the following file extensions:
    • AUC, DCL, DD, DDE, DDF, EXP, LCK, LIB, KDF, M4D, M4L, M4P, M4T, M4X, PRM, PVC, PVX, RPT, SOA, XEQ
  • Spa.NA.Com must be a trusted site

Note: It is okay to run nightly scans when users are out.

Once you’ve made the changes noted above the Error #0 should not re-appear and posting can proceed normally.

Sage 100 Upgrade Guides Now Available Online

by

Have you ever spent time searching for Sage 100 product documentation? Upgrade guides are available from links within the Sage 100 program. But what if you are not in front of your accounting system and need to access the documentation?

The Customer Upgrade Guide is a thick document that is available in PDF format. It outlines in painstaking detail the latest features added in the preceding versions. Sage has posted these guides online as PDF files for several years. Recently they’ve also posted the content in HTML format for easier web access.

The key what’s new documents include:

  • What’s New – Product bug fixes included in the latest release
  • Installation and System Administrator’s Guide – Instructions for installing or maintaining Sage 100
  • Upgrade Guide – New features added for the latest Sage 100 release as well as several prior releases. This is a good guide to use for training employees on new features.
  • Supported Platform Matrix – Unfortunately, this is only available in PDF. The document shows what server and workstation operating systems are officially supported by Sage. This also includes minimum memory and processor configurations.
  • Upgrade Checklist – A somewhat lengthy set of items to review prior to completing your Sage 100 upgrade.

You have two choices for reviewing Sage 100 documentation online.

Sage 100 Documentation Online – PDF Format

Documentation is available online at http://cdn.na.sage.com/docs/en/customer/100erp/Documentation.htm. This site contains direct links to documents in both PDF and HTML formats ( as available ).

There is no login required, which makes this very easy for employees to bookmark and access these guides during and after a Sage upgrade.

Documentation for selected versions is available for download in PDF format by following the links from the URL above.

If you prefer, you may now read the same information online in HTML format without having to download a PDF. This can be handy for sharing with other employees or in situations where you may not have the ability to install a PDF reader.

To access the online (HTML) copies of the documentation just look for the “Website” links as shown below.

Getting Started With Sage 100 is Online Too

Do you have new employees who could use some basic training on the fundamentals of Sage 100? The Getting Started Guide is now available in HTML.

Some of the common procedures covered include:

  • Companies and users – how to create Sage 100 companies, users, passwords and user settings
  • Accessing modules and tasks – How to change the accounting date, module and open tasks in a second company
  • Using the lookup’s basic features
  • Using the lookup’s advanced features
  • Printing reports, listings or forms
  • Creating a report setting
  • Setting up Sage Intelligence Reporting
  • Setting up sales tax information
  • Understanding how sales tax is calculated
  • Changing sales tax information
  • Troubleshooting – how to interpret error messages, obtain additional infomration
  • Overview of module setups steps

Should you want to keep a paper copy of the online information you can use the printer icon in the upper right of the Getting Started pages. This will let you print to your choice of printers – which can also include PDF.

Click on the printer icon. Select the printer you would like to use. If desired, you can print the Sage 100 getting started information to PDF.

Sage 100 File Layouts Online

If you’re trying to create a Crystal Report or otherwise access the Sage data tables then you should make note of the file layout guide which is also available online.

Each table along with all fields for versions 2021, 2020, and 2019 are documented online at Sage File Layouts.

When Sage 100 version 2022 is released in March/April of 2022, then the guides will be updated to include the latest table changes ( if any ).

One of the reasons you might consider using the web ( HTML ) version of Sage 100 documentation and file layouts is that you’ll always have access to the most current copy of the document(s).

If you are using a PDF and Sage issues an update then you’d need to (a) know that an update was issued and (b) remember to go online and download the latest copy.

For more tips and tricks related to Sage 100 please subscribe to our weekly Sage 100 email newsletter.

Unable to Get AESCrypto.dll Library Access With Sage 100 E-Filing

by

Several consultants report that when trying to run Federal and State Tax Reporting in Payroll ( may also occur in Accounts Payable 1099 Reporting ) on Sage 100 Advanced or Premium, the user sees “Unable to get AESCrypto.dll Library Address”.

Sage 100 makes use of integration with Aatrix for electronic filing ( aka e-Filing ). This allows Sage to pass either payroll or form 1099 data through to Aatrix where forms may be printed or electronically filed.

Please note that you must use the e-Filing in order to print tax forms ( at no cost ). You are not, however, required to electronically file using the service. If you opt to e-File there is a separate charge for the filing which is listed on the Aatrix website.

How to Fix Sage 100 AESCrypto.dll Error Message

Sage has a report of this error which they’ve documented in their knowledgebase. It’s unknown at what version the error may appear since the article only lists the error report with no mention of version(s) that it might have been reported with.

Please consult your Sage Business Partner prior to making any changes to Sage 100. If you don’t have a partner you can discuss these changes with your IT staff and/or call the Sage support line directly at 800-854-3415 to request their assistance.

The workaround suggests a number of basic steps to ensure that the installation of Sage 100 is complete. Please note that despite the AESCrypto.dll file name – this is an expected Sage file and does NOT normally indicate an issue with any type of crypto locker or another type of malware.

One workaround is to follow these steps:

Before making any changes below you should have a complete backup of your Sage 100. You should also have everyone out of Sage to lessen the possibility of interfering with an existing process.

Reinstalling the workstation client will require local administrator rights to the computer. If you are unsure whether you are a local administrator on your computer, try running any of the steps below by right-clicking and selecting “Run as Administrator”. If you are prompted to log in again then you are likely not at the local administrator level on your computer.

In order to contact Sage support for assistance, you will need to be on a current subscription or maintenance plan. Sage also will only provide support for current levels of Sage 100 as noted here.

  1. Rename ‘C:\ProgramData\Sage\Common Components’ folder.
  2. Reinstall Sage 100 Workstation Client (see Related Resources section)
  3. Reinstall Federal and State Reporting (see Related Resources section)
  4. Go to ‘C:\ProgramData\Sage\Common Components’ and verify AESCrypto.dll and AES.exe exist. If the files are missing, copy from another workstation or call Sage Support 1-800-854-3415 to obtain copies of missing files.
  5. Try re-running Federal and State Tax reporting again

You likely are seeing this message in either Sage 100 Advanced or Premium. Both of these versions normally operate through a service running on your server. The service requires a Windows account for it to run. In some cases that Windows account may not have high enough permissions for certain actions such as e-Filing.

For Sage 100 Advanced and Premium where the host is being run as a service, you may need to review the permissions for the account running that service.

Sage suggests that the service account have FULL permissions to c:\ProgramFiles\Sage\… on the Application Server. Several consultants have reported that even with full permissions their Advanced and Premium installations still would produce the AESCrypto.dll error.

Ultimately what some consultants found that worked is to temporarily elevate the permissions on the account running the service to that of the domain administrator ( please consult your IT department prior to making any changes ).

After the E-Filing has been completed the permissions for the service account should be reduced.

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.