Reconciliation matching rules (form) [AX 2012]

Updated: August 9, 2012

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.

The following tables provide descriptions for the controls in this form.

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.

NoteNote

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.

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.

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: