Have you ever created a custom view and noticed the quantity on hand in the view doesn’t match the inventory valuation report or stock status report?

This situation can occur because Sage is storing this value in a separate file stored in Common Information. All the reports in Inventory reflect the correct quantity, but this lookup value can be different. Rebuilding the sort files in Item Display and Maintenance or Recalculate Item History will not correct this situation. The only way to put them all back in synch is to run a hidden utility.

Here are the steps to do that:

1. From the main menu of Sage, select File | Run.
2. Type in “*utl” and click “OK.”

3. Select “Balance Inventory Quantity and Cost” and click “OK.”

You will receive a warning message.

4. Select “Yes.”
5. Enter the company code.

6. Select the item, items or warehouse codes that need to be corrected and click “Proceed.”

The message below will appear. When the only incorrect item is on the lookup screen, there should be no adjustments made. Be sure to review the spreadsheet to verify.

7. Select “Yes.”

Check your custom lookup—it should match all the reports.

If you have any question on this or other subjects, please contact us.