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

Community site session details

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

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

(2) ShareShare
ReportReport
Posted on by 879
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
    2,057 on at
    Group EFT payments into single line item in Business Central Remittance Form
    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
  • Suggested answer
    Valentin Castravet Profile Picture
    30,533 Super User 2025 Season 2 on at
    Group EFT payments into single line item in Business Central Remittance Form
    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.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,351

#2
Sumit Singh Profile Picture

Sumit Singh 2,072

#3
YUN ZHU Profile Picture

YUN ZHU 1,807 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans