Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

Hand touching the screen on a phone

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?

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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.”

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

You will receive a warning message.

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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.

Quantity on Hand in Custom View Doesn’t Match Inventory on Hand

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.

Kate & Ben — How can we help you? Contact Us!

How can we help you?