Data Conversion hangs on IM_LotSerialTransactionHistory in Sage 100 2020 Product Update 1 (2020.1)

Summary

Data Conversion hangs (freezes) on IM_LotSerialTransactionHistory in Sage 100 2020 Product Update 1 (2020.1)

Description

Cause

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Download Program Fix IM6000T for Sage 100 2020.1 resolves this issue.

Possible Workaround:

  • Let conversion run until complete.
    • Caution: This may take hours. For those with several hundreds of thousands of records in the table, this may take a day or more.
  • If this is an upgrade, consider upgrading to just Sage 100 2020 for now, rather than Sage 100 2020 with Product Update 1

DocLink: What's New in Sage 100 Version 2020.1

Need more help?

Chat now

Defect ID

112421

Steps to duplicate

Steps to Duplicate* NOTE: Requires company data with over 100K records in IM_LotSerialTransactionHistory 1. Open Library Master, Main, Company Maintenance 2. Select Company 3. Click Convert 4. Click Proceed NOTE: Deborah Burke tested using customers data and discovered it took 3 minutes to convert\update 637 records in IM_LotSerialTransaction.

Solution Properties

Solution ID
220924560107126
Last Modified Date
Tue Apr 04 10:59:58 UTC 2023
Attributes
Product Details
Version: 2020
Views
0