Match Rule Details form lets you set up matching rules and control how transactions on two datasets can be compared and matched. The Rule Type parameterispassed automatically when you open this form from the Match Rules form.
Use the Match Rule Details form to add match rule details:
- Select Explorer in the navigation pane.
- Expand Fluence > Transaction Matching > Maintenance folders, and open the Match Rule Details form.
Note: Alternatively, you can open this form by selecting the Details link from the Match Rule Details form. The Rule Type parameter is automatically passed, and the form opens with the corresponding rule details for that rule.
This form looks slightly different depending on the match rule type. For One-to-One rules, there are two tables, one for Filters and the other for Matching Criteria. For Many-to-Many rules, there's one extra table called Grouping to specify how to group multiple transactions within each dataset.
There are two matching rule types you can choose from. One to One is a special case of Many to Many, where transactions aren't grouped. This is the same for Many to One and One to Many. If you don't group the transactions on one side, only one transaction will be used for matching. If criteria are specified, the transactions will be grouped first and then used in matching on that side.
You can specify the filters applied to each dataset in the Filters table before comparing the two. This is optional and can be left empty.
The Matching Criteria table identifies the details of each comparison between two or grouped transactions from two datasets. There must be at least one entry with operation = between the amounts from both sides. If you don’t provide this entry, processing of matching rules will fail. It's recommended to process a rule once you create it to see if it's valid.
The updated rules must be processed first before the matching process takes effect.
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.
Refer to create match rules section to understand the process of adding match rule types for different rule type.
Filters table fields
| Field | Description |
| Function | Apply an arithmetic operator to the Field before it's used in combination with the filtering operation:
It's applicable only to numeric fields. |
| Dataset | Select a dataset from the list of all datasets associated with the match group. |
| Field | Select a column from the list of all available columns from the transaction table associated with the selected dataset. |
| Operation | Select an operation from the list of available operations to apply to the selected Field type. |
| Value | Value should be the same type as of field. For example, the accepted format for Date Field is YYYYMMDD. |
| Positive Tolerance | A positive value indicates the upper acceptable range for the value. If it's not specified, then the exact value will be considered. |
| Negative Tolerance | A negative value indicates the lower acceptable range for values. If it's not specified, then the exact value will be considered. |
| Identifier | The identifier is automatically generated once the form is saved. The first letter of the indentifier distinguishes the filter based on the dataset's predetermined side, L for left or R for right, in Transaction Matching. |
Filter Logic table fields
| Field | Description |
| Dataset | Select a dataset from the list of all datasets associated with the match group. |
| Logic | Specify the filters applied to each dataset before comparing the two.
This field is optional. |
Grouping table fields
The Grouping table is used only for many-to-many rules. It's used to define criteria for grouping multiple transactions before using them in matching.
| Field | Description |
| Dataset | Select a dataset from the list of all datasets associated with the match group. |
| Field | Select a column from the list of all available columns from the transaction table associated with the selected dataset. |
Matching Criteria table fields
| Field | Description |
| Function1 | Apply an arithmetic operator to the Field1 before it's used in combination with the filtering operation:
It's applicable only to numeric fields. |
| Dataset1 | Select a dataset from the list of all datasets associated with the match group. |
| Field1 | Select a column from the list of all available columns from the transaction table associated with Dataset1. |
| Operation | Select an operation from the list of available operations to apply to the selected Field type. |
| Function2 | Apply an arithmetic operator to the Field2 before it's used in combination with the filtering operation:
It's applicable only to numeric fields. |
| Dataset2 | Select a dataset from the list of all datasets associated with the match group. |
| Field2 | Select a column from the list of all available columns from the transaction table associated with Dataset2. |
| Positive Tolerance | A positive value indicates the upper acceptable range for the difference between Field1 and Field2. |
| Negative Tolerance | A negative value indicates the lower acceptable range for the difference between Field1 and Field2. |
