This page explains how you can set up custom matching rules and how you extend the predefined fields
General Information
With a custom matching rule, you could simply create custom logic that the Bank Reconciliation Suite App will apply on a certain reoccurring bank statement transaction line. With this logic auto certain postings and predifine value like department, class, and location. The custom matching rules can even be extended with custom fields and segments.
Basic Setup
To use custom matching, the feature must be enabled under Setup > Company > General Preferences > Custom Preferences > ERP fast forward Bank Reconciliation.
Additionally custom matching rules need to be setup under Setup > Bank Reconciliation Setup > Custom Matching Rules.
To create a new Custom Matching Rule:
Give the rule a name (just for your own reference)
In case there might be multiple rules matching a particular transaction, give the rule a priority. The rule with priority closest to zero will have preference over the others. Decimal numbers are allowed (for example 0.5)
In the field 'Apply To', select one or multiple bank accounts that this rule applies to. Leave blank to apply to all bank accounts.
Set the criteria and fields to set.
The user may for example set a matching rule for Counterparty, to automatically recognize a payment coming from a certain customer. Or when the description contains 'Bank Fees', book the amount to a certain GL account.
For each bank statement line all the rules are validated.
If more then one rule applies to a line, all rules are executed.
Custom matching overrides the automatic matching.
Extending Fields
If you would like to set additional prefixed data like for example a profit center you can extend the available fields under the section Then… Extending the field is done in three steps
Creating additional field
To create an additional field setting under the “Then…” section you must navigate to CUSTOMIZATION->LIST,RECORDS, &FIELDS. Locate here the record type named “Bank Statement Custom Matching Rule and open it. On the left side, there is a grey button labeled “New Field”. Press this button to start entering the newly needed field.
On the page that opens set the following value:
Label: Provide a descriptive name for the field (this will be visible on the custom matching rule for the users)
Description: Optional, maybe entered if required
Type: This should be the type “List/Record”
List/Record: Select here the list from which the user can select values
Store Value: Must be checked
Show In List: Must be checked
Help: Optional, but recommended to guide the user
