Introduction - Suggest vendor payments

Completed

In the Payment Journal window, you can use the Suggest Vendor Payments batch job to suggest payment lines. These lines are suggested based on your settings for items such as payments that are due soon or payments where a payment discount is available.

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. These fields are Calculate Posting Date from Applies-to-Doc Due Date and Applies-to-Doc Due Date Offset.

Also, if the calculated posting date is in the past, then the posting date is moved up to the work date and a warning is displayed.

Alternatively, you can manually create payment lines by using the due date to calculate the posting date. After you apply vendor ledger entries, you can use the Calculate Posting Date action to update the posting date on the journal line with the due date of the related purchase invoice.

To use the Suggest Vendor Payments function, follow these steps:

  1. Select the Search for Page icon in the top-right corner of the page, enter payment journal, and then select the related link.

  2. Open the relevant journal and then select the Suggest Vendor Payments action.

The Suggest Vendor Payments batch job contains two FastTabs:

  • Options

  • Vendor

Screenshot of the Suggest Vendor Payments window.

On the Vendor FastTab, you can filter the suggestion lines by vendor information. Additional filters can be added in a blank line.

To suggest vendor payments for all vendors, don't set filters on this FastTab.

The Options FastTab is used to determine how the batch job is run, and it contains the following fields:

  • Last Payment Date - The latest payment date that can appear on the vendor ledger entries that are to be included in the batch job.

    • Only entries that have a due date or a payment discount date either before or on this date are included.

    • If this date is earlier than the system date, the system displays a warning message.

  • Check Other Journal Batches - Specifies whether to exclude payments that are already included in another journal batch from new suggested payments. This selection helps avoid duplicate payments.

  • Summarize per Vendor - If this field is selected, the batch job suggests one line for each vendor, for each currency in which the vendor has ledger entries. If this field is not selected, the batch job suggests one line for each invoice.

  • Posting Date - The posting date that appears on the lines that the batch job inserts in the Payment Journal.

  • Starting Document No. - Automatically populated with the next available number in the number series for the journal batch that is linked to the payment journal. This field can also be filled in manually.

After filling in the fields as necessary, select OK and the program will insert the payment journal lines.

Screenshot of the Payment Journals window.