Answered

MT940 model mapping error on import of bank statement

(0) Share

Report

Posted on by jerhsysacct

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

Categories:

Financial Management

All responses (11)

Answers (1)

Ashik1234 55 on at

Like (0)

Report

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 35 on at

Like (0)

Report

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 59 on at

Like (0)

Report

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?
jerhsysacct 59 on at

Like (0)

Report

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
jerhsysacct 59 on at

Like (0)

Report

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 59 on at

Like (0)

Report

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 344 on at

Like (0)

Report

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 235 on at

Like (0)

Report

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 59 on at

Like (0)

Report

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 344 on at

Like (0)

Report

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