Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Click Cash and bank management > Setup > Bank reconciliation > Reconciliation matching rules.
Use this form to create matching rules that will be run during the reconciliation process from the Bank reconciliation worksheet form. A matching rule is a set of criteria that is used to filter statement lines and bank documents.
Navigating the form
The following tables provide descriptions for the controls in this form.
FastTabs
FastTabs
Description
If the Match with bank document option is selected in the Actions group, the following FastTabs are displayed:
Step 1: Find statement lines
To add selection criteria, select a field from the bank statement line table, select an operator, and then add a value. For example, to select only checks, you would select the Bank transaction code in the Field field, select the = in the Operator field, and then enter Checks in the Value field.
Step 2: Find bank documents
You can add selection criteria to match bank document lines to bank statement lines during the reconciliation process. Select the Search bank documents check box to search bank document transactions for the selected bank statement transaction during the reconciliation process.
The Basic criteria options are as follows:
Opposite amount – Select this check box if the bank document transaction must have the opposite amount as the reversal bank statement transaction.
Check difference of days – Select this check box to specify the maximum number of days difference between the bank document transaction date and the bank statement transaction date in order to be matched during the reconciliation process.
Same document number – Select this check box if the bank document transaction and the bank statement transaction must have the same document number in order to be matched during the reconciliation process.
Same transaction type – Select this check box if the bank document transaction and the bank document transaction must be the same transaction type in order to be matched during the reconciliation process.
Same payment reference – Select this check box if the bank document transaction and the bank statement transaction must have the same payment reference in order to be matched during the reconciliation process.
If the Clear reversal statement lines option is selected in the Actions group, the following FastTabs are displayed:
Step 1: Find reversal statement lines
To add selection criteria, select a field from the bank statement line table, select an operator, and add a value. For example, to only select checks, select the Bank transaction code in the Field field, select the = in the Operator field, and then enter Checks in the Value field.
Note
The Reversal field is editable when the Clear reversal statement lines option is selected.
Step 2: Find original statement lines
You can add selection criteria to match bank document lines to bank statement lines during the reconciliation process. The basic criteria options are as follows:
Opposite amount – Select this check box if the bank document transaction must have the opposite amount as the reversal bank statement transaction.
Check difference of days – Select this check box to specify the maximum number of days difference between the bank document transaction date and the bank statement transaction date in order to be matched during the reconciliation process.
Same document number – Select this check box if the bank document transaction and the bank statement transaction must have the same document number in order to be matched during the reconciliation process.
Same transaction type – Select this check box if the bank document transaction and the bank document transaction must be the same transaction type in order to be matched during the reconciliation process.
Same payment reference – Select this check box if the bank document transaction and the bank statement transaction must have the same payment reference in order to be matched during the reconciliation process.
Step 3: Find bank documents
You can add selection criteria to match bank document lines to bank statement lines during the reconciliation process. Select the Search bank documents check box to search bank document transaction for the selected bank statement transaction during the reconciliation process.
The Basic criteria options are as follows:
Opposite amount – Select this check box if the bank document transaction must have the opposite amount as the reversal bank statement transaction.
Check difference of days – Select this check box to specify the maximum number of days difference between the bank document transaction date and the bank statement transaction date in order to be matched during the reconciliation process.
Same document number – Select this check box if the bank document transaction and the bank statement transaction must have the same document number in order to be matched during the reconciliation process.
Same transaction type – Select this check box if the bank document transaction and the bank document transaction must be the same transaction type in order to be matched during the reconciliation process.
Same payment reference – Select this check box if the bank document transaction and the bank statement transaction must have the same payment reference in order to be matched during the reconciliation process.
If the Mark new transactions option is selected in the Actions group, the following FastTabs are displayed:
Step 1: Find statement lines
To add selection criteria, select a field from the bank statement line table, select an operator, and add a value. For example to only select checks, you would select the Bank transaction code in the Field field, select the = in the Operator field, and then enter Checks in the Value field.
Step 2: Do not include bank documents
You can add selection criteria to match bank document lines to bank statement lines during the reconciliation process. Select the Search bank documents check box to search bank document transactions for the selected bank statement transaction during the reconciliation process.
The Basic criteria options are as follows:
Opposite amount – Select this check box if the bank document transaction must have the opposite amount as the reversal bank statement transaction.
Check difference of days – Select this check box to specify the maximum number of days difference between the bank document transaction date and the bank statement transaction date in order to be matched during the reconciliation process.
Same document number – Select this check box if the bank document transaction and the bank statement transaction must have the same document number in order to be matched during the reconciliation process.
Same transaction type – Select this check box if the bank document transaction and the bank document transaction must be the same transaction type in order to be matched during the reconciliation process.
Same payment reference – Select this check box if the bank document transaction and the bank statement transaction must have the same payment reference in order to be matched during the reconciliation process.
Buttons
Button
Description
Activate
Activates the matching rule to be available from the Bank reconciliation worksheet form during the reconciliation process.
Deactivate
Inactivate the matching rule so that it is not available from the Bank reconciliation worksheet form during the reconciliation process.
Fields
Field
Description
Matching rule
Enter the name of the matching rule.
Name
Enter the description of the matching rule.
Active
Indicates if the reconciliation matching rule is active.
Actions
Select which action will occur when the matching rule is run during the bank reconciliation process.
Match with bank document – Select this option to create criteria regarding how the bank documents and bank statement lines are matched during the bank statement reconciliation process.
Clear reversal statement lines – Select this option to create criteria regarding how reversal statement lines should be removed from the bank reconciliation worksheet.
Mark new transactions - Select this option to create criteria regarding how new transactions should be marked during the bank statement reconciliation process.