How to: Insert Due Date as Posting Date on Payment Journal Lines

When you use the Suggest Vendor Payments batch job to create payment lines for your vendors, you can fill two special fields to make sure that the generated lines use the due date to calculate the posting date.

Note

In the following procedure, only the two involved fields are described. For information about filling the other fields, see Suggest Vendor Payments.

To automatically generate payment lines using the due date to calculate the posting date

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

  2. On the Home tab, in the Prepare group, choose Suggest Vendor Payments.

  3. In the Suggest Vendor Payments window, fill in the two fields as described in the following table.

    Options Description

    Calculate Posting Date from Applies-to-Doc Due Date

    Specify whether the due date on the purchase invoice will be used as a basis to calculate the payment posting date.

    Applies-to-Doc due Date Offset

    Specify a period of time that will separate the payment posting date from the due date on the invoice.

    Example 1: To pay the invoice on the Friday in the week of the due date, enter CW-2D (current week minus two days).

    Example 2: To pay the invoice two days before the due date, enter -2D (minus two days).

    For more information about using a date formula, see How to: Enter Dates and Times.

    Dn789592.note(en-us,NAV.90).gifNote
    To use the exact due date as posting date, leave the field blank.

Important

You cannot use the Calculate Posting Date from Applies-to-Doc Due Date field together with the Find Payment Discounts field or the Summarize per Vendor field. The reason is that if the posting date is based on the due date, then some payment discount may not be calculated correctly, because the posting date could occur after the payment discount date.

Note

If the calculated posting date occurs in the past, then the posting date will be moved up to the work date, and a warning is displayed.

To manually create payment lines using the due date to calculate the posting date

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

  2. In the Payment Journal window, add a new journal line where you have filled the Account Type and Account No. fields.

  3. On the Home tab, in the Prepare group, choose Apply Entries. For more information, see How to: Apply Vendor Ledger Entries.

  4. When the journal line is ready to process, on the Home tab, in the Prepare group, choose Calculate Posting Date.

The posting date on the journal line is now updated to the due date of the related purchase invoice.

Note

If the purchase invoice is overdue, then the posting date will be set to the work date, and the font on the line will change to red color.

See Also

Tasks

How to: Apply Vendor Ledger Entries

Reference

Payment Journal

Other Resources

Suggest Vendor Payments
Pmt. Discount Date
How to: Enter Dates and Times