Suggest Vendor Payments not functional

(8) Share

Report

Posted on by Jacob

180

Hi,

Wondering if anyone else has encountered this issue:

Here are some vendor ledger entries:

Here is a Suggest vendor payments variable selection:

When pressing OK this will not pull in the vendor ledger entries that have a due date on or before 24/08. It will return blank. If I shift this to 25/08 it will generate all lines.

I have tried all different types of combinations on the Suggest Vendor Payments report with no luck. I've also checked the vendor page and can't see anything different. Have only just noticed this today.

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (4)

Report

Hello,

This issue often occurs because the Last Payment Date or Posting Date filter in the Suggest Vendor Payments batch job is set in a way that excludes entries falling exactly on 24/08. In Business Central, the interaction between Due Date, Posting Date, and options like Find Payment Discounts or Summarize per Vendor can sometimes cause entries on the filter boundary to be skipped hence why extending the date to 25/08 pulls them in. I’d recommend reviewing your filters carefully (especially Last Payment Date, Posting Date, and Balance Account Type/No.) and confirming that the vendor ledger entries are still Open and not impacted by any payment discount settings.

https://learn.microsoft.com/en-us/dynamics365/business-central/payables-how-suggest-vendor-payments
https://learn.microsoft.com/en-us/dynamics365/business-central/payables-manage-payables#vendor-ledger-entries

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following can give you some hints.

https://community.dynamics.com/forums/thread/details/?threadid=3895f578-4c13-45fc-92b4-ef53a9fbf94d

https://community.dynamics.com/forums/thread/details/?threadid=ec549b32-9d57-46c7-9af9-4b3522576e7b

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (3)

Report

Last Payment Date - is a bit poorly phrased, but You can read it like "Check due date until".
So if You are doing payment for example once a week - on mondays, then today generating payments, You would indicate here next Sunday (or next Monday) date - and system will generate payments for all invoices that have to be paid until this date.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (3)

Report

Adding more detail

https://community.dynamics.com/forums/thread/details/?threadid=ec549b32-9d57-46c7-9af9-4b3522576e7b

this might give you a hint to resolve your problem

✅ Mark the checkbox below if this answer helped you.

Was this reply helpful? Yes No
Verified answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (2)

Report

The very first request filter name is confusing.

More insights -

https://community.dynamics.com/forums/thread/details/?threadid=ec549b32-9d57-46c7-9af9-4b3522576e7b

Now a days I am using create payment option on Vendor ledger entries, this seems much easier to me.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (2)

Report

Check the Vendor's Payment Method Code set on the Vendor card, regardless of what the Vendor Ledger Entries have set. It is important to understand you are filtering the Vendor detail, not the Vendor Ledger Entries. A mismatch of the Payment Method Code can leave the suggestions blank.

The other thing to check is if a payment to that Vendor exists in a separate Payment Journal. Because "Check Other Journal Batches" is enabled (which it should be), it will prevent a duplicate payment if the payment is prepped in a separate journal.

If either of these helped resolve your issue, please mark it as a Verified Answer.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Jacob 180 on at

Like (3)

Report

Thanks all for the replies. I don't know whether these really address the concern though.

In the vendor ledger the outstanding documents have different due dates being 250825 and 250725.

With the last due date set as 24/08/25 it should have pulled in all entries with a due date less than (or less than equal to) 24/08/25. This is not what happened. It generated no documents at all from less than 24/08/25.

@RockwithNav - agreed. It can be a few more "cumbersome" steps for end users at the ledger level. Maybe this is just what it is.

Might just have to alter my expectation of the functionality in D365.

Was this reply helpful? Yes No
Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (3)

Report

Jacob,

Did you test my suggestion of removing the Payment Method Code filter? This is still likely your issue. It isn't that the system isn't working, you have given it parameters to follow that don't align with your data.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Adding this for more details: https://learn.microsoft.com/en-us/training/modules/suggest-vendor-payments-dynamics-365-business-central/

Was this reply helpful? Yes No