Related Party Matched Field, Bank Pmt. Appl. Rule Table

  • Article

Specifies 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 on the open entry before the application rule will be used to automatically apply the payment to the open entry.

You can select between the following options:

Option Description

Not Considered

Matching results for information about the customer or vendor (related party) will be ignored. However, matching will still occur as for all options, Fully, Partially, and No).

Use this if you want the match confidence to be determined by other information than about the related party.

Fully

The application rule requires that one of the following criteria, in prioritized order, is fulfilled

  1. Bank Account Number - If the bank account number from a bank statement file matches one of the customer or vendor accounts, then the related party is fully matched. Other information is not considered.

  2. Related-party information in the bank statement file – If the customer or vendor name matches, then the name must be unique in Microsoft Dynamics NAV for the related party to be fully matched. If the name is not unique, then the address and city information must match for the related party to be fully matched.

  3. Related-Party Name – If the name of the related party is entered in the Transaction Text field, then the name must be unique in Microsoft Dynamics NAV for the related party to be fully matched.

Partially

The application rule requires that one of the following criteria, in prioritized order, is fulfilled

  1. Related-party information in the bank statement file – If the customer or vendor name matches, the name is not unique in Microsoft Dynamics NAV, and the address and city information do not match, then the related party is partially matched.

  2. Related-Party Name – If the name is not unique, or only part of the name in the Transaction Text field matches, then the related party is partially matched.

No

The application rule is used when the related party cannot be matched in any way.

In the Payment Application Rules window, you choose to what degrees you want specific data on a payment reconciliation journal line to 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 according to application rules is shown as a value of Low to High in the Match Confidence field in the Payment Reconciliation Journal window. For more information, see How to: Set Up Rules for Applying Payments Automatically.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Bank Pmt. Appl. Rule Table General Ledger
Bank Pmt. Appl. Rule Table General Ledger

See Also

Reference

Amount Incl. Tolerance Matched
Doc. No./Ext. Doc. No. Matched
Match Confidence
Match Confidence
Payment Reconciliation Journal
Payment Application Rules

Other Resources

How to: Automatically Apply Payments to Open Documents
How to: Review and Apply Payments after Automatic Application
How to: Set Up Rules for Applying Payments Automatically
How to: Map Payment Text to Accounts to Assist Automatic Application
How to: Import Bank Statements