...
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 recurring 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
...
To create an additional field setting under the “Then…” section you must navigate to CUSTOMIZATION->LIST,RECORDS, &FIELDS. Customisation>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.
...
Additional settings may be set if needed. When all the mandatory fields are set press save.
If you would now navigate to SETUP->BANK RECONCILIATION SETUP->CUSTOM MATCHING RULES->NEW Setup>Bank Reconciliation Setup>Custom Matching Rules>New you should see the newly created field on the page.
...
The next step is creating a custom field on the bank statement transaction line.
To do this navigate to CUSTOMIZATION->LIST,RECORDS, &FIELDS Customisation>List, Records & Fields and locate here the record type named “Bank Statement Transaction” 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.
...
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
...
To actually copy the data to a transaction we do need to link the data to the transaction with a configuration.
Navigate to SETUP->BANK RECONCILIATION SETUP->BANK ACCOUNT CONFIGURATION Setup>Bank Reconciliation Setup>Bank Account Configuration. Open on this page the bank account configuration that should use this data while creating transactions.
On the bank account configuration page scroll to the bottom and click on the subsection “Additional Parameters & Fields” and then click on the subsection “Bank Statement Additional Fields”. Click here the grey button on the left-hand side labeled “New Bank Statement Additional Fields”.
...