Sage 100

Consulting and Upgrades

  • Home
  • Services
  • Contact

Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)

May 16, 2022 by Wayne Schulz Leave a Comment

Once your data is on Sage 100 Premium ( SQL ) data files, there is no utility with the Sage 100 program to move those files back to the Sage 100 Standard or Advanced ( Providex ) data files. Sage has an KB Entry 96603 – Can I upgrade (downgrade) from Sage 100 Premium to Sage 100 Standard or Advanced?.

However, there is a third-party solution which does allow for the migration of SQL data files back to Providex. This utility is available from DSD Business Systems as LMSN – LMSN SQL to Non-SQL Migration.

According to the DSD website, the utility is available for Sage 100 versions 4.50 through 2020.

For more information, visit DSD Inc.

Filed Under: Sage 100, DSD Business Systems

Sage 100 2022 Requires New Activation Key for Production Management Installation

April 19, 2022 by Wayne Schulz 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

Filed Under: Sage 100 Tagged With: production management, sage 100

Sage Releases Sage 100 v2022

April 18, 2022 by Wayne Schulz Leave a Comment

Sage officially released Sage 100 v2022 on April 18, 2022. This is the first release to include Production Management on the installation image.

Via Sage City: Experiencing FOMO? We have the cure. Upgrade to Sage 100 Version 2022.0 today!

What’s New In Sage 100 2022

Add Public Favorites

You can add tasks and other items to the new public favorites group. These items are listed on the favorites panel when you click “public favorites”, and they’re available to all Sage 100 users. Previously these favorite groups were private to individual users though there were workarounds to copy them from one user to another.

Exclude Inactive Items from Lookups

A Display Inactive Items check box is now available in the ALE Lookups section on the Preferences tab in Company Maintenance.

Option to Save Data Selection for Reports

When creating or modifying report settings, you can now specify whether you’d like to save dates that have been entered in the selection grid. To save the dates, select the Save Data Selectcion check box that is now available.

Default Years To Retain History

The default setting to retain history in any module with a history option is now five years. We strongly recommend you increase this value to the maximum since you can always purge data but you cannot ever get it back ( once purged ).

Accounts Receivable – Pay Cycle Option

A new check box, Allow employees with other pay cycles for bonus and commissions, has been added to the Pay Cycle window that opens when you’re updating the Commission Edit Register.

Search for Quotes

A Quotes check box has been added to the Search for Open Orders windows accessed from the S/O tab in Customer Maintenance. Check this box to find quotes for the current customer.

Business Insights – Additional Views Added

  • History Work Tickets View
    • History Work Ticket Steps
    • Work Ticket Line Items
    • Purchase Order Line Items PM
  • Open Work Tickets View
    • Open Work Ticket Steps
    • Work Ticket Line Items
    • Purchase Order Line Items PM
  • Work Ticket Labor View
    • Open Work Tickets
    • Open Work Ticket Steps

Inventory Management – More Image Upload Options

When you’re uploading images in Item Maintenance, you can now use the following image types:

  • JPEG
  • PNG
  • TIFF
  • The above are in addition to existing JPG, GIF and BMP images

Inventory Management – Order Type Options For Sales Order Windows

When searching for Sales Orders using the Search for Sales Orders window, you can select check boxes corresponding to the order types to include in your search results. All sales order types are now available including quotes, master orders, and repeating orders.

Sage Intelligence Reporting – 64-Bit Compatibility

Sage Intelligence Reporting now works with the 64-bit version of Sage 100 and Windows. Previously you couldn’t access Sage Intelligence from the Sage 100 menu if using the 64-bit Sage 100 version.

Sales Order – Additional Views from History

The following fields have been added to the Sales Order and Quote History Inquiry window:

  • Order Type
  • Ship Date ( for standard and back orders )
  • Expire Date ( for quotes )
  • These fields have been added to SO_SalesOrderQuoteHistoryWrk table

Visual Process Flows

  • You can now select multiple elements at the same time by using the Shift key while selecting them with your mouse.
  • Buttons with up/down and left/right arrows have been added to the Actions window.
  • Guidelines now appear when you start to move an element to help you align it with other elements in the Designer window.
  • An underline button has been added to the text formatting toolbar
  • You no longer have to press the Enter key to add text to an element

Work Order

Production Management replaces Work Order as of Sage 100 2022.

What’s New Guide and Other Resources for Sage 100 2022

What’s new in Sage 100 2022 ( pdf )

Download Sage 100 2022 ( login required )

Sage 100 2022 Upgrade Guide ( web )

Supported Platforms ( kb )

What’s new in Sage 100 2022 ( web demo )

Release Notes.

Whats New In Sage 100_2022.0_Data Sheet.pdf

Filed Under: Sage 100 Tagged With: sage 100 2022

What File Prerequisites are Required by Sage 100 v2021?

April 15, 2022 by Wayne Schulz

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

Filed Under: Sage 100 Tagged With: prerequisites, sage 100

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

March 31, 2022 by Wayne Schulz

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.

Filed Under: Sage 100 Tagged With: sage 100

  • 1
  • 2
  • 3
  • …
  • 9
  • Next Page »
Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?
  • Error #0 Sage 100 – When Printing Registers After Microsoft Update
  • Is Sage 100 Compatible With Microsoft Windows Server 2022?
  • What’s New in Sage 100 Version 4.4 to 2021
  • What Is The Most Recent Product Update For Sage 100?
  • What’s Coming in Sage 100 2022?
  • Enhance Your Sage 100 Warehouse Processing With ScanForce WMS

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.

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