web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

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

(5) ShareShare
ReportReport
Posted on by 1,114
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.
 
 
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    17,104 Super User 2026 Season 1 on at
    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
  • Verified answer
    Valentin Castravet Profile Picture
    32,748 Super User 2026 Season 1 on at
    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.
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    16,865 Super User 2026 Season 1 on at
    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.
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,229 Super User 2026 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,334 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,717 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,470

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans