Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 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 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

...

  • 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

...