Bank Transaction Rules

Form ID: (CA204500)

You can use this form to define and view the rules that are used to create new payments for imported bank transactions for which matching documents were not found in the system on the Process Bank Transactions (CA306000) form. You can define rules to create documents created on cash management forms only.

On the Process Bank Transactions (CA306000) form, when you click Create Rule on the Create Payment tab in the right pane, the system opens the Bank Transaction Rules dialog box where you specify settings for a new rule. In this case, boxes in the Matching Criteria section are filled in with the transaction details automatically and you need to specify output details only. You can clear or modify values in the Matching Criteria section if some of the transaction details cannot be used as a criterion. For example, you can modify the transaction description by selecting the Use Wildcards (*, ?) check box or you can clear the Tran. Description box.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Summary Area

You can use the elements in this area to define a new rule and its settings, or to select an existing rule and view its settings.

Element Description
Rule Description A detailed description of the rule. This alphanumeric string may contain up to 256 characters.
Active A check box that indicates (if selected) that the rule is available for use on the Process Bank Transactions form.

Matching Criteria Tab

On this tab, you specify multiple criteria that should be met by a bank transaction for the rule to be applied.

Table 1. General SectionThis section contains the general criteria of bank transactions.
Element Description
Debit/Credit The type of a transaction: Disbursement or Receipt.
Cash Account The identifier of the cash account, which corresponds to the account in the bank.
Currency The currency of a transaction. The box is disabled and displays the currency of the selected cash account (if any).
Tran. Code The code of the transaction.
Table 2. Description SectionThis section contains settings related to the description of bank transactions.
Element Description
Tran. Description The description of the transaction. The application of this criterion depends on the value of the Use Wildcards (*, ?) check box:
  • Cleared: The criterion is met if the description of a transaction contains a string you have typed in the Tran. Description box.
  • Selected: The criterion is met if the description of a transaction equals a string you have typed in the Tran. Description box.
Note: If you do not want to use a description as the criterion, make sure this box is cleared.
Match Case A check box that indicates (if selected) that the font case of a transaction description should match the font case in the Tran. Description box.
Use Wildcards (*, ?) A check box that indicates (if selected) that you can use wildcard characters—* or ?—in the Tran. Description box.
Table 3. Payee/Payer SectionThis section contains the information about the payee or payer of bank transactions.
Element Description
Payee/Payer A payee or payer of a bank transaction, which will be used as a criterion so that a cash transaction with a certain entry type can be created for bank transaction.
Use Wildcards (*, ?) A check box that indicates (if selected) that you can use wildcard characters—* or ?—in the Payee/Payer box.
Table 4. Amount SectionThis section contains the information about the amounts in bank transactions.
Element Description
Matching Mode The mode of the transaction amount matching. The following options are available:
  • None: The amount criterion is not used.
  • Equal: The transaction amount must be equal to the number specified in the Amount box.
  • Between: The transaction amount must be in the range of the numbers specified in the Min. Amount and Max. Amount boxes.
Amount The number used to compare a transaction amount. This box appears on the form if Equal has been selected in the Matching Mode box.
Min. Amount The minimum number used to compare a transaction amount. This box appears on the form if Between has been selected in the Matching Mode box.
Max. Amount The maximum number used to compare a transaction amount. This box appears on the form if Between has been selected in the Matching Mode box.

Output Tab

On this tab, you provide the details of the rule application result.

Element Description
Action The action that is performed by the system when the rule is applied. The following options are available:
  • Create Document: The system creates a new document to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system (by using the entry type specified in the Resulting Entry Type box).
  • Hide Transaction: The system hides the imported bank transaction (that meets the specified criteria) from the list and marks it as processed.
    Note: You can then clear the Processed and Hidden check boxes for the transaction by clicking Unhide Transaction on the Import Bank Transactions (CA306500) form to be able to view and process the transaction again.
Resulting Entry Type The identifier of the entry type that the system will use as a template to create a cash transaction to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system. You can create entry types by using the Entry Types (CA203000) form. The box is displayed if the Create Document option is selected in the Action box.