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

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

  1. Select “Yes.”
  2. Enter the company code.
    Quantity on Hand in Custom View Doesn’t Match Inventory on Hand
  3. 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

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

Colleen Gutirrez

Colleen, a senior consultant with BKD Technologies, has more than 18 years of experience as a technology consultant, performing needs assessments and analyses and providing system selections, implementations, installations, training and support for a variety of industries. She also implements, supports and provides training on Sage ERP 100 and 500 accounting applications and Sage Intelligence.

Colleen Gutirrez – who has written posts on Sage ERP Insights.


Print Friendly, PDF & Email
The following two tabs change content below.
Colleen Gutirrez
Colleen, a senior consultant with BKD Technologies, has more than 18 years of experience as a technology consultant, performing needs assessments and analyses and providing system selections, implementations, installations, training and support for a variety of industries. She also implements, supports and provides training on Sage ERP 100 and 500 accounting applications and Sage Intelligence.
Colleen Gutirrez

Latest posts by Colleen Gutirrez (see all)

Leave a Reply

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