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
HT00467 - [15community] Import camt.053 file contains information like # results in damaged accounting (database)
Guten Tag notifications@mail.odoo.com
Das Support - Ticket "HT00467 - [15community] Import camt.053 file contains information like # results in damaged accounting (database)" wurde geschlossen. Möchten Sie das Ticket wieder eröffnen, loggen Sie sich bitte im Kundenportal ein und senden Sie Ihre Nachricht. Wir eröffnen das Ticket erneut und kümmern uns um Ihr Anliegen.
Clixmedia GmbH