Bank Statement Upload - MT940 - Failing following upgrade to version 10.0.12

(0) Share

Report

Posted on by ColMain

Since updating to latest version 10.0.12 of D365 F&O, we seem unable to upload bank statements with the following error being reported:

File contains duplicate rows, cannot insert data into staging due to unique key violation.-
'0' 'Bank statements' record(s) inserted in staging

Bank statement file has been checked for duplicates and there are no duplicates in the file.

Anyone any advice on any configuration that would need updating following an upgrade?

Thanks!

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi ColMain,

What exact procedure are you using to import your bank statements? Have you also checked if there are empty lines at the end of the file?

Was this reply helpful? Yes No
ColMain 25 on at

Like (1)

Report

Hi André procedure is through the front end of the application, module Cash & Bank Management>Bank Statement Reconciliation>Bank Statements. Choose the option of Import Statement, enter Bank Account and Format (MT940) and select file for upload. There are no blank lines at the end of the file.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Hi ColMain ,

I would be hard to say whats causing that error. However , you can debug the process and see what causing this error. class BankStatementImportBatch is getting called during the import process . You can start debugging from method importSingleStatement or doImportBankStatementsDMF and see whats causing it.

I have seen similar issues with BAI2 import statement before and debugging this class helps in finding out the root cause.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (1)

Report

Hi ColMain,

After upgrade, Did you verified your transaction code mapping, statement format and reconciliation matching rules setups in Advance bank reconciliation setup?

Are you facing this issue on your all bank accounts or on specific one?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello ColMain,

I would recommend contacting the MS support especially if things worked fine before.

Similar issues are reported on LCS but they are not related to bank statement imports.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

ColMain 25 on at

Like (0)

Report

All, thanks for the responses. Issue now resolved by simply restarting DIXF (Data Management restart).

Thanks!

Was this reply helpful? Yes No
DJY 30 on at

Like (0)

Report

Hi , we are trying to import MT940 files to business central any advise .

as we understood we need xslt file to covert MT940txt to MT940xml ?

Thank you for your reply

Was this reply helpful? Yes No