web
You’re offline. This is a read only version of the page.
close
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... / How can I cerate a dat...
Small and medium business | Business Central, N...
Suggested Answer

How can I cerate a data exchange definition to IGNORE 2 footers?

(0) ShareShare
ReportReport
Posted on by Krystal McCarthy 30

How can I cerate a data exchange definition to IGNORE 2 footers?

The footers are such:

Subtotal for 05/06/2021: 25 38,761.00
Report Total: 25 Items USD 38,761.00

In the Data exchange General tab I added the Footer Tag of "Subtotal for"

And I have not defined any Footer type lines

When I import my file I am getting this error:

pastedimage1624299727606v1.png

I have the same question (0)
  • Suggested answer
    Vanessa Garcia Profile Picture
    Vanessa Garcia on at

    Hi Krystal,

    I'm not aware this can be done in the standard. 

    Maybe it's only possible with a customization in the Mapping/Validation Codeunits.

    Cheers,

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Krystal,

    I have created Data Exchanges both outbound and inbound. Since this is BC we can modify the Data Exchange for the Statement import or we can utilize the new utility Bank Simplified Import Wizard. Both can exclude the Footer is you do not want it processed. If you want to send me a sample of what your statement file will look like I can prep a Simplified one for you and show you it works.

    Thanks,

    Steve

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    I imagine it’s a date that changes every time you import, making a fixed footer tag useless. This will need development to resolve.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans