Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

EFT Settlement Line - Data Exchange Definition

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 69,639 Super User 2024 Season 2 on at
    EFT Settlement Line - Data Exchange Definition
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,181 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans