Skip to main content

Notifications

Announcements

No record found.

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

  • Suggested answer
    JAngle Profile Picture
    95 on at
    RE: How can I cerate a data exchange definition to IGNORE 2 footers?

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

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How can I cerate a data exchange definition to IGNORE 2 footers?

    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
    Vanessa Garcia Profile Picture
    on at
    RE: How can I cerate a data exchange definition to IGNORE 2 footers?

    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,

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans