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.