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.

 

Posted - August 6, 2014. This article has been viewed 5464 times.
Online URL: https://counterpoint.knowledgebase.co/article.php?id=263

Powered by PHPKB (Knowledge Base Software)