Inventory Inquiry
Previous Topic  Next Topic 

At the Order Number prompt, you may do an Inventory Inquiry. Enter an <I> and press <ENTER>. Enter the Customer Number for your Inquiry, and press <ENTER>. Next, enter the Part Number and press <ENTER>.


Point of Sale Alerts set up in "Point of Sale Alerts" in SALES MANAGEMENT (2.2.4.5.1), will be displayed. If a substitute part number is present in the alert, it can be selected to change the part being inquired upon.


The following information will be displayed in the lower help window: Part Number, Description, Alternate Number, Superseded Number, Group Code, Status, Unit of Measure, Location, Quantity on Hand, Quantity on Order, Due (Date that the Purchase Order is Due to arrive), Bin Location, Stock Level and all the prices. The Price Code for the customer will be highlighted. To view additional Location information not on the screen, use the Right Arrow and Left Arrow. Five locations may be displayed at one time. If your system has more than five locations, the current port location will be highlighted.


NOTE: Only those price codes set up in “POS Defaults & Comments” in SYSTEM MANAGEMENT (10.2.6.2 field 4 page 1) will be displayed.

To view another part number, enter a <C> and press <ENTER>.


To Exit the Inventory Inquiry, press a <\> at the Enter Selection prompt and press <ENTER>.



If the Part Number has one or more Alternate Part Numbers, an <A> will appear in the help section.


Enter an <A> and press <ENTER>.


The Alternate Part Number Lookup will appear. The Quantity On Hand(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.


Quantity on Hold is included in the Quantity on Hand when calculating the Warehouse (Average) Cost. Since the Quantity on Hold is not actually gone from the inventory, this makes the calculation more precise.


Hold Unit at POS indicator -

       In Inventory Inquiry, a highlighted "H" will appear before the unit of measure if Hold Unit at POS is set to "Y" in Inventory Entry (5.1.1 field 31)


The Price Code for the customer will be highlighted. If the customer has a Special Price for the part, it will also be highlighted. The Special Price will be located under the normal price for this customer. The Customer Last Price (Price Code 95) displays the Last Date in which the item was purchased at this price. Price Code 95 will be a negative number if the last price posted was from a Credit Invoice (CI) or Warranty Invoice (WI).


To view additional price codes and prices not on the screen, use the Up or Down Arrow.


If the part has Quantity Discount Pricing for this customer, you will be prompted with the following:

“<S>=Qty Pricing”.


To view the Quantity Discount Prices, enter an <S> and press <ENTER>. 


The quantity breaks and prices will be displayed. Use the Up or  Down Arrow to scroll through the price codes. To exit, press <\> and <ENTER>.


If you do not have a particular item in stock that the Customer wanted, you can track the part as a Lost Sale at the Part Number Inquiry.


Enter an <L> and press <ENTER>. Enter your Salesperson code and press <ENTER>. Enter the quantity lost and press <ENTER>. Enter an <S> to Save or <E> to Edit the above and press <ENTER>.


You may run the "Lost Sales Report" (1.7.1) to get a list of your Lost Sales.


You may view the Quantity Back Ordered (QBO) for the part number.


Enter a <B> and press <ENTER>. The Bin Location will be replaced with the QBO.