Searching for Products

You can search for products in various places throughout the system, such as Sales Order Entry and Purchase Order Entry. The system uses the same search criteria to find products as it does to find customers, vendors, and transactions. However, product searches offer additional options that allow you to get quicker, more narrowly defined search results.

To search for a product:

In a product entry field, enter keywords or special characters and press Enter.

When searching for products, the system compares your search criteria to values in the Product Description, Additional Key Words, and UPC fields on the Product Maintenance screen.

You can enter a product by preceding the Product ID with a period. For example, when you enter .1234, the system returns the product with the ID 1234.
Use the following special characters when searching for products:

If...	Then the system...
a forward slash (/) precedes the search criteria	searches for a product family or price line. For example, /delta returns a list of products in the DELTA family or DELTA Price Line.
two forward slashes (//) precede the search criteria	searches for a match on a buy line. For example, //SYL returns a list of products in the SYLVANIA Buy Line.
a forward slash (/) is entered as the search criteria	displays a list of product families and price lines.
a forward slash and a period (/.) precede the search criteria	searches for a match on products purchased in the last year by the selected ship-to customer.
a forward slash and a comma (/,) precede the search criteria	searches for a match on products purchased in the last year by all ship-to customers associated with the selected bill-to customer.
a forward slash and a semicolon (/;) precede the search criteria	searches for a match on products for which contract prices are in effect for the selected customer.

Expand your search, if necessary, by pressing F10 to move to one of the product indexes listed below. The system searches for the following groups of products in the order listed:
Active Products – The system first searches for products in this category. These products have been previously sold or purchased at your location, or they are physically on-hand. Your company can set how it wants to search for active products using the Display Active Primary Index Products First In Product Search control maintenance record.
Primary Index – Your company or branch assigns products this status. These products are items you plan to routinely sell or search for.
Catalog Index – Your company or branch assigns products this status. These products, often non-stocks, are items you do not routinely sell or search for, but are able to order.
PDW Catalog Index - Products in this group include every item sold or manufactured by the suppliers you specify. You must purchase the Product Data Warehouse (PDW) companion product to search the PDW Catalog Index.