Suggest Vendor Payments - Checking vendor due date

(3) Share

Report

Posted on by Jacob

180

Hi all,

Before making an experience idea I'd like to see whether anyone has any experience with getting the Suggest Vendor Payments report to check due dates on vendors, when Vendor Priority is set to TRUE and an Available Amount is set and where the vendor card has no priority e.g is 0.

From looking at the AL code it appears as though there are 2 chunks that check whether to include or exclude a vendor.

Code 1:

if UsePriority then begin
    SetCurrentKey(Priority);
    SetRange(Priority, 1, 2147483647);
    UsePriority := true;
end;

This block - If UsePriority is checking whether the vendor has a priority of 1..2147483647 which in this scenario would exclude vendors.

Code 2:

if UsePriority and not StopPayments then begin
    Reset();
    CopyFilters(Vend2);
    SetCurrentKey(Priority);
    SetRange(Priority, 0);
    if FindSet() then
        repeat
            ...
        until (Next() = 0) or StopPayments;
end;

This block is doing the default to ensure that a vendor payment is included where the priority is 0. However, if you have a list of outstanding vendor entries that look something like the below:

Vendor No.	Amount	Due Date
V01	5000.00	31/03/25
V02	2500.00	28/02/25
V03	2500.00	28/02/25

When the suggest vendor payment is run and you set a Last Payment Date of 31/03/25 and have Vendor priority to TRUE and an Available Amount of 5000.00 the document that will be inserted is V01 rather than V02 and V03, despite these having an earlier due date.

My expectation is that the Vendor No is irrelevant and that if the vendor card has no priority that Due date on the vendor ledger entry is considered rather than the order of the vendor no. Wondering if anyone has any experience in considering due dates during the suggest vendor payment and/or whether this is even currently possible?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Khushbu Rajvi. 19,137 Super User 2025 Season 2 on at

Like (2)

Report

Suggest Vendor Payments - Checking vendor due date

Hope this helps as well: https://learn.microsoft.com/en-us/dynamics365/business-central/payables-how-suggest-vendor-payments

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,233 Super User 2025 Season 2 on at

Like (1)

Report

Suggest Vendor Payments - Checking vendor due date

Hi, hope the following helps as well.

Streamline Vendor Payments: A Guide to Suggesting Payments in Microsoft Business Central

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Jeffrey Bulanadi 8,431 on at

Like (1)

Report
Suggest Vendor Payments - Checking vendor due date

Hi Jacob,

This seems to be standard Business Central functionality, and your analysis is spot on—the current setup doesn’t prioritize due dates for Priority 0 vendors as expected.

To achieve your desired outcome, you could:

Assign priorities to all vendors to explicitly control the payment order.

Customize the Suggest Vendor Payments report to sort Priority 0 vendors by due date.

If you find this helpful, feel free to mark it as the suggested answer!

Cheers
Jeffrey Bulanadi

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,570 Most Valuable Professional on at

Like (2)

Report

Suggest Vendor Payments - Checking vendor due date

Hi, good day
I hope this can help you, and give you some hints.

Managing Payables in Business Central - The complete Guide

How to Optimize Vendor Payments in Business Central with the 'Suggest Vendor Payments' Function

Assign a Priority Level to a Vendor - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,225 Super User 2025 Season 2 on at

Like (1)

Report

Suggest Vendor Payments - Checking vendor due date

Honestly, I’ve never faced any issues when executing the Suggest Vendor Payments function. Date entered in the Last Payment Date field, the system still brings in any pending entries. If Priority is selected, it will override other criteria.

My suggestion is: if the function isn’t bringing the expected entries, why not go to the Vendor Ledger Entries page, select the vendors you want to process, choose the relevant entries, and then click Pay Vendor. This will bring all selected entries into the Payment Journal using the information you provided in the dialog box.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No