Announcements
Have setup the MT940 electronic reporting following this guide. https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process#sample-files
now getting the below error when trying to import a statement. Not quite sure where to start. Any help will be appreciated!
Thanks
Ensure the bank account number listed in D365 matches the number listed in the MT940 (:25: xxxx). Also, our Bank does not prefece the account number with a routing number and in order for us to import, we have to put a "/" in front of our account.
Our import looks like this for the bank account row: :25:/123456
Hello,
I've been the same problem. You need upgrade your Dynamics version until 27.
Kind regard,
Giorgio Bonacorsi
Tried this
Still got the same error. I guess we need to walk through the debugger?
docs.microsoft.com/.../import-bank-statement-file-failed-incorrect-results
Although I think the error we are getting is more general issue with the file?
Joe
Joe, I believe that link is no longer valid as MS moved away from data management for this import (along with positive pay) to electronic reporting.
Have you imported the last version for all these GER:
- Bank statement model
- Bank statement Mapping to destination
- MT940 Bank statement mapping to destination
- MT940 Model
- MT940 Format
I've test, and in my case with a standard environment as version 27, the functionality run correctly.
Hi Giorgio
I have followed the steps detailed here. Is this what you have done too?
docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process
Hi DCTX
I tried putting in a "/" in front of account number but got the same error as above.
thanks
Here are some additional details of the error message - apologies for omitting those first time round
We have setup electronic reporting and it now works. However we have had to swap debits and credits around in the statement header and lines in the model mapping. We've done this and it works...except for the net amount D365 is calculating is the wrong way around. I am not sure how to do this?
We have imported a statement that was already imported in AX. The net amount is negative (ie more money went out than in) but the net amount in D365 is incorrect and should be negative as well. The debits and credits are correct in D365 now we have swapped them around. Does anyone know how to correct?
Hi Jerry, I am having the same model mapping error while importing MT940. How did you rectify this issue? Since you said that swapping Credit with Debits resulted in calculating the wrong amount.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 407 Super User 2026 Season 1
Subra 394
Martin Dráb 275 Most Valuable Professional
