Skip to main content

Notifications

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

EFT Settlement Line - Data Exchange Definition

(1) ShareShare
ReportReport
Posted on by 761

I have a clients that is requiring the EFT export to be formatted in such a way as to include a settlement line at the bottom of the detail section of the EFT export file. I know this is possible in Dynamics GP through a simple switch. I do not see any such option in Business Central on the Data Exchange Definition, Bank Import/Export, or Bank Account pages.

A Settlement Line is a line that appears on the bottom of the detail section of the EFT export file which denotes bank account information a trace number which is a batch total  for the party sending the EFT payment. This allows the institution to draft funds from the correct account.

Does anybody have any ideas on where I might be missing this setting, or maybe a clever workaround that has been implemented to get around this shortcoming?  I can hard code all fields that are required in the data exchange except the total debits and the trace number.  Here is an example of what is needed and we can get it from the detail line instead of a footer, but then it puts it for every detail line.  We need one line after the detail that totals the file and counts the number of transactions.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    EFT Settlement Line - Data Exchange Definition
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,910 Super User 2024 Season 2 on at
    EFT Settlement Line - Data Exchange Definition
    Take a look at the US EFT CCD format in the Data Exchange Definitions page. It has a batch footer section, it sounds like something similar can work for you.
     
     

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans