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

Data Exchange Definition import file with two-footer lines

(4) Share

Report

Posted on by Saurav.Dhyani

14,354 Super User 2025 Season 2

Hi all,

I am setting up a Data Exchange Definition to Import Bank statement.

Everything works great but I have two lines in footer (received from bank).

Footer Line 1: Total Value of Transaction

Footer Line 2: Number of transactions

Using Footer Tag, I can skip first line but how to handle footer line 2.

Is it possible with standard Data Exchange Definition to skip two lines in footer?

Regards,

Saurav Dhyani

Categories:

Dynamics 365 Business Central

I have the same question (1)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 92,161 Super User 2025 Season 2 on at

Like (1)

Report

Data Exchange Definition import file with two-footer lines

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
Suggested answer

Pallavi Phade 1,880 on at

Like (1)

Report

Data Exchange Definition import file with two-footer lines

Namaste @Saurav.Dhyani

I agree With Valentin We cannot import as per Standard , We also had to customize for import bank statement .

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 3,931 on at

Like (2)

Report

Data Exchange Definition import file with two-footer lines

Hi,

In the standard Data Exchange Definition, the Footer Tag only lets you skip a single footer line. If your bank file has two footer lines, there’s no direct setup option to ignore both.

> Adjust the file before import (e.g., remove/merge the extra footer line).
> Or create a custom Data Exchange codeunit/subscriber to handle multiple footer lines during import.

default BC configurations can’t skip more than one footer line.

Thanks

Rishabh

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,225 Super User 2025 Season 2 on at

Like (2)

Report

Data Exchange Definition import file with two-footer lines

The Data Exchange Definition has always been a bit tricky if it doesn’t align with the customer’s bank file format. You may need to do some tweaking for this, but before that, did you try using the assisted setup to check what default configuration the system is offering? Sometimes, a small adjustment from there can solve the issue.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,345 Super User 2025 Season 2 on at

Like (3)

Report

Data Exchange Definition import file with two-footer lines

It's not possible using standard functionality, you'll need to customize the import to do it.

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