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.
- Verify all Inventory Transaction batches have been updated
- Open Library Master, Utilities, Rebuild Sort Files
- Click the OK button at the warning message
- Click the Module Code dropdown and select Inventory Management
- In the Company Code box, enter the Company Code and click Proceed
- 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:
- Open Library Master, Utilities, Reinitialize Data Files
- Click the OK button at the warning message
- In the Company Code box, enter the Company Code
- Click the Module Code box and select Inventory Management
- In the Reinitialize column, select IM_TransactionTierDistribution and click Proceed
- Click the Yes button to exit
- Repeat Steps 1 through 7 above