Lookup

Click the Lookup () button to display a list of possible values for an associated fill-in field (for example, Supplier Code). If you want to start at a value other than the first value, enter a starting value in the fill-in field before clicking this button.

Example To look up Bill’s Supplies in the Supplier Name field, enter Bi, and then click the Lookup button. The Lookup window appears, and displays every supplier name in ascending (alphabetical) order starting with suppliers that start with Bi.

For some fields, you can also use an asterisk as a wildcard value for the fill-in fields (for the list of fields, see Filters below).

A Lookup window appears when you click the Lookup button.

Note By default, Lookup windows display 50 records at a time.

The Lookup window has the following functions.

Function

Description

Sorting

Images\grid_sort_arrow2_32.gif

Click any column header and an up arrow will appear to signify that the column is sorted in ascending order.

NOTE You cannot sort by a column that was added to the Lookup window by using Browser Column Maintenance.

Images\grid_sort_arrow_32.gif

Click the same column header again and a down arrow will appear to signify that the column is now sorted in descending order.

Note To add multi-column sorting (secondary, tertiary, etc.), hold down the Shift key while clicking other column headers.

Position To

This field works in conjunction with the primary column selected. Enter a value in this field if you want the Lookup window to start with this value. Click a column header to select a different column.

Note Click the Show Data toolbar button to refresh the Lookup window.

Filters

Images\grid_filter_32.gif

Select the filter button on a column to filter the records being displayed. If you select (Custom), the below filter window appears with available filtering options.

Images\filter_options.gif

If you are looking up a value for one of the following database fields, you can also filter using the Filters radio buttons:

  • asset-def.asset-name

  • custname.cust-name

  • dnu-custname.cust-name

  • etm-element-help.system-id

  • etm-seg-help.system-id

  • etm-session-hdr.system-id

  • etm-trans-help.system-id

  • gl-accts.report-label

  • glgroups.group-desc

  • oe-cust-prod.customer-product-id

  • oe-cust-prod.customer-product-name

  • product.description

  • product.long-description

  • product.product-name

  • std-remarks-txt.remark-txt

  • suppname.supplier-name

  • web-category.long-desc

  • web-category.short-desc

  • web-product.web-long-desc

  • web-product.web-search-words

If you use this latter type of filter, select the Some radio button, enter filter criteria, and click the Show Data toolbar button. Only the data that matches your filter criteria displays. You can also enter an asterisk as a wildcard character.

Example You can enter ha* to find the customer named The Hat Store.

Note If you enter a filter value and a value in the Position To field, both are used.

If the default sort/filter grid column for the Lookup window is one of the above database fields, you can enter a filter value (instead of a starting value) in the fill-in field associated with the Lookup window to filter by that value. To do this, you must use an asterisk wildcard character.

Example The customer name is the default sort/filter grid column for a Lookup window associated with a customer code fill-in field. You enter Sto* in the fill-in field, and then click the Lookup button for the field. The Lookup window displays all customers with names that include Sto, such as The Dollar Store.

Filter By Element

In a Lookup window for a general ledger account or product code, you can filter by account or product code elements. To use this feature, select the Filter By Element check box, enter a value for one or more elements in the Position To fields, and click the Show Data toolbar button.

Example You want to view general ledger accounts with 1100 as the second element. You select the Filter By Element check box, enter 1100 in the second Position To field, and click the Show Data toolbar button.

Column Arranger

In the Lookup window, right-click and select Column Arranger to rearrange the view order of the columns.

Note Alternatively, you can drag-and-drop a column (Click and drag the column header) from one position to another position.

Add Columns

Select this option to add columns to a grid in Browser Column Maintenance.

Note You cannot sort by added columns.

Auto Size Columns

Select this option to resize all columns in a grid to display all data using the least amount of space.

Drop Browser Settings

In the Lookup window, right-click and select Drop Browser Settings to display Drop Browser Settings, which allows you to save the default options for positioning and sorting data in the Lookup window grid.

Export All

In the Lookup window, right-click and select Export All to export all data in the grid to Excel. This is useful for creating listings of your data.

Export Cache

In the Lookup window, right-click and select Export Cache to export cached data in the grid to Excel. This will export a smaller amount of data, but may be much quicker than exporting all data.

Scrolling

Use one of the following methods to scroll through the records:

  • Scroll bar - Use the vertical scroll bar on the right.

  • Scroll wheel - Use the mouse scroll wheel to scroll up and down.

  • First/Last buttons - These buttons can be used to display the first or last page of 50 records.

  • Page Up key - Scroll up one page.

  • Page Down key - Scroll down one page.

  • Up Arrow key - Scroll up one row.

  • Down Arrow key - Scroll down one row.

  • Left Arrow key - Scroll left (equivalent to clicking the left arrow button in the scroll bar).

  • Right Arrow key - Scroll right (equivalent to clicking the right arrow button in the scroll bar).

  • End key - Scroll down to the last record.

  • Shift+Left Arrow key - Scroll left

  • Shift+Right Arrow key - Scroll right.

  • Shift+Home - Scroll to first column.

  • Shift+End - Scroll to last column.

For more information on using the grid in a Lookup window, see Grids and Basic Grid Features.