How to display Quantity on Hand / Quantity Available on the Item Lookup screen

Summary:

How to display Quantity on Hand / Quantity Available on the Item Lookup screen (Inventory / Items)

Solution: 

Change the lookup (under inventory / items) to use a view instead of the default im_item table.

• In Setup/ System/ Configuration/ Data Dictionary, select the IM_ITEM table from the System Data Dictionary
• Choose to customize the ITEM_NO column, which automatically opens the Data Dictionary window.
• Select the Other tab
• Set Lookup Table to select the desired view to be used: VI_IM_ITEM_WITH_INV, or VI_IM_ITEM_WITH_INV_TOTS, etc. 
• Set Lookup Field to ITEM_NO
• Set Lookup Display to DESCR

This will display the quantity for the location assigned to the workgroup being used.

Article ID: 263
Created: August 6, 2014
Last Updated: March 19, 2015

Online URL: https://counterpoint.knowledgebase.co/article.php?id=263