Group EFT payments into single line item in Business Central Remittance Form

(5) Share

Report

Posted on by SL_GP_BC_123

1,106

I am trying to configure Business Central so that EFT payments group invoices from the same vendor together. I know I can do this on payment suggestion with "Summarize by Vendor". But then if a user adjust the suggestion by adding or deleting an invoice they also have to adjust the debit amount on the main screen. I'm trying to avoid this extra step.

I've resolved this for checks with Suggest Vendor payments by disabling both "Summarize per Vendor" and "New Doc No. per Line". I then turned off "One Check per Vendor per Doc" option on the check printing screen. That allowed me to group invoices together on the vendors check stub while still allowing users to add or remove invoices on the main payment journal screen. Debit totals adjusted accordingly.

Is there a comparable solution for EFT Generation. I am not seeing the same settings and options under Bank Export.

Please advise. I'm trying to provide some consistency and ease of use for users.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

In Business Central, EFT exports don’t provide the same “Summarize by Vendor” and “One Check per Vendor” flexibility as check payments. The EFT grouping is controlled by your bank export setup and regional functionality.

Key options:

On the Electronic Banking Setup page (or local EFT setup), select Summarize Gen. Jnl. Lines to combine all payments per vendor into one EFT line in the XML export.

This merges invoices for the same vendor into a single transfer, similar to your check setup.

If you allow users to add or remove invoices, the EFT amount automatically reflects the total per vendor.

For supported regions (e.g., AU/NZ), the setup is done in the Bank Account → EFT section.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

There's no setting for this using out of the box functionality. Your only option is to use the Summarize by Vendor setting that you mentioned, or to customize the EFT export to group the lines.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Business Central does not offer the same flexibility for EFT as it does for checks; grouping invoices for the same vendor in EFT relies on Summarize per Vendor during payment suggestions, and there’s no built-in option to automatically adjust totals when users add or remove invoices later.

The standard EFT export requires one payment line per vendor, so the only solutions are manual adjustments or customizing the EFT export logic to mimic check behavior.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

There is no direct equivalent for EFT in standard Business Central. The EFT export uses the payment journal lines exactly as they appear, so grouping and summarizing logic is controlled by the journal, not by the export settings.

Thanks

Rishabh

Was this reply helpful? Yes No