Hi

Modules: account_statement_import_camt   / account_statement_import

Problem Description: 

if camt.053 file contains line information like this:

Company INVOICE: #72334Company INVOICE: #72334GIRO INTERNATIONAL USD 2'700.00 ZUM KURS VON 0.9456 TD BANK, N.A. 19808 WILMINGTON 4322114

reconcilation results in this error:

UncaughtClientError

Uncaught Javascript Error > '2'553.12' no valid float

Error: '2'553.12' no valid float

at parseFloat (https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:4228:82\)

at\ Object\.parseMonetary\ \[as\ monetary\]\ \(https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:4235:156\)

at\ Class\._formatQuickCreate\ \(https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:10928:1072\)

at\ Class\.createProposition\ \(https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:10880:469\)

at\ Class\.changeMode\ \(https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:10878:38\)

at\ Class\._onAction\ \(https://Company\.ch/web/assets/3133\-707051c/web\.assets_backend\.min\.js:10868:189\)

at\ Class\.\ \(https://Company\.ch/web/assets/3132\-aca12e6/web\.assets_common\.min\.js:4860:11\)

at\ Class\.trigger\ \(https://Company\.ch/web/assets/3132\-aca12e6/web\.assets_common\.min\.js:4858:180\)

at\ Class\._trigger_up\ \(https://Company\.ch/web/assets/3132\-aca12e6/web\.assets_common\.min\.js:4864:378\)

at\ Class\._trigger_up\ \(https://Company.ch/web/assets/3132-aca12e6/web.assets_common.min.js:4864:462)

The issue is the '#' information in the camt XML file. After this first import, the '#' is saved somewhere in the statement import (database). If you delete all statements and bank booking lines -- the information is still there. The next statement will fail becose of this # information with the error:

Uncaught Javascript Error > '2'553.12' no valid float

Note: is very common that for invoice numbers this (#)hash is used as prefix.

you can reproduce this bug on any fresh Odoo 15 database - just load a camt.053 contains information # .

Can someone help with : how to delete this import information (#) out of odoo's database ?

thanks