1.5 Inventory Inquiry
Previous Topic  Next Topic 

Inventory Inquiry is used to check your inventory status of any item.


After selecting the Part Number, the following information will be given: Part Number, Unit of Measure, Standard Pack, Creation Date, Description, Notes, Group Code, Alternate Number, Taxable Indicator, Status, Case Lot, Item Type, Superseded By, and Superseding Number.


If the Part Number has one or more Alternate Part Numbers, an <A>lt will appear in the help section. Enter an <A> and press <ENTER>. The Alternate Part Number Lookup will appear. The QOH of each Alternate Part Number will be displayed. Enter the number of the Alternate Part Number to change the Part Number to, and press <ENTER>.


This feature is very useful if the original Part Number entered has zero (0) QOH and you wish to give the Customer an alternative. The QOH of the Alternates will appear.


Hold Unit at POS indicator -  "On Hold" will appear after the Unit of Measure in the upper highlighted bar if the Hold Unit at POS is set to "Y" in Inventory Entry (5.1.1 field 31)


If the item is on a Transfer Purchase Order, a “T” will be displayed after the Due Date. The item may be on a regular Purchase Order, as well as a Transfer Purchase Order.


The history is displayed for each Location showing Quantity on Hand, Quantity on Order, Due Date of Order, Bin Location, Popularity Code, Sales History and all the Prices to display. The Quantity On Hand, Quantity On Order, Due Date, Quantity Back Ordered, Bin Number, Location, and Popularity Code will be displayed for each Location.


To view additional Location information not on the screen, use the Right Arrow and Left Arrow. If your system has more than five locations, the current port location will be highlighted.


The Quantity Sales History is displayed for each location. The Sales History includes Month-To-Date, 1 Month Ago, 2 Months Ago, 3 Months Ago, Year-To-Date, Average Last Year, and Last Average.


A list of Price Codes & Prices that are set up in “POS Defaults and Comments” in SYSTEM MANAGEMENT (10.2.6.2 field 4) is displayed. To view additional price codes and prices not on the screen, use the up and down arrows.


If a part number that has been superseded is entered, the first Price Code description will be listed as “Superseded”. This will flag the counterperson that this part number is not a good number for quoting prices.


After you have viewed a Part Number, to view another Part Number, Enter an <X> and press <ENTER>.


If you want to view another Unit of Measure, enter a <U> and press <ENTER> at “Selections”. The Quantity On Hand(QOH), Quantity On Order(QOO), Due Date, Bin Number and Location will be displayed. Type in the Selection Number and press <ENTER>.


You may Display Quantity on Hold Detail by typing a <Q> and <ENTER>. This option will display all Orders and Transfer Purchase Orders that comprise the total Quantity on Hold for a Part Number/Unit of Measure.


Within this feature, you may scroll through the items or scroll through different units of measure. A <P>rint option is available to get a hardcopy of all items within the list being displayed. Selecting the <L>ocation option brings up a prompt to change the Location being viewed. Additionally, you may select an item to display the Order or Purchase Order on which the Part Number/Unit of Measure appears.


If you have multiple accounts and you want the other accounts' Quantity on Hand information to appear in this screen, there is a setup at TCL to enable this functionality. At TCL type: U MASTER PM.OTHER.CO. Enter each account on a separate line. Press <CTRL> <X> <F> to save.