Set Up Rules for Automatic Application of Payments

Set Up Rules for Automatic Application of Payments

On the Payment Application Rules page, you set up rules to govern how payment text (on a bank transaction) is automatically matched with text on related open (unpaid) invoices, credit memos, or other entries when you use the Apply Automatically function on the Payment Reconciliation Journal page. For more information, see Reconcile Payments Using Automatic Application.

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 on the Payment Reconciliation Journal page according to the payment application rule that was used.

Each row on the Payment Application Rules page represents a payment application rule. Rules are applied in the order specified by the Sorting Order field. If multiple rules are used simultaneously, then the match confidence of the highest sorted rule is used.

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 representing open entries. 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.

In addition to the matching criteria, the following applies concerning the sign of the payment amount:

  • For negative amounts, a match is made first against open entries representing customer invoices and then against vendor credit memos.
  • For positive amounts, a match is made first against open entries representing vendor invoices and then against customer credit memos.

To set up a payment application rule

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Payment Application Rules, and then choose the related link.
  2. Define a new or edited payment application rule by filling the fields on a line as described in the following table.
FieldDescription
Match ConfidenceSpecifies your confidence in the application rule that you define on the line.

A value that you specify in this field is shown in the Match Confidence field on the Payment Reconciliation Journal page according to the quality of the automatic payment application on the journal line.
PrioritySpecifies the priority of the application rule relative to other application rules that are defined as lines on the Payment Application Rules page. 1 represents the highest priority.
Related Party MatchedSpecifies how much information about the customer or vendor, such as address, city name, and bank account number, on the payment reconciliation journal line must match with information about the open entry before the application rule will be used to automatically apply the payment to the open entry.
Doc. No./Ext. Doc. No. MatchedSpecifies whether text on the payment reconciliation journal line must match with the value in the Document No. field or the External Document No. field on the open entry before the application rule will be used to automatically apply the payment to the open entry.
Amount Incl. Tolerance MatchedSpecifies how many entries for a customer or vendor must match the amount including payment tolerance before the application rule will be used to automatically apply a payment to the open entry.
Review RequiredSpecifies whether the automatic payment application is recommended for manual review by the user before posting. Choosing the Lines to Review field on the Payment Application Journal page starts a guided experience where you can easily review multiple applications in a sequence on the Payment Application Review page.

The following table describes the standard payment application rules in Business Central.

 Important

The payment application rules may be different in your implementation of Business Central.

Match ConfidencePriorityRelated Party MatchedDoc. No./Ext. Doc. No. MatchedAmount Incl. Tolerance Matched
High1FullyYes - MultipleOne Match
High2FullyYes - MultipleMultiple Matches
High3FullyYesOne Match
High4FullyYesMultiple Matches
High5PartiallyYes - MultipleOne Match
High6PartiallyYes - MultipleMultiple Matches
High7PartiallyYesOne Match
High8FullyNoOne Match
High9NoYes - MultipleOne Match
High10NoYes - MultipleMultiple Matches
Medium1FullyYes - MultipleNot Considered
Medium2FullyYesNot Considered
Medium3FullyNoMultiple Matches
Medium4PartiallyYes - MultipleNot Considered
Medium5PartiallyYesNot Considered
Medium6NoYesOne Match
Medium7NoYes-MultipleNot Considered
Medium8PartiallyNoOne Match
Medium9NoYesNot Considered
Low1FullyNoNo Matches
Low2PartiallyNoMultiple Matches
Low3PartiallyNoNo Matches
Low4NoNoOne Match
Low5NoNoMultiple Matches

See Also

Reconcile Payments Using Automatic Application
Managing Receivables
Sales


    • Related Articles

    • Managing Receivables

      In this article See Also Start a free trial! A regular step in any financial rhythm is to reconcile bank accounts, which requires that you apply incoming payments to customer or vendor ledger entries to close sales invoices and purchase credit memos ...
    • Set Up Rules for Automatic Application of Payments

      In this article To set up a payment application rule See Also On the Payment Application Rules page, you set up rules to govern how payment text (on a bank transaction) is automatically matched with text on related open (unpaid) invoices, credit ...
    • Reconcile Payments Using Automatic Application

      In this article To reconcile payments using automatic application See also The Payment Reconciliation Journal page specifies payments, either incoming or outgoing, that have been recorded as transactions on your online bank account or on a payment ...
    • Reconcile Payments Using Automatic Application

      In this article To reconcile payments using automatic application See also The Payment Reconciliation Journal page specifies payments, either incoming or outgoing, that have been recorded as transactions on your online bank account or on a payment ...
    • Review and Apply Payments Manually After Automatic Application

      In this article To review or apply payments after automatic application See Also For each journal line representing a payment on the Payment Reconciliation Journal page, you can open the Payment Application page to see all candidate open entries for ...