Auto Match Rule Fields

Here is a description of the fields that make up the matching rules for bank reconciliation.

Auto Match Rule

KeyR – Read-only - * – Mandatory field;

Auto Match Rule Settings

Field

 

Description
Auto Match Rule Number R Auto-generated number with the prefix AMR.
Is Suggested Match   Indicates that the rule is used for suggested matches when reconciling transaction lines to bank statements.

Auto Match Rule Details

KeyR – Read-only - * – Mandatory field

Auto Match Rule Details

Field

 

Description
Auto Match Rule R Lookup to the auto match rule that the fields mapping is associated with.
Auto Match Rule Detail Number R Auto-generated number with the prefix AMRD
Operator  

Stores the operator used for the matching value. Operators determine how the target fields are matched to the source fields. You can select:

  • Contains. Used to match fields that contain the specified value. For example, to match alphanumeric reference fields. This is the only operator that accepts text values.
  • Equals. Used for exact matching. You cannot enter a value if you select this operator.
  • Greater than or equal to. Used to match transaction fields with values greater than or equal to the selected bank statement field value.
  • Less than or equal to. Used to match transaction fields with values less than or equal to the selected bank statement field value.
  • Range. Used to match fields with values greater than, equal to or less than the specified value. For example, if you select a date field, Range and value 2, all transactions with the matching date, a date 2 days earlier, or a date 2 days later are retrieved.
Priority   Stores the priority of the matching rule field. You must assign a unique priority to each matching rule.
Source Field   The field that you want to use as the source of the data in the matching rule.
Target Field   The field that you want to match with the source field in the matching rule.
Value   The value used for matching fields.