Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

MT940 model mapping error on import of bank statement

(0) ShareShare
ReportReport
Posted on by 67

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

pastedimage1658940022699v2.png

  • Ashik1234 Profile Picture
    Ashik1234 55 on at
    RE: MT940 model mapping error on import of bank statement

    Hi

    Have you fixed this issue?

    May i know a solution?

    Thanks

    Ashik

  • Khizra Aziz Profile Picture
    Khizra Aziz 35 on at
    RE: MT940 model mapping error on import of bank statement

    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.

  • jerhsysacct Profile Picture
    jerhsysacct 67 on at
    RE: MT940 model mapping error on import of bank statement

    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? 

    pastedimage1660838346584v1.png

  • jerhsysacct Profile Picture
    jerhsysacct 67 on at
    RE: MT940 model mapping error on import of bank statement

    Here are some additional details of the error message - apologies for omitting those first time round

    pastedimage1659523151115v1.png

    pastedimage1659523183835v2.png

  • jerhsysacct Profile Picture
    jerhsysacct 67 on at
    RE: MT940 model mapping error on import of bank statement

    Hi DCTX

    I tried putting in a "/" in front of account number but got the same error as above.

    thanks

  • jerhsysacct Profile Picture
    jerhsysacct 67 on at
    RE: MT940 model mapping error on import of bank statement

    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

    Joe

  • Giorgio Bonacorsi Profile Picture
    Giorgio Bonacorsi 636 on at
    RE: MT940 model mapping error on import of bank statement

    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.

    Kind regard,

    Giorgio Bonacorsi

  • Verified answer
    DCTX Profile Picture
    DCTX 235 on at
    RE: MT940 model mapping error on import of bank statement

    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.

  • jerhsysacct Profile Picture
    jerhsysacct 67 on at
    RE: MT940 model mapping error on import of bank statement

    Thanks

    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?

    Thanks

    Joe

  • Giorgio Bonacorsi Profile Picture
    Giorgio Bonacorsi 636 on at
    RE: MT940 model mapping error on import of bank statement

    Hello,

    I've been the same problem. You need upgrade your Dynamics version until 27.

    Kind regard,

    Giorgio Bonacorsi

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans