Sage 100 Serialized Inventory Quantity is Incorrect

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.

  1. Verify all Inventory Transaction batches have been updated
  2. Open Library MasterUtilitiesRebuild Sort Files
  3. Click the OK button at the warning message
  4. Click the Module Code dropdown and select Inventory Management
  5. In the Company Code box, enter the Company Code and click Proceed
  6. At the “Do you want to recalculate committed lot/serial quantities?’ prompt, click Yes

 

If the above steps do not resolve the issue, reinitialize the IM_TransactionTierDistribution.M4T file and rebuild sort files again for Inventory Management module:

  1. Open Library MasterUtilitiesReinitialize Data Files
  2. Click the OK button at the warning message
  3. In the Company Code box, enter the Company Code
  4. Click the Module Code box and select Inventory Management
  5. In the Reinitialize column, select IM_TransactionTierDistribution and click Proceed
  6. Click the Yes button to exit
  7. Repeat Steps 1 through 7 above