Dynamics Community Forum Thread Details

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

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

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