In Suggested Vendor Payments how to exclude invoice that has Payment method code set to D/D ?

(3) Share

Report

Posted on by AT-06060922-0

Hi All,

A vendor can have their payment method code set to BACS on their vendor card, but I also need to set up an invoice for this vendor using Payment method: Direct Debit (D/D). When processing the payment journal, I want to exclude this D/D invoice, while still including other invoices that are set to BACS (from same vendor)

However, the suggested vendor payments feature does not provide an option to filter invoices based on their payment method code.

Any suggestions on how to work on this ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Montassar Krichi 231 on at

Like (1)

Report
Hi,

The standard "Suggest Vendor Payments" function in the Payment Journal in Business Central filters by vendor-level settings (like Payment Method Code on the Vendor Card), but not at the individual invoice level.
However, there are workarounds to achieve what you want:
Option 1 – Manually Set Payment Method on Purchase Invoice
Even if the Vendor Card has Payment Method Code = BACS, you can override it at the invoice level:

When creating the Purchase Invoice, set the Payment Method Code to D/D manually on the invoice header.

This won't change the vendor card but will apply only to this invoice.

This seems to be what you are already doing — great.
Option 2 – Use “Suggest Vendor Payments” + Filtering Logic (Custom or Semi-Manual)
Since Suggest Vendor Payments does not let you filter by invoice-level payment method code, you can do the following:
A. Run Suggest Vendor Payments as Usual (for BACS)

Use the “Suggest Vendor Payments” function and select the vendor.

Let it pull all invoices (including the D/D one).

Then, manually delete or filter out the D/D line.

B. Use a Custom Filtered Page View

Open the Payment Journal page.

Add the column Payment Method Code to the lines.

Filter out lines where Payment Method Code = 'D/D'.

This allows you to easily exclude any invoice not meant for BACS payment before processing the batch.
Option 3 – Use a Custom Report or AL Extension
If this is a frequent process, you could:

Customize the Suggest Vendor Payments function to include a filter on payment method at line level

Or, create a custom batch job that:

Suggests only lines where Payment Method Code = BACS

Ignores any invoice marked as D/D, regardless of vendor

This requires development via AL.

If you found this helpful, please mark it as verified :)

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

You're right—Suggested Vendor Payments does not have a direct filter for Payment Method Code.

A common workaround is to use a separate batch or journal line filter by customizing the “Applies-to Doc. Filter” or by temporarily using a different vendor posting group or vendor number for D/D invoices.

Alternatively, a small customization via AL can add a filter for Payment Method Code in the "Suggest Vendor Payments" report request page.

✅ If this helps, mark as verified answer.

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

Like (2)

Report

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

Solved: Payment Method Code

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Or you can discuss with your partners whether you can consider customizing this feature.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,782 Super User 2025 Season 2 on at

Like (3)

Report

There is no straight forward solution for this.
1) You can generate the journal lines, then just delete the lines that are applied to the unneeded invoice

2) In Vendor Ledger Entries, find this Invoice (by filtering) and enter anything in the column "On Hold" - this will put the document on hold, and it will be skipped in the "Suggest Vendor Payments" process. Afterwards You can delete the value from On Hold field for this Vendor Ledger Entry.
3) Custom development/modification for Suggest Vendor Payments (Report ID 393)

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,646 Super User 2025 Season 2 on at

Like (2)

Report

Right now, I can think of two possible approaches. The first is to use the "Suggest Vendor Payments" function, where you can apply filters to exclude any entries you don't want, if not then run as it is and and then remove any remaining unwanted lines from the results. This method is efficient if you want to generate a broad list and refine it afterward. The second approach is to go to the Vendor Ledger Entries page and manually select the specific entries you want to pay. Once you've selected the relevant lines, you can click the "Pay Vendor" option in the top menu, which will transfer only those selected entries to the payment journal for processing.

Was this reply helpful? Yes No