Aged A/P report - Lookup Words tab

See also: Lookup Words

Topic overview

The Aged A/P Report Lookup Words tab, as is shown in Figure 1, provides the ability to further filter the bills included in the report by Supplier Lookup Word.

System500002553.gif

Figure 1: Include by Lookup Word tab

Both the Include by lookup word tab and the Exclude by lookup word tab, shown in Figure 2, allow selecting from the Available Words by using the single and double arrow buttons.

System500002554.gif

Figure 2: Exclude by Lookup Word tab

The function and purpose of the Lookup Words Selection Criteria options are detailed in Table 1.

Item

Function and/or Purpose

Selection Criteria

  1. Must have all Lookup Words (AND)
    This criteria option instructs the report to include only those invoices that have all of the lookup words in the Attached Words list assigned to them.
    This is referred to as a logical AND selection criteria.

 

  1. Must have one or more Lookup Words (OR)
    This criteria option instructs the report to include only those invoices that one or more of the lookup words in the Attached Words list assigned to them.
    This is referred to as a logical OR selection criteria.

Table 1: Lookup Words Selection Criteria Options

The Add lookup word tab is shown in Figure 3.

System500002555.gif

Figure 3: Add Lookup Word tab

Use the other filters and options to select the desired records and then use this option to assign a specific Lookup Word to all of the Suppliers that meet the search criteria.

System500002556.gif

Figure 3: Remove Lookup word

Use the other filters and options to delete lookup words that being indicated in Attached words, Removed all lookup words from records selected in the report, this option removed all the lookup words below, Removed the specific lookup words selected below from records listed in the report, this report removed the specific lookup words based of choose.

< Return to: Aged A/P Report Overview
< Return to: AP Reports Overview