Inactive inventory items with Quantity On Hand will cause a discrepancy between Inventory Valuation reports and the totals for your inventory asset account(s) on the Balance Sheet.
In my way of thinking the quickest way to identify these items is by using the Troubleshoot Inventory tool found within the Inventory Section of Client Data Review contained in QuickBooks Accountant and QuickBooks Enterprise Accountant. This tool has a lot of great uses, but it enables you to find inactive inventory items with quantities on hand with the click of a single ‘filter’......