Suggest Vendor Payments - Checking vendor due date

(6) Share

Report

Posted on by Jacob

192

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 (6)

Answers (1)

Suggested answer

RockwithNav 8,941 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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
Verified answer

Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Ladjecamis 8 on at

Like (0)

Report
Copy link

Link copied!

I have often seen this in Suggest Vendor Payments. It seems that priorities are sometimes processed differently than expected, especially when there are mixed records with Priority = TRUE and Priority = 0. It helped me to review the sorting order in the AL code and pay attention to the vendor date — sometimes it is what determines which records are included in the payment proposal first. I also noticed that payment terms can affect the selection logic. Different discount periods create unexpected results in some cases. When I need to understand bonus structures better, I find detailed reviews at PokiesLAB NZ quite helpful for comparing different offers. Clear descriptions make it easier to evaluate options. The same applies to Dynamics configuration - good documentation saves hours of testing. I always document my findings to help others avoid similar issues.

Was this reply helpful? Yes No