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

Bank Import - Footer Tag ignored

(4) Share

Report

Posted on by SM-18110414-0

Bank File import is ignoring the footer tag and trying to import the record as a line - thus erroring on the date field its searching for - given these characters are blank in the file.

If I delete the footer line and import, the file imports without issue. This is not what you want to happen with a customer.

I have a file type Fixed Text file to import. I have configured the Line Definitions for Header, Detail and Footer - just to be safe. I have set the Reading/Writing Codeunit to 1241 and Ext. Data Handling Codeunit to 1240.

I have the column record type as Text.

In the Footer Tag I have entered 99

In the Line Definitions I have defined column 1 (in all types - Header, Detail, Footer) as 2 characters in length.

The screenshot just shows the text file sample including header, lines and footer.

Without getting a developer to customise the code unit - this should be able to import.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Dr Gomathi MVP, MCT... 395 Super User 2025 Season 2 on at

Like (1)

Report

It looks like the system is not recognizing the footer tag properly and is treating it as a regular data line instead of skipping it. To resolve this, first, ensure that the Footer Tag field is exactly 99 without any spaces. Verify that the footer tag is correctly aligned in the fixed-width format. Next, check the Line Definitions in Data Exchange Definition, ensuring that column 1 is set as 2 characters in all types (Header, Detail, Footer) and the system correctly identifies 99 as a footer. Additionally, confirm that the text file uses UTF-8 or ASCII encoding, as hidden characters can sometimes cause mismatches. Opening the file in Notepad++ or another text editor and enabling "Show All Characters" can help identify any unexpected formatting. If the issue persists, try setting the Footer Tag to '99 ' (with a space) in case the system expects it in a specific format. Also, test with a smaller sample file containing only one detail line and the footer to check if the problem persists. If none of these steps work, consider temporarily changing the Reading/Writing Codeunit to 1240 instead of 1241 and testing again, as sometimes, using Custom Codeunit 1240 for external data handling provides better control. Let me know if you need further debugging assistance!

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,367 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

The Easiest Way to Import Bank Statements into Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Bank Statement Import: How to ignore multiple footer lines

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I hope below solution provided by Gerardo can help and also see if you use the feature or App provided Yodlee. its report and good for importing statement.

https://community.dynamics.com/forums/thread/details/?threadid=1d06eda7-3bef-4902-b1ef-7ea20c4ebb5f

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Are the characters after 99 fixed or variable? If they're fixed, they can be included as part of the footer tag and perhaps it will work then

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

SM-18110414-0 12 on at

Like (0)

Report

I had previously reviewed the links posts mentioned. I am trying to avoid a custom port.

Even if I put the 99 as a Data Line Tag against the Line Definition of a Line Type Footer as well as have the Footer Tag in the Header record set as 99 - this did not import.

As the data populating the lines in column 1 is the same for all Detail lines (in this case, 50)- I decided to put a Data Line Tag in this field, removed the Footer Tags (kept the No. of Header Lines).

This worked as it is only looking for 50 as the characters in column 1 and ignores the footer line.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

if this helps: https://community.dynamics.com/forums/thread/details/?threadid=1d06eda7-3bef-4902-b1ef-7ea20c4ebb5f

Was this reply helpful? Yes No