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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Set up Advanced Bank Reconciliation import (BAI2) - no longer working?

(0) ShareShare
ReportReport
Posted on by 168

I am trying to set up the statement import for the advanced banking reconciliation using the standard instructions. This is something I have done last few years ago, but this time it's not working.

https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process

I follow the section of  [Set up the import of BAI2 bank statements] - 

The first step of setting up the Import Project, goes as as expected.

pastedimage1647714478586v3.png

The second step, of setting up Bank Statement Format form no longer works - the import project I set up in the previous step is not available for selection from the dropdown.

pastedimage1647714096372v2.png

I can also see there are a couple of changes to this form, some columns missing and a new column [Generic Electronic Import Format] that did not use to be there. I can no longer select the "file format" = txt, for example.

I checked in the instance where I have previously set up bank reconciliation and it has changed in the same way, although the functionality is still working there.

What's going on? is the configuration now done in a different way?

pastedimage1647713894842v1.png

I have the same question (0)
  • saurabh bharti Profile Picture
    15,039 Moderator on at

    Can you disable generic format check box and see?

  • ZvikaR Profile Picture
    168 on at

    that field is display only - cannot modify the value there. when I create a new line it is defaulted to "Yes"

  • Jeremy Driscoll Profile Picture
    on at

    Hello Zvika,

    This is a change that was made by Microsoft. Due to a security issue found, the XSLT functionality used in the transformations has been disabled in all environments. The permanent solution to this issue is to start using electronic reporting to import bank statements. If you really need to use the data management import, you can open a support ticket with Microsoft and we can disable the flight that controls this. Please note that this is only a temporary solution and the XSLT functionality will be permanently deprecated later this year.

    Jeremy Driscoll

    Microsoft Support Engineer

  • Suggested answer
    Mav Profile Picture
    on at
  • DCTX Profile Picture
    235 on at

    Is there a link on the process setups for implementing the ER solution?

  • ZvikaR Profile Picture
    168 on at

    Thanks Jeremy, this is a really really helpful to know.

    Is there any existing out of the box ER mapping provided to upload BAI2?

    or we are expected to implement it from scratch ourselves?

    This is a functionality we currently use in production, so having it abruptly discontinue is quite disruptive.

  • DCTX Profile Picture
    235 on at

    Further to the missing information on alternative setup's, I do see there is a setup in ER for this; however, the standard MT940 we use for advanced bank reconciliation fails when imported via the ER setups.  The filed used that generated the below error successfully loads in the old data management setup:

    pastedimage1648490902850v1.png

    or

    "An error occurred during the 'Model mapping' run. For more information, contact your system administrator."

    "Evaluating expression for path 'BalanceAmount'.Evaluating expression for path 'EndingBalanceLine/CashBalanceAmount'. Can't cast 0,00 :64:C220318USD0,00 :65:C220321USD0,00 :65:C220322USD0,00 :65:C220323USD0,00 :65:C220324USD0,00 :65:C220325USD0,00 :65:C220328USD0,00 :20:220318-2359 :21:111000012 :25:/3756556737 :28C:00001/00001 :60F:C220318USD0,00 to real"

    Any thoughts would be greatly appreciated.

    Many thanks,

    DCTX

  • DBroad Profile Picture
    35 on at

    I am having the same issue when using the MT940 ER import route, did you find a solution?

    Thanks

  • DCTX Profile Picture
    235 on at

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans