Inquiry Functions

Item Inquiry

Last Revised: 12/02/14

Item Inquiry is used to display all related information on file for a particular item.

The operator will be asked to enter an item number or press ENTER for items to appear in numerical sequence. The screen will display the description, list price and pricing unit, and all additional prices if any, the primary warehouse code and quantity available for that warehouse.

 

 

The Item Inquiry Screen
Note: Not all of the options may be available for a particular item. This can be determined by the asterisk that appears in the second column inside the window.

 

Item Inquiry
Second Column Codes
Blank A blank in the second column means that this option is not available for the item because there is no information to display.
* The asterisk denotes that there is information available for the item in this option and may be selected.
A This code means that there is no information to display for the item but the option is still available to enter information.
OPTIONS
Price Lookup This option shows the current pricing date, when the price was made effective, the cost calculation, the list price, the list price GM%, the formula used to determine the price, the pricing product class, the sell calculation, whether or not an exception applies to this item, and the pricing. You can also view this information for past or future pricing dates when applicable.
Customer Pricing The Customer Pricing option allows the operator to view any exceptions on pricing for a specific customer. The option shows any pricing other than standard. This could mean that you have given a discount to a particular customer for a certain item (I) or a certain product class (P); this information will display here as a list by customer.
Inventory & Open Orders

When selecting this option, a list of warehouses is displayed. Each one shows the following:

  • quantity on hand
  • quantity to ship
  • quantity available
  • quantity back ordered
  • quantity on order
  • stock status quantity
  • the MIN and MAX stock levels
  • the status

 

The "S" column displays a minus sign if the item is below the stock minimum and a plus sign if it is above the stock maximum.

 

If you select one of the warehouses, all open orders at that warehouse are displayed. Then you may select an order from that list.

On Hand Quantities & Values This option shows how many of this particular item are on hand in any warehouse, in transit, etc., and it shows the total monetary value of the items. The option also displays the average cost of the item.
Serialized Inventory Serialized Inventory is only available if the item you have selected is a serialized item. This option displays any serial numbers associated with this item. It also displays when the item was acquired, its rental ID and when it went into rent if applicable, the cost of the item when it was purchased, any related sales numbers. The "S" column indicates whether each item is available or not available for sale or rental.
Inventory Receipts

This option lists all of the inventory receipts that contain this particular item. It also displays the following:

  • the warehouse
  • the receipt's open and close dates
  • the type of receipt (such as purchase order or transfer order)
  • the receipt number
  • the reference number (such as PO# or TO#)
  • the quantity received on that receipt
  • the quantity available now
  • the cost of the item when it was received
  • and the pricing unit

 

If you select a receipt in this view, Dynamo will display all of the sales orders that consumed inventory from the PO reference on that receipt.

Inventory Usage Before Receipt Selecting this option shows the operator items that were sold before the purchase orders were received and posted to the system.
Average Cost History

Average Cost History displays all of the transactions that have affected the average cost for the selected item. It displays the following information about these transactions:

  • the calculation date
  • the type of order or transaction (such as purchase order or transfer order)
  • the date of the transaction
  • the reference# (such as PO# or TO#)
  • the transaction quantity (the quantity involved in the transaction)
  • the transaction cost
  • the unit of measure of the item
  • the company QOH (quantity on hand at the company before the transaction)
  • the new company average cost after the inventory transaction was posted

 

Monthly Usage by Warehouse This option displays the usage of this item by warehouse, month, and year. This usage may be sales, but it can also be any other type of usage.
Sales by Warehouse This option shows the amount of sales of this item by warehouse. It indicates the year, the units sold, the times the item was sold, the profit, the cost, the margin, and the GM%.
Serial # Purchase History This option can only be selected if you are viewing a serialized item. When the Partially Serialized option is selected, each sale of this product will be listed, including: Invoice Date, Invoice Number, Order Number, Line number on the Order, the purchasing Customer Number and Name, the serial number, price paid and discount, if any.

This function allows items to be tracked by what serial numbers a customer has purchased. Also see Serialized Purchase History Inquiry on the INQ menu.

Sales Orders/Invoices/Quotes When the Sales Order option is selected, the sales order numbers for this item will be listed within the warehouse, the order date, ship date, the quantity ordered, the quantity shipped, the price, the cost, the GM%, and the name of the company who ordered the item. This option also allows the user to view invoices and quotes. To jump to the quotes in the list, type a Q. The user can view additional details about an order by highlighting it and pressing Enter to select it.
Sales Order Assortments This option can only be selected if the item is a component of an assortment built on a sales order. In that case, it displays which sales orders where this item has been a component.
Purchase Orders When this option is selected, the purchase order numbers related to this item are listed in line with the warehouse, the date ordered, the amount ordered, the amount received, the date received, the cost, and the discount (if any).
Transfer Orders When this option is selected, the transfer order numbers related to this item are listed. The shipping warehouse and the receiving warehouse are also displayed for each time the item was transferred.
Vendor Returns This option displays all information about when this particular item has been returned to a vendor. This includes the date of the return.
Item Information When selecting this option, the operator will be able to view information for this particular item, including the primary vendor, the product class, the report sequence# (which can be used to sort items into a specific order on reports), whether or not inventory is tracked for it, if the item is serialized, if it can be sold without price information, if it is taxable, if commission is earned from it, the quantities found in packages, the weight, the volume, and information about any alternate items.
Warehouse Information

This option gives the operator information about the warehouse(s) in which this item can be found. It will list the warehouse, the ABC value, and any location information if specified in Warehouse Location Maintenance by Item. ABC Values are used to indicate how often an item is purchased.

General Ledger Information Selecting this option will list general ledger information to the operator. It will explain if the item was sold new, rented, or sold used. It will also specify whether inventory is tracked on the item, the product category, the product category type (costed or uncosted), the product class, and the G/L account# and account type for the Sales, Cost of Sales, and Inventory/Expense.
Bar Codes The Bar Codes option displays any bar codes that are associated with the item, including the 6-digit internal bar code, the UPC, or the EAN.
Vendor Part Numbers This option lists the item numbers the user's vendors use for this item. It displays the vendor number, the alpha name, the vendor part number, the cost, and the "as of" date, which is used to identify when vendor part numbers and pricing went into effect.
Assortments

The Assortments option displays whether or not this item is a parent of an assortment or a component of an assortment.

 

If it is a component, it will display the parent for that particular item.

 

If it is a parent, it will display:

  • whether it was manually or automatically created
  • whether or not it displays on Sales Orders, Receiving Documents, and Transfer Orders
  • the cost of the assortment
  • the amount of assortments that can be built from current inventory levels
  • the constraining item disallowing another assortment from being built
Equivalent Items In a multiple warehouse system the operator can enter a warehouse code for equivalents in a selected warehouse or Enter to display the equivalent items.

A single warehouse system will simply display the equivalent items. In either case the item description and quantity available will display.  At this point the operator can choose the desired equivalent or F4 to return to the options menu. If an item does not have any equivalents on file a message will indicate this and prompt the operator to hit Enter to return to the options menu.

Item Notepad

Item Notepad is a window where the operator is able to write additional information about that item. It does not interfere while entering sales orders or purchase.

Print Product Label This option will print a product label for this item if you have an Eltron or Zebra type printer. The label may contain an item number, a description, pricing information, a bin location, and a UPC or bar code.
Inventory Adjustments The Inventory Adjustments Option displays a list of all adjustments made to inventory for this item. The warehouse associated with the adjustment, the date/time of the adjustment, the type of adjustment, the amount affected by the adjustment, and a note about why inventory was adjusted are displayed here. Inventory adjustments are made through Inventory Transaction Entry on the I/C menu.

Video Documentation

Part [1] [2] [3] [4]