Skip to Content
Menu
This question has been flagged

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


Avatar
Discard
Ihr Helpdesk Ticket
HT00467 - [15community] Import camt.053 file contains information like # results in damaged accounting (database)
Clixmedia GmbH

Clixmedia GmbH

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.

+41 43 535 00 54 info@clixmedia.ch https://www.clixmedia.ch

Clixmedia GmbH
 
Related Posts Replies Views Activity
2
Jan 23
8962
1
Jan 23
2217
0
May 24
1648
4
Feb 24
12982
1
Apr 22
4474