Find Supplier window

Topic Overview

The Find Supplier window, shown in Figure 1, is used to locate existing supplier records in the database.

Access

To access supplier records, use the following Navigator menu path:

Accounts Payable > Suppliers

System500001881.gif

Figure 1: The Find Suppliers window

Window parts descriptions

The Search Criteria boxes & Options

Search filters and criteria are detailed in Table 1.

Filters and Criteria

Description

Criteria 1

Name

The supplier's name as it appears in the Business Name field in the Supplier Record.

Phone

The supplier's phone number (can be the last 4 digit).

Account #

The supplier's account number.

City

The city in which the supplier is located.

Address

The supplier's address.

Zip/Postal

The supplier's postal/zip code.

Criteria 2

Contact First

Contact's first name.

Last

Contact's last name.

State/Prov

Select in the dropdown the specific state or province.

Filters

Unique

The supplier's record unique number as assigned by System Five.

Lookup Word

A lookup word assigned or attached to the supplier.

Email

The supplier's email address.

Department Filter

This filter is only available if the option Use departments for Customers and Suppliers is enabled in the Setup Wizard.

Live Search (checkbox)

When enabled, System Five will search after each alphanumeric value. Otherwise, if not enabled, you need to press the [ENTER] key to trigger the search.

Table 1: Find Supplier Search Criteria and Filters

The Results listing

Below is an example of the information that appears as a result of a search.

System500001882.gif

The grid in this window is customizable. To customize the columns displayed in the grid right-click anywhere a in the grid and select the Customize command from the pop-up menu. The Grid Options dialog box appears as shown below.

System500001883.gif

To add a currently hidden column, highlight it in the Hidden column list and then click [Show Column] to add it to the preview grid.

To hide a currently viewable column, highlight it in the preview grid and then click [Hide Column] to add it to the Hidden column list. Once you have the grid the way you want it, click [OK] to accept your changes.

< Return to: Overview

The Toolbar

The Toolbar has a number of buttons that perform specific functions to help you while searching for suppliers. The Toolbar is shown below:

System500001884.gif

[Ok]

When a supplier record is selected in the Results listing, this button opens the record in the Supplier Details window and closes the Find Supplier window.

[Cancel]

This button closes the Find Supplier window without making a selection.

[Recent]

This button displays up to the last 50 records added. (If less than 50 records exits, then all records are displayed in the Results listing)

[Edit]

When a supplier record is selected in the Results listing, this button opens the record in the Supplier Details window, but leaves the Find Supplier window open. This saves time if you need to edit a series of supplier records that all match a specific set of criteria.

[New]

This button creates a new supplier record and open it in the Supplier Details window. Supplier routines allow a user without edit permissions to add new records.

[Delete]

This button deletes the currently selected supplier record.

[Clear]

This button clears the criteria boxes and close the Find Supplier window. If the Find Supplier window is displayed by a Supplier selection box in another window, then the [Clear] button clears any value in the Supplier selection box.

[Print]

Prints the Results listing.

Pervasive.SQL Option

If you have Pervasive.SQL enabled, you have the ability to search within a field by using a % sign prefixing your search criteria. For example, if you want to find a supplier by typing 'Parmley Place' in the address field, click in the address field and type: '%parmley place'. This then searches the address field in your supplier database for any instance of Parmley Place and return the matching records in the Results Listing


< Return to: Overview
< Return to the Accounts Payable menu overview