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.