Searching for Information

You can search the system in two ways:

To search with words and numbers:

To search with special characters:

  1. Use the following special characters in all searches throughout the system:

If...

Then the system...

a period (.) precedes numeric search criteria.

searches for the record ID.

For example, in Customer Maintenance, .1234 returns that customer ID.

search criteria is followed by a period.

searches for an exact word match.

For example, elec would return ELEC but not ELECTRIC.

search criteria is followed by a forward slash (/).

searches for an exact match anywhere in the word.

For example, opp/ would return COPPER or STOPPER.

When searching, the more information you enter, the fewer matches the system returns for your selection. Use the various special characters above as searching shortcuts.

Use Index Searching to search for a product, customer, or transaction number. Index Searching returns exact matches when you enter detailed search criteria and lists possible matches when you enter less detailed criteria.

Additional Search Tips

Use some of the following tips when searching:

Searching for Customers, Vendors, Products, or Transactions

You can search the system for customers, vendors, products, and transactions.

To search for customers or vendors:

  1. Search using either word criteria or special characters.

When searching for customers or vendors, the system compares your search criteria to the values in the Name and Index fields on the Customer Maintenance screen and Vendor Maintenance screen, respectively.

  1. Also search for a customer or vendor by using telephone numbers or zip codes:

If you enter...

Then the system displays...

A 10-digit telephone number

the customer or vendor matching the telephone number.

The last four digits of a telephone number

the customers or vendors whose telephone numbers end in those four digits and whose Zip Code begins with those four digits.

A five-digit Zip Code

the customers or vendors whose Zip Code matches the search criteria.

Remember that you can enter a customer or vendor by preceding the Customer ID or Vendor ID with a period (.1234, for example).

To search for products:

  1. Search using either word criteria or special characters.

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

  2. 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 up how it wants to search for active products using the Display Active Primary Index Products First In Product Search control maintenance record.

  3. Primary Index - Products are assigned this status by your company or branch. These products are items you plan to routinely sell or search for.

  4. Catalog Index - Products are assigned this status by your company or branch. These products, often non-stocks, are items you do not routinely sell or search for, but must be able to order.

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

To search for an existing transaction:

See Also:

Using System Screens

Understanding System Fields