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 Applying Payments Automatically.
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 Payment Text to Accounts for Direct Posting of Unapplied Payments.
Tip
For more information on how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For assistance in finding specific pages, see Search.
See Also
Reference
Payment Reconciliation Journal
Match Confidence
Other Resources
Text-to-Account Mapping
How to: Set Up Rules for Applying Payments Automatically
How to: Map Payment Text to Accounts to Assist Automatic Application
How to: Automatically Apply Payments to Open Documents
How to: Review and Apply Payments after Automatic Application
How to: Import Bank Statements