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

Home » Categories » NCR Counterpoint » Setup » System » Configuration

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.

 

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to modify the lookup for quotes, holds, orders, and/or layaways to show all stores or all stations?
Viewed 1798 times since Mon, Jun 2, 2014
How to prevent price changes during a Receiving
Viewed 880 times since Wed, Aug 6, 2014
How to define a column from a LookUp as a Keyword
Viewed 1479 times since Wed, Sep 3, 2014
How to change the default directory for Reports in NCR Counterpoint
Viewed 1910 times since Mon, Jun 22, 2015
How to change the field labels on Ticket Profile Fields
Viewed 1438 times since Tue, May 20, 2014