Creating Filters When Defining Data Sources

After you define a data source and set up the data source attributes, you can set up filters to limit the records included in the list. You can create many different filters depending on how you want to view the information.

To create a filter when defining data sources:

1. Click the Filters tab from the Data Sources tab.
2. Click the + (plus sign) to Add a Filter and display the Filter definition dialog.
3. Enter the Name for the filter.
4. Enter the filter criteria:
   1. Click Create Condition.
   2. Enter the conditions you want to use to create the filter definition expression (Conjunction, Attribute, Operator, Value).

Example of a Data Source Filter Using Age

An example of how a data source filter can help you is using the Age, calculated as Current Date minus the Accounting Date, to identify all unmatched transactions that are over 180 days old in order to write those off. Once you create that filter, you apply that filter to the Match Rule for Adjustments so that all the old unmatched transactions are automatically cleared or matched off as Adjustments. Similar to other adjustments created, you can then extract these as journal entries to the GL

Note:

The last used filter will be persisted (saved) for each user by match type, match process and data source.This means that you can log out and back in again, and if you open another reconciliation of the same match type, it shows the same filter.

Example of a Data Source Filter Using Status Attribute

Another example of how a data source filter can help you is using the Status attribute to filter. Note that the possible statuses are: Unmatched, Supported, Confirmed Adjust, Confirmed Match, Suggested Adjust or Suggested Match.