Finance | Project Operations, Human Resources, ...

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

(6) Share

Report

Posted on by AB-25071415-0

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:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

AX-US 97 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try using Value as the VALUE function returns a Real value that is converted from the specified string.

Below you will find an example of how to use Value Function in Electronic Reporting:

VALUE(CustInvoiceJour.DocumentrNum)

Thanks
Umar.S

Was this reply helpful? Yes No
AB-25071415-0 31 on at

Like (1)

Report
Copy link

Link copied!

Funny thing is, that:

With this one works fine, same settings:

GIBACZPX 0800
940 N2
33328907
:20:0000000014901862
:25:0800/0000000014901862
:28:00006/00001
:60F:C251023EUR964,86
:61:2510241024DR539,44NMSC202541842628
/ECMT/EUR539,44
:86:030?00202541842628?10OSEN?20VYŠLÁ PLATBA EL. BANKING?21KURS:1
?22LITOLAB, spol. s r.o.?23.?24.?25PL28160013870004190199238022
?26CHEMLAND UL. USLUGOWA 3 STA?27RGARD?28.
?29VS2025106008/SS0000000000/K?30S0000?31.?32.?33.?60.
:62F:C251024EUR425,42
-}

And with this one, I am encountering the particular error:
GIBACZPX 0800
940 N2
33328840
:20:0000000014542142
:25:0800/0000000014542142
:28:00001/00001
:60F:C251030EUR21,34
:61:2510311031RD6,17NMSCNONREF
:86:020?001892129679?10P082?20KS:?21VS:?22SS:?230800/?24VS2:/SS2:
?25Cumulated charge of 1*6.17 EUR?26.?27.?28.?29VEDENÍ ÚÈTU
?300800?31.?32.?33.?60.
:62F:C251031EUR15,17
-}

Was this reply helpful? Yes No
Suggested answer

AX-US 97 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I have figured out your issue:

Your failing MT940 file has a :61: line with RD:

:61:... RD6,17 ...

RD = reversal of a debit (valid SWIFT).

The ER “Model mapping” in D365FO is not configured to parse RD/RC (it expects only C/D/CR/DR).
When it sees RD, the parse breaks and the run errors out.

The file that works uses DR (plain debit), which the mapping accepts. Try replace RD→DR (and RC→CR) before import.

Best Regards
Umar Shahzad

Was this reply helpful? Yes No