Inventory Inquiry
Previous Topic  Next Topic 

An Inventory Inquiry may be done from any field of the Line Item Entry.


If there is a Part Number listed on the line, the Inventory Inquiry will be for that Part Number. To view the Inventory Inquiry for this Part Number type an <I> at the first position anywhere on the line and press

<ENTER>.


The information displayed in the lower help window will be the following: Part Number, Description, Alternate Number, Superseded Number, Group Code, Status, Unit of Measure, Location, Quantity on Hand, Quantity on Order, Bin Location, Stock Level and all the Prices for each location. 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.


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 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.


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. To view additional price codes and prices not on the screen, use the Up Arrow and Down Arrow.


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


Also in "POS Defaults & Comments” in SYSTEM MANAGEMENT (10.2.6.2) field 80 page 4)


If a price code is not included in field 4 of POS Defaults and Comments, the price will not display. This flag allows the user to view the price code and price for a specific customer, even if the price code is not normally visible during inquiry.  Any special pricing setup for the customer will continue to be displayed.


The Customer Last Price Code (Price Code 95) will be a negative number if the last price posted was from aCredit Invoice (CI) or Warranty Invoice (WI).


The Customer Special Price may be set for Automatic Rounding in “POS Defaults & Comments” in SYSTEM MANAGEMENT (10.2.6.2 field 40 page 3). The rounding affects the cents. The following rounding options are available: Auto Round Up everything rounds up to the nears 5 or 0, Round Down everything rounds down to the nearest 5 or 0, and Average Rounding everything rounds to the nearest 5 or 0 (i.e. 1-2 =0, 3-4 = 5, 6-7 = 5, 8-9 = next higher 0).


If the part has Quantity Discount Pricing for this customer, there will be the prompt: “<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 Arrow and Down Arrow to scroll through the price codes, if applicable. 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. 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 view the Quantity Back Ordered (QBO) for the part number. Enter a <B> and press <ENTER>. The Bin Location will be replaced for the QBO.


After you have viewed a Part Number, you may view another Part Number. Enter a <C> and press

<ENTER>. Now follow the directions above for viewing the Part Number information.


To Exit the Inquiry, press a <\> and press <ENTER>.