There is a technique for linking to the IM_ItemWarehouse file to show QoH in an item lookup, but it only works for one warehouse.

An Excel spreadsheet query of that table, (with Refresh-All pulling in current numbers) could do the same thing through ODBC, although searching could be less than user friendly if your product list is long.

I would suggest Item Quantities by Warehouse View  under Explore in Inventory. You can quickly filter by product line and item  and QoH.  We use the builit in UDFs for size and class on the valves so we can quickly see how many valves on hand for what size and poundage. 

I'll look into that module, its not one that I've used before. For my position we usually only use Sales Order Entry or Item Inquiry, and a few places the buttons within those two modules lead to. 

thank you but, this solution is above my current skill and authorization level.