EFT Settlement Line - Data Exchange Definition

[Tanya_Henderson]

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.

[Jimmy_Yu]

Hi Tanya,

This is not always easily accomplished in BC but I’ll walk you through my setup. Each bank has a slightly different format though, so you’ll have to get the specs from the bank to ensure you have the correct data along the footer.

On the Data Exchange Definition card, I have Line Definitions:

When I select Footer, Manage, Field Mapping, I see this:

Back one screen to the Data Exchange Definition page again, at the bottom, I have Column Definitions that looks like this:

What I’ve provided above is my EFT setup. My ACH setup would be slightly different.

I hope this helps.
Jimmy