The match group dataset filter is the first layer of filtering that can be applied at the match group dataset level.
Use the Match Group Dataset Filters form to filter transactions for a specific match group:
- Select Explorer in the navigation pane.
- Expand Fluence > Transaction Matching > Maintenance folders, and open the Match Group Dataset Filters form.
Note: Alternatively, open this form by selecting the Filters link from the Match Group Datasets form. The Match Group and Dataset parameters are automatically passed, and the form opens with the corresponding rules for that match group and dataset.
To filter transactions for a specific match group, fill out the fields in the form:
| Field | Description |
| Field | Select a column name from a list of column names in the transaction table associated with the dataset. |
| Operation | Operation for filtering the list of options. This depends on the Field chosen. |
| Value | This value is used for comparison. It should be the same data type as the Field. For example, if the Field is numeric, the Value should be numeric. For the date type, the accepted format is YYYYMMDD. This field is required for all operations except empty and not empty. |
| Additional Value | This field is used only for the operation between. In this case, it shows the upper limit of the between statement. For other operations, it must be left empty. |
A dataset may be used in multiple match groups. For example, the bank transactions dataset may be used in multiple match groups. Each match group might be specific to a business unit, account, or transaction type, which is a common scenario. In this case, the general ledger data dataset you created will be compared to the bank dataset.
You will apply filters for match group datasets, which are optional. You can access the match group filters by opening the Match Group form and then selecting the Filters link.
You can filter a dataset based on criteria. Within the bank transactions dataset, you can filter the data based on criteria, such as the bank reference numbers that Start with, End with, Contain, or Equal to 9999. You can apply as many filters as needed to the bank dataset. This filtering step is the first pass. Transactions that don't meet these conditions won't be considered in the matching process. You can also create other match groups that use the bank dataset but with different filters, such as excluding transactions where the bank reference number equals 9999.
In other solutions, this might require ingesting the same data source multiple times to prevent transactions from appearing in match scenarios where they don't belong. This feature helps avoid that issue, especially when working with account numbers in the bank transactions dataset.
After setting the filter, you can apply a similar filter to the general ledger Data dataset. For example, you might only want account numbers that start with 100 to be processed. This ensures that only those accounts are considered for matching with the GL dataset. Transactions that don't meet the filter criteria won't be processed by the matching rules.
Select Save Data in the Excel ribbon to apply the filters.
After saving the changes, you must run the matching rules for them to take effect:
- Select Process Matching Rules, then
- Create a Calculation task in an existing workflow or a new one, save, and run the process.
