Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Import - Footer T...
Small and medium business | Business Central, N...
Suggested answer

Bank Import - Footer Tag ignored

(4) ShareShare
ReportReport
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
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar on at
    Bank Import - Footer Tag ignored
    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.
     
  • gdrenteria Profile Picture
    gdrenteria Most Valuable Professional on at
    Bank Import - Footer Tag ignored
  • Suggested answer
    Dr Gomathi MVP, MCT Community lead, MLE Profile Picture
    Dr Gomathi MVP, MCT... on at
    Bank Import - Footer Tag ignored
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans