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

Balanced ACH/EFT File

(1) Share

Report

Posted on by CU07010629-0

Hello,

The bank is requesting a Balanced ACH/EFT NACHA file ,I'm trying to get a Offset line on Entry detail record (6), but without success.

My Results

This is what the bank is expecting

Did you know how I can get this Offsite line?

This is something that I need to change on the Data Exchange Definition, or it's something that I need to do on the Payment Journal to get this Offsite line?

Balanced Nacha Fi...

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (0)

Report

This is something you need to do in the data exchange definition, not in the payment journal. Take a look at the standard data exchange definitions that come with the system, I believe they do something similar. You can copy the setup or use it to understand what you need to do.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following can give you some hints.

Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No
adamdm12 4 on at

Like (1)

Report

We are struggling with the same thing right now. The closest we have come to getting this to work is by creating another detail line in the Data Exchange Definition. It creates an offset for every transaction though (not just a single one at the very end). The main issue though is that there is no way to designate this as the "credit" - so what ends up happening is the file/batch totals get doubled. Not sure where else to go at this point.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,612 Super User 2025 Season 2 on at

Like (1)

Report

If it helps: https://community.dynamics.com/forums/thread/details/?threadid=cb5fc37d-a8cd-434a-95af-b2bb517da26c

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

Was this reply helpful? Yes No