For each journal line representing a payment in the Payment Reconciliation Journal window, you can open the Payment Application window to see all candidate open entries for the payment and view detailed information for each entry about the data matching that a payment application is based on. Here, you can manually apply payments or reapply payments that were applied automatically to a wrong entry. For more information about automatic application, see How to: Reconcile Payments Using Automatic Application.

Important
When the bank account that you are reconciling payments for is set up for the local currency, then the Payment Application window will show all open entries in the local currency, including open entries for documents that were originally invoiced in foreign currencies. Payments applied to entries with converted currencies may therefore be posted with different amounts than on the original document because of the potentially different exchange rates used by the bank and Microsoft Dynamics NAV respectively.

Therefore, we recommend that you look for foreign currency codes in the Currency Code field in the Payment Application window to check if applications are based on converted currencies. To review the original document amount in the foreign currency and to see the exchange rate used, choose the Applies-to Entry No. field, and then, on the shortcut menu, choose DrillDown to open the Customer Ledger Entries or Vendor Ledger Entries window. To add the Currency Code column to your view, open the shortcut menu for the column heading, and then choose Choose Columns.

Any gains-and-loss adjustment required due to currency conversions is not handled automatically by Microsoft Dynamics NAV.

Note
You cannot apply entries with a different sign than the sign on the payment. For example, to close both a negative-sign credit memo and its related positive-sign invoice, you must first apply the credit memo to the invoice, and then apply the payment to the invoice with the reduced remaining amount.

Warning
If you use payment discounts, and if the payment date is before the payment due date, then the Remaining Amt. Incl. Discount field in the Payment Application window will be used for matching. Otherwise, the value in the Remaining Amount field will be used. If the payment was made with a discounted amount after the payment due date, or the full amount was paid but a discount was granted, then the amount will not be matched.

Note
You can only apply a payment to one account. If you want to split the application on multiple open entries, for example to apply a lump-sum payment, then the open entries must be for the same account. For more information, see steps 7 and 8 in the procedure in this topic.

To review or apply payments after automatic application

  1. In the Search box, enter Payment Reconciliation Journals, and then choose the related link.

  2. Open the payment reconciliation journal for a bank account that you want to reconcile payments for. For more information, see How to: Reconcile Payments Using Automatic Application.

  3. In the Payment Reconciliation Journal window, select a payment that you want to review or manually apply to one or more open entries.

  4. On the Home tab, in the Application group, choose Apply Manually.

  5. In the Payment Application window, on the Home tab, in the Show group, choose one of the following actions to specify which entries are shown.

    Action Description

    All Open Entries

    All open entries that the payment can be applied to are shown.

    Related-Party Open Entries

    Only open entries that are specifically for the related party in the Account No. field are shown.

    This view minimizes the list of open entries to those that are most likely to relate to the payment.

    Applied Entries

    Only open entries that the payment is applied to are shown.

  6. Select the Applied check box on the line for the open entry that you want to apply the payment to.

    The payment amount, which is also shown in the Transaction Amount field in the Payment Application window, is inserted in the Applied Amount field, but you can modify the field, for example if you want to apply the amount to several open entries.

  7. To apply a part of the paid amount to another open entry for the account, for example to apply a lump-sum payment, select the Applied check box for the line. The applied amount is automatically deducted from the transactions amount to reflect the distribution on the two open entries.

  8. To apply part of a payment to one or more open entries that does not exist in the database, create a new line under the line for the same account, in the Applied Amount field, enter the amount to apply on the new line, and then adjust the Applied Amount field on the existing line.

  9. Repeat steps 6, 7, or 8 for other open entries that you want to apply a full or part payment amount to.

  10. When you have reviewed a payment application or manually applied to one or more open entries, on the Home tab, in the Review group, choose Accept Application.

    The Payment Application closes, and in the Payment Reconciliation Journal window, the value in the Match Confidence field is changed to Accepted, to indicate to you that you reviewed or manually applied the payment.

Tip

See Also