Correcting Mismatched Item Quantities in Sage 100

What do you do when you notice that your Inventory Quantity numbers don’t match your actual quantities? The example below says there are 15 items on sales order, but I only can see orders for 10.

inventory-11

inventory-22

inventory-3

The best thing to do is rebuild your sort files; however, there’s a specific order that these need to be processed.

1. Go to Library Master | Utilities | Rebuild Sort Files.

inventory-4
2. Select your company code, select the purchase order module and click “Proceed.”

inventory-5
3. Select your company code, select sales order module and click “Proceed.”
4. Now select your company code, select inventory module and click “Proceed.”

When all three module sort files have been rebuilt, go back into your item. Your “on sales order” quantity now should be 10.

Learn about additional Sage 100 ERP topics here.

Robin Reeder

Robin is a member of the BKD Technologies Sage Software team. With more than 25 years of experience in public and private accounting, as well as accounting software support, Robin provides accounting and technology consulting services for a wide range of industries, including accounting software project management, installation, implementation, training and ongoing support services.

Robin Reeder – who has written posts on Sage ERP Insights.


Print Friendly, PDF & Email
The following two tabs change content below.
Robin Reeder

Robin Reeder

Robin is a member of the BKD Technologies Sage Software team. With more than 25 years of experience in public and private accounting, as well as accounting software support, Robin provides accounting and technology consulting services for a wide range of industries, including accounting software project management, installation, implementation, training and ongoing support services.
Robin Reeder

Latest posts by Robin Reeder (see all)

Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *