Schulz Consulting

Consulting and Upgrades

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

Slow Sage 100 Data Conversion after v2020 Product Update 1 – FIXED

October 22, 2020 by Wayne Schulz

If you are experiencing a slowdown in speed – specifically when it comes to converting the IM_LotSerialTransactionHistory.M4T file which may seem to hang or freeze during conversion – you should consider installing this fix.

Sage noticed some users who already had Sage 100 2020 installed and who later updated with product update 1 for Sage 100 2020 were complaining that the update of the underlying inventory data took a long time. In some cases, the process appeared to hang.

The bug appears to have been introduced along with a new feature which offers the ability to trace the usage of a lot/serial item through production.

See a complete list below of the features that Sage 100cloud 2020 Product Update 1 introduced.

What’s New In Sage 100 2020 Product Update 1?

The following changes were made in update 1 for Sage 100 2020 released on 09/17/2020:

*some features are only available if Sage 100 was purchased through a subscription plan

Accounts Payable

  • A Net Balance button has been added to add the undistributed balance to the current line
  • Nonemployee Compensation has been added to the Form Type list in Form 1099 Tax Reporting

Accounts Receivable

  • Payments Tab Added to Invoice History Inquiry
  • AR_OpenInvoicePaymentsToday_ui utility has been added to replace ARWAR4
  • ARWAR4 still exists on Sage 100 2020.1, but will no longer exist on Sage 100 2021
  • AR_OpenInvoicePaymentsToday_ui can also be run in Task Scheduler *Click here for more information


Fixed Assets

  • Update in Period End Processing
  • The posting book check boxes in the Period End Processing window have been replaced by a grid with Book Name and Close Book columns
  • The Close Book column contains check boxes that you can select for the books that you want to process for period end
  • This change was made to support the additional posting books added in Sage Fixed Assets version 2021


Inventory Management

  • Ability to Trace Item Use by Lot and Serial Number
  • A Where Used button has been added to the Lot/Serial Inquiry window accessed from the Main menu or from Item Maintenance
  • Additional changes have been made to the Lot/Serial Inquiry window accessed from the Main menu
  • The item code and description now appear on the main window instead of in the list box
  • If a lot or serial number has more than one item associated with it, the Item List window automatically opens so that you can select an item
  • The item code has also been removed from the Search for Lot/Serial Transactions window
  • The Zoom button has been renamed History Inquiry
  • When you click the OK button, the information displayed in the window is cleared, and you can select a different lot or serial number
  • Customer Recall Report has been added to the Reports menu, and it can be accessed from Lot/Serial Inquiry when the task is accessed from the Main menu
  • A Print Where-Used Items check box has been added to the Lot Serial Transaction History Report


Library Master

  • Ability to exclude Tasks and Events from Role and User Reports based on access


Visual Integrator

  • A Filter List button has been added to the Job Log window
  • Export Option for Job Log
  • The row number from the source file now appears in the Job Log for ASCII & delimited files
  • ALE lookups are now used when selecting jobs
  • Browse buttons have been added to the Record Detail window
  • Ability to use company-specific background colors

Filed Under: Sage 100 ERP, sage 100cloud Tagged With: product update 1, sage 100 2020

What’s New in Sage 100 4.4 through 2020?

April 19, 2020 by Wayne Schulz

Sage 100cloud version 2020 was released on March 18, 2020. This update includes new features including the ability for customers to pay by credit card from an emailed invoice, multiple Purchase Orders on one receipt of goods/invoice and an easier way to reverse an entire run of Accounts Payable checks.

While Sage offers an extensive overview of new features in their Customer Upgrade Guide ( 2020 Version ), I’ve summarized dozens of pages into the top new features for each release starting with version 4.4 and ending with the latest 2020 release.

This What’s New Brief – Sage 100 4.4 to 2020 is available here. Please print it or refer to it as you go about your Sage 100 upgrade.

Filed Under: sage 100cloud Tagged With: sage 100 2020

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
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
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.