Finance | Project Operations, Human Resources, ...

Bank statements validation Error message

(2) Share

Report

Posted on by pierre_willocquet

109

When i import a bank statement and i want to /validate/ There is an error message :ValidatingBank statement: TEST054654654 Cannot edit a record in Bank statement cash balance (BankStmtISOCashBalance). The record has never been selected.

How can i validate my bank statement ?

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

BillurSamdancioglu 20,111 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please be sure that IBAN/Account number etc ar the same with the file and with the bank account number.

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 8,602 on at

Like (0)

Report
Copy link

Link copied!

Have a look at below MS documentation

https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process?WT.mc_id=DX-MVP-500041

Also, if recently restored the DB to this environment you need to reconfigure this process.

Was this reply helpful? Yes No
pierre_willocquet 109 on at

Like (0)

Report
Copy link

Link copied!

Iban and bank account number is the same otherwise i could not be able to import.

I do not have problem to import, i have a problem when i want to "validate" the bank statement

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

HI,

Which format is this? MT940? if so can you check your bank account having "/" in between of Bank account and number?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,047 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Did you add any custom code? From The error it seems you are trying to update record doesn't exist.

Thanks

Waed

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,743 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Pierre,

Can you provide more information on statement header and lines? Ref to the error message it is associated to BankStmtISOCashBalance table that is related to statement header.

Was this reply helpful? Yes No
Suggested answer

Eugen Glasow 6,359 on at

Like (0)

Report
Copy link

Link copied!

Old (?) ER import configurations for MT940 may leave the Net amount (net change To - From) at the statement header empty. As a result, the import does not create a record BankStmtISOCashBalance with the type "Net amount". On validating, the system tries to find this record, does not return anything and this results in the error.

Was this reply helpful? Yes No