Skip to Content

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.

 

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