Creating Filters and Saving Lists

Filters control the records that you see in a list. In Transaction Matching, let's take a look at using filters and lists on Unmatched Transactions.

Saved lists are specific to a data source within a match process within a match type. For example, you could create a saved list on the Bank data source within the POS_TO_BANK match process within the INTERCO_MMBT match type.

Lists provide these features:

  • Columns can be added to or removed from the view and re-ordered.

  • Filters can be applied to limit the records included in the list.

  • List views can be saved for future use by the user who created it or it can be made Public for other users if you are an Administrator or Power User. You can also set a Default View

You can create many different filters to change how you view Unmatched Transactions.

To create a filter:

  1. Click the filter icon to show the filter bar underneath it.
    Filter and Saved List
  2. Click on + (plus sign) to Add a Filter and display the Filter definition dialog.
    Filter condition dialog

    For example, let's create a filter condition to see Unmatched transactions. Note that by default, All transactions are displayed. Also, this is just one example of filtering on data source attributes.

  3. Click Create Condition.
  4. In Attribute, select Status.
  5. In Value, select Unmatched.

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.

Saving List Views

To save a list view:

  1. Adjust the view to see the data you would like by adjusting filters, columns or sorting..
  2. From View, click Save List.
  3. In the Save List dialog, enter a Name and optionally a description and click OK.
  4. Optionally, adjust the filter criteria if needed.

To see all the saved lists for that Match Type, click List at the top of the dialog.

Setting a Default List View

Another feature is Set Default. For a published saved view, an administrator or power user can set that view as the default so that saved list view will not only be available to all users of that Match type, but it will also be selected by default when a user opens that type.

To set a default list view:

  1. From Home, select Application, then select Configuration, and then select Lists from the left panel. The Lists dialog displays.
  2. Select Transaction Matching.
  3. Select the List View that you want to make the default and click the Set Default icon..
    Set Default List View

Publishing a List View

An administrator or power user can also select Publish at the top of the dialog to make that private version available to other users. The saved view is duplicated and there is now a private and public version. The public version will show a check mark in the Public column.

To make a list view public:

  1. From Home, select Application, then select Configuration, and then select Lists from the left panel. The Lists dialog displays.
  2. Select Transaction Matching.
  3. Select the List View that you want to make visible to other users and click the Publish icon..
    Set Default List View

Other Useful Links

For more information about views, lists and filters. see Working with Views, Lists, and Filters in Reconciliation Compliance.