...
This page explains how you can set up custom matching rules and how you extend the predefined fields
| Table of Contents |
|---|
...
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 lines. With this logic, you can predefine values like department, class, and location. The custom matching rules can even be extended with custom fields and segments.
...
Enable feature
To use the custom matching rule feature you must first enable this feature by navigating to Setup->Company->General Preferences->Custom Preferences->Fast Four Bank Reconciliation. In this configuration section check the checkbox labeled “USE CUSTOM MATCHING RULES”
...
Basic Setup
To create a custom matching rule navigate to SETUP->BANK RECONCILIATION SETUP->CUSTOM MATCHING RULES and press the blue button labeled “New Bank Statement Custom Matching Rule”. On the page that opens set the following values:
Name: Provide a descriptive name for the field (this will be visible on the bank statement identifying which rule was applied)
Priority: If you have multiple rules reacting to the same values you can set the priority. The closer to zero the higher the priority
Apply to d/c: Select here when to apply the rule. (Recommend is to limit this option to debit or credit only)
If description: Select here if it contains or is equal
Value (Description): The value the system must search for
If counterparty: Select here if it contains or is equal
Value (Counterparty): The value the system must search for
Set select: When enabled the line will be auto processed after saving the statement
...
When all the mandatory fields are set press save. The next import or “Run Match” will now apply the newly created custom matching rule
Remark:
The “IF” section can handle only or, so the means that if the description is populated the system won’t use the counterparty. If the description is empty the system will use the counterparty
...
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
...
Label: Provide a descriptive name for the field (this will be visible on the bank statement)
Description: Optional, may be 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 unchecked
Show In List: Must be checked
Help: Optional, but recommended to guide the user
...