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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 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
    Microsoft Employee 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
    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
    159 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 647 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans