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

Bank Statement Import: How to ignore multiple footer lines

(0) Share

Report

Posted on by Craig Day

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.

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.

All responses (4)

Answers (0)

KAHUJA 40 on at

Like (0)

Report

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

JAngle 63 on at

Like (0)

Report

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.
Craig Day 57 on at

Like (0)

Report

RE: Bank Statement Import: How to ignore multiple footer lines

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

Cheers,

Craig
Suggested answer

YUN ZHU 77,925 Super User 2025 Season 1 on at

Like (1)

Report

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