Validation error when importing MT940 bank statement

(0) Share

Report

Posted on by Jacob Anthony

I am getting a validation error when importing my MT940 statements.

0576.pastedimage1655300196458v1.png

I can avoid this error if I alter the MT940 statement I am importing and remove the "-" between the sort code/account number and replace it with a "/". However, I am obviously looking to allow the statements to import without making this bank statement amendment.

2656.pastedimage1655300423752v2.png

I have tried a few things such as altering the AccountID formula in data source to only collect the account number and also (MT940 Model) MT940 Bank statement mapping to destination data model (removed "/" in formula and replaced with "-"). May be stabs in the dark but i'm having no luck getting this resolved.

6014.pastedimage1655300579449v3.png

0184.pastedimage1655300826751v6.png

I can't find any documentation online, but wondering if anyone on here has had experience with similar? The rest of the statement imports as expected with this slight amendment.

Thank you!

I have the same question (0)

All responses (4)

Answers (0)

huijij 19,811 on at

Like (0)

Report

Hi Jacob,

Please hold on to wait answers from others on the forum who have such experience.

Was this reply helpful? Yes No
Jacob Anthony 2 on at

Like (0)

Report

Thanks Judy, will do

Was this reply helpful? Yes No
BillurSamdancioglu 19,854 Most Valuable Professional on at

Like (0)

Report

Hi, On account identification of the bank account , can you try to fill with the "-".

Was this reply helpful? Yes No
Jacob Anthony 2 on at

Like (0)

Report

Hi Bullur,

Thanks for your response. Do you mean the Bank account number on the bank account record? Or a change in GER?

I have tried with the "-" in the bank account number, but still no luck.

Was this reply helpful? Yes No