Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

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

Categories:
  • Suggested answer
    JAngle Profile Picture
    JAngle 33,137 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
    Community Member Microsoft Employee 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
    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,

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans