1. Setting Up and Configuring Account Reconciliation
  2. Setting Up Transaction Matching
  3. Setting Up Transaction Matching Overview
  4. Creating Match Types
  5. Defining the Match Process by Creating Rules
  6. Using a Subset Rule During Creation of 1 to Many and Many to 1 Rules

Using a Subset Rule During Creation of 1 to Many and Many to 1 Rules

There may be times when you are working with 1 to Many or Many to 1 rule types and you need to match an amount with a subset of all transactions in order to match correctly. If this is your requirement, then you can use the With Subset check box for 1 to Many or Many to 1 rules.
screenshot of new rule type dialog with With Subset option selected

Consider the following source system and subsystem transactions. The defined rule condition is that the Amount, Date and GL Value must match exactly.

Table 10-4 Source System Transactions

Amount Date GL Value
111 10-13-2023 Shop-1
233 10-13-2023 Shop-1

Table 10-5 Subsystem Transactions

Amount Date GL Value
100 10-13-2023 Shop-1
10 10-13-2023 Shop-1
1 10-13-2023 Shop-1
     
200 10-13-2023 Shop-1
30 10-13-2023 Shop-1
3 10-13-2023 Shop-1

When using the subset matching functionality, the amount 111 from the source system should match with group amount (100 + 10 + 1) from the Subsystem transactions. Similarly, the amount 233 should match with group amount (200 + 30 + 3).

Without using the subset matching functionality, the rule condition, to match exactly with amount, Date and GL string, will be returning the sum of amount of all the six transactions from Subsystem because Date and GL String (10-13-2023, Shop-1) from Subsystem is equal to Date, GL String from Source System. So, the result would be the amount 111 from Source System and a sum (100+10+1+200+30+3) = 344 from the Subsystem and would not be a proper match. Similarly amount 233 from Source System is not a match with amount 344 from Subsystem.