Open the Payment Application Rules window.

Specifies rules to govern if payments are automatically applied to their related open entries when you use the Apply Automatically function in the Payment Reconciliation Journal window.

You set up new payment application rules by choosing which types of data on a payment reconciliation journal line must match with data on one or more open entries before the related payment is automatically applied to the open entries. The quality of each automatic application is shown as a value of Low to High in the Match Confidence field in the Payment Reconciliation Journal window according to the payment application rule that was used. For more information, see How to: Set Up Rules for Automatic Application of Payments.

The automatic application function is based on prioritized matching criteria. First the function tries, in prioritized order, to match text in the five Related-Party fields on a journal line with text in the bank account, name or address of customers or vendors with unpaid documents. Then, the function tries to match text in the Transaction Text and Additional Transaction Info fields on a journal line with text in the External Document No. and Document No. fields on open entries. Last, the function tries to match the amount in the Statement Amount field on a journal line with the amount on open entries.

Note
Text matching is only possible for text longer than four characters.

For detailed information about the matching algorithm, see the Design Insight - Record Matching in Cash Management document on the Getting Ready site for Microsoft Dynamics NAV 2015 on PartnerSource (requires PartnerSource account).

The following table shows which payment application rules are set up in the generic version of Microsoft Dynamics NAV.

Important
The payment application rules may be different in your installation of Microsoft Dynamics NAV.

Match Confidence Priority Related Party Matched Doc. No./Ext. Doc. No. Matched Amount Incl. Tolerance Matched

High

1

Fully

Yes - Multiple

One Match

High

2

Fully

Yes - Multiple

Multiple Matches

High

3

Fully

Yes

One Match

High

4

Fully

Yes

Multiple Matches

High

5

Partially

Yes - Multiple

One Match

High

6

Partially

Yes - Multiple

Multiple Matches

High

7

Partially

Yes

One Match

High

8

Fully

No

One Match

High

9

No

Yes - Multiple

One Match

High

10

No

Yes - Multiple

Multiple Matches

Medium

1

Fully

Yes - Multiple

Not Considered

Medium

2

Fully

Yes

Not Considered

Medium

3

Fully

No

Multiple Matches

Medium

4

Partially

Yes - Multiple

Not Considered

Medium

5

Partially

Yes

Not Considered

Medium

6

No

Yes

One Match

Medium

7

No

Yes-Multiple

Not Considered

Medium

8

Partially

No

One Match

Medium

9

No

Yes

Not Considered

Low

1

Fully

No

No Matches

Low

2

Partially

No

Multiple Matches

Low

3

Partially

No

No Matches

Low

4

No

No

One Match

Low

5

No

No

Multiple Matches

In the Text-to-Account Mapping window, which you open from the Payment Reconciliation Journal window, you can specify mappings between text on payments and specific debit, credit, and balancing accounts in the general ledger. Such payments are then posted to the specified accounts when you post payments in the Payment Reconciliation Journal window. Payments posted based on text-to-account mapping are not applied to open entries, but are only posted to the specified accounts additionally to creating bank account ledger entries. Accordingly, text-to-account mapping is suited for recurring cash receipts or expenses, such as frequent purchases of car fuel, that regularly occur on the bank statement and do not need a related business document.

On a payment reconciliation journal line where the payment has been set to posting according to text-to-account mapping, the Match Confidence field contains High - Text-to-Account Mapping, and the Account Type and Account No. fields contain the mapped accounts. For more information, How to: Map Text on Recurring Payments to Accounts for Automatic Reconciliation.

Tip

See Also