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

EFT Settlement Line - Data Exchange Definition

(0) Share

Report

Posted on by Tyler Lambert

Hello,

I have encountered an issue where the financial institution of one of our clients 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 and other relevant information 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?

Thank you!

Tyler

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Tyler,

Did your Clients Bank give an example?

Need the Banks specification to understand the Data Exchange Definition layout.

Thanks,

Steve

Was this reply helpful? Yes No
adamdm12 4 on at

Like (0)

Report

Hi Tyler

Have you found an answer to this question? I am running into the same issue where the bank is requiring a balanced file. In GP, we would use the Auto-Settlement toggle.

Was this reply helpful? Yes No
adamdm12 4 on at

Like (0)

Report

Hi Steven

Basically, we need another line after the detail that is a Settlement line. It should be a sum of all the payments that were made, basically an offset record. Here is what the bank provided:

www.treasurysoftware.com/.../ach-file-offset-record-balanced.aspx

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Adam,

I have never placed an Offset within Segment 6. However, you could insert another Footer after the Detail or Detail Footer and Enter the Record Type 6 and then insert the field values and texts values.

Have you tried this?
Thanks,

Steve

Was this reply helpful? Yes No