web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Bank Statement Import: How to ignore multiple footer lines

(0) ShareShare
ReportReport
Posted on by 57

Hello,

I have created a bank import format for a bank statement which has multiple footer lines that start after the last transaction line. This is summary information which I do not want imported into Business Central.

Bank-Statement-Image.png 

The first column contains the transaction date, so once the footer lines begin, Business Central errors out on import. I can add a footer tag for the first line, but there are multiple lines and the data contained within is dynamic, not fixed.

Are there any out-of-the-box methods available to deal with this? If not, we will have to customize the code.

Thank you.

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    93,996 Super User 2025 Season 2 on at
    RE: Bank Statement Import: How to ignore multiple footer lines

    Hi, As far as I know, there is no out-of-the-box methods to do it now.

    You need to customize an XmlPort. Although I haven't tried it, it may be possible to use Xmlport.Skip() Method in OnBeforeInsertRecord trigger.

    Hope this will help.

    Thanks.

    ZHU

  • Craig Day Profile Picture
    57 on at
    RE: Bank Statement Import: How to ignore multiple footer lines

    Thank you, Yun Zhu. We will try your suggestion.

    Cheers,

    Craig

  • Suggested answer
    JAngle Profile Picture
    127 on at
    RE: Bank Statement Import: How to ignore multiple footer lines

    If you’re using the data exchange definition method I have encountered similar. I ended up using an event subscriber for after the data is inserted to table I deleted the last how ever many lines.

  • KAHUJA Profile Picture
    44 on at
    RE: Bank Statement Import: How to ignore multiple footer lines

    please check what's the first line Tag for the lines you want ti import and then put it under Data line tag in the line definitions. IN this way, it will only import the lines tagged with that code the rest will be skipped. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,267

#2
Sumit Singh Profile Picture

Sumit Singh 2,098

#3
YUN ZHU Profile Picture

YUN ZHU 1,766 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans