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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

MT940 Bank Statement Format: An error occurred during the 'Model mapping' run.

(3) ShareShare
ReportReport
Posted on by 21
Dear community,
 
I have an error when trying to import bank statement. The error below:
Evaluating expression for path 'Amount'.Evaluating expression for path 'Value/Amount'. Can't cast GIBACZPX 0800 940 N2 33328840 :20:0000000014542142 :25:0800/0000000014542142 :28:00001/00001 :60F:C251030EUR21.34 to real
We are working with the same set up in 3 entities.
In one of the entities the imports are flawless and without any errors.
 
The rest generates the same error.
 
Maybe there is experienced eye, that can give me immediate a hint.
 
Thank you
Admir
Categories:
I have the same question (0)
  • Sohaib Cheema Profile Picture
    49,012 User Group Leader on at
    MT940 Bank Statement Format: An error occurred during the 'Model mapping' run.
    Hi,
    Hard to say exactly what could have been wrong. But the error message shows that it is trying to convert a string(a full row) into number(real). That casting cannot happen. 
    Could you please make sure, you are using/importing a good file, that is formatted well as per MT940 standard.
     
    Also make sure that you have accurate ER Mapping for bank statement format
     
     

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

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

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 743

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 528 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans