Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / MT940 model mapping er...
Finance forum
Answered

MT940 model mapping error on import of bank statement

Posted on by 59

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 59 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 59 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 59 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 59 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 344 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 59 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 344 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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans