3.3.1 Inventory Inquiry
Previous Topic  Next Topic 

The Inventory Inquiry feature gives you valuable Inventory information on one screen.


The history is displayed by Location showing Source & Cost, Standard Pack, Warehouse Cost, Quantity on Hand, Quantity on Order, Due Date of Order, Order Level, Stock Level, Popularity Code, Sales History and Purchasing History.


The Part Number Information will be displayed. The information will be the Part Number, Creation Date, Description, Notes, Group Code, Alternate Number, Taxable Indicator, Status, Case Lot, Item Type, Superseded By, Superseding Number, Total Quantity on Hand, Total Quantity on Hold, and Total Quantity on Order.


When placing an Order on Hold during "POS Order Entry" in POINT OF SALE (1.1) whether a DI (Debit Invoice) or a TI (Transfer Invoice), all items will increment the Quantity on Hold (QHD) in the Inventory file. The Quantity on Hold is already downcounted from the Quantity on Hand.


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.


Information on each Unit of Measure will also be displayed. Information included is: Current Source, Standard Pack, Warehouse Cost, Quantity On Hand, Quantity On Order, Due Date of Order, Order Level, Stock Level, and Popularity Code.


If there is more than one source for the Part Number, use the <Up Arrow> and <Down Arrow> to scroll through each one. This will show the Current Source and Prices.


You also have the option to Display Quantity on Hold Detail by entering a <Q>=Disp QHD. 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.


After you have viewed a Part Number, you may view another Part Number. Enter an <X> and press <ENTER>, you will be at the "Part #" prompt.


To view the history of the part, press <H> at the Enter Selection prompt and press <ENTER>. To scroll through the sources, use the <Up Arrow> and <Down Arrow>. The Source History will display the following: Vendor Number, Vendor Name, Invoice Number, Invoice Date, Quantity, Unit of Measure, and Cost.


A <c> preceding the Invoice Number denotes it as a canceled order.


A <b> preceding the Invoice Number indicates that the order is back ordered.


An <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)


To scroll through the Sales History for the Units of Measure, use the <Left Arrow> and <Right Arrow>. The Units of Measure Sales History will display the following: Sales History (Month to Date, Last Month, 2 Months Ago, 3 Months Ago, Year to Date, Last Year), Sales (quantity), and Lost Sales (quantity) for each Unit of Measure.


To redisplay the Inquiry screen, press <ENTER> after viewing the Sales History.