Bank Statement Import (Via .csv/ CAMT53) Doesn't Work

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

Bank Statement Import (Via .csv/ CAMT53) Doesn't Work

import bankstatement

3 Replies

2825 Views

Jan Fischer

Hello there,

our company recently acquired the Odoo V14 Enterprise Edition.

We tried to automatically import our bank statements.

If we use the .csv option, the system doesn't recognize the rows and columns correctly (we tried two different .csv files from different banks). He gives us only one option for manually changing the first row. If we use CAMT import we get a long error message after we click the import button.

Sadly, you don't find any proper documentation regarding bank import.

Maybe someone could help?

Masin Al-Dujaili

Hi, I'm Jan's IT admin who is responsible for the server setup for Odoo. As I have access to the server logs I see this error before the traceback:

2021-01-04 15:26:13,724 27587 ERROR SECUINFRA_Testumgebung_1.0 odoo.sql_db: bad query: UPDATE "account_bank_statement" SET "balance_end"='53009.61',"difference"='0.00',"is_valid_balance_start"=false,"sequence_number"=532020121522265169235384729600,"sequence_prefix"='0120C',"state"='posted',"total_entry_encoding"='-4294.63',"write_uid"=11,"write_date"=(now() at time zone 'UTC') WHERE id IN (14)
ERROR: integer out of range

We haven't yet imported any bank statements (it's a testing environment after all). I mention this because the possible solutions (e.g. https://stackoverflow.com/questions/24308239/postgresql-integer-out-of-range) I find regarding this general error always assume that a number of inserts reached the maximum for the integer datatype. I tried altering the table to use bigint for sequence_number but it didn't help either (it just says "ERROR: bigint out of range"). In the XML I find the values from the UPDATE statement above in this part:

        <Stmt>
            <Id>0120C532020121522265171012551882007</Id>
            <ElctrncSeqNb>200000014</ElctrncSeqNb>
            <LglSeqNb>012</LglSeqNb>
            <CreDtTm>2020-12-15T22:08:30.0+01:00</CreDtTm>
            <Acct>

I am not familiar with either Odoo nor with CAMT but my intuition (which might be wrong because of lack of familiarity) suggests that either ElctrncSeqNb or LglSeqNb should be used for sequence_number.

PS: The error shows when confirming to upload the bank statement. We don't get into any sort of Import Tool or Formatting Options.

Jan Fischer

Author

Here's the error text:

Error:
Odoo Server Error

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 682, in dispatch
    result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 358, in _call_function
    return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 346, in checked_call
    result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 911, in __call__
    return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 530, in response_wrap
    response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1363, in call_button
    action = self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1351, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 396, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 383, in _call_kw_multi
    result = method(recs, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/account_bank_statement_import_csv/wizard/account_bank_statement_import_csv.py", line 28, in import_file
    return super(AccountBankStatementImport, self).import_file()
File "/usr/lib/python3/dist-packages/odoo/addons/account_bank_statement_import/account_bank_statement_import.py", line 52, in import_file
    statement_line_ids, notifications = self._create_bank_statements(stmts_vals)
File "/usr/lib/python3/dist-packages/odoo/addons/account_bank_statement_import/account_bank_statement_import.py", line 240, in _create_bank_statements
    statement.button_post()
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_bank_statement.py", line 396, in button_post
    self.line_ids.move_id._post(soft=False)
File "/usr/lib/python3/dist-packages/odoo/addons/account_asset/models/account_move.py", line 37, in _post
    posted = super()._post(soft)
File "/usr/lib/python3/dist-packages/odoo/addons/l10n_de/models/datev.py", line 35, in _post
    return super()._post(soft)
File "/usr/lib/python3/dist-packages/odoo/addons/account_reports/models/account_activity.py", line 67, in _post
    return super()._post(soft)
File "/usr/lib/python3/dist-packages/odoo/addons/account_invoice_extract/models/account_invoice.py", line 284, in _post
    posted = super()._post(soft)
File "/usr/lib/python3/dist-packages/odoo/addons/account_edi/models/account_move.py", line 133, in _post
    posted = super()._post(soft=soft)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_move.py", line 2411, in _post
    'posted_before': True,
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_move.py", line 1814, in write
    res = super(AccountMove, self.with_context(check_move_validity=False, skip_account_move_synchronization=True)).write(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 320, in write
    result = super(MailThread, self).write(values)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_activity.py", line 766, in write
    return super(MailActivityMixin, self).write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3664, in write
    real_recs._validate_fields(set(vals) - set(inverse_fields))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 1249, in _validate_fields
    check(self)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_move.py", line 1553, in _check_unique_sequence_number
    self.flush()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5410, in flush
    self.recompute()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5845, in recompute
    process(field)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5829, in process
    recs.mapped(field.name)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5216, in mapped
    recs = recs._fields[name].mapped(recs)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1035, in mapped
    self.__get__(record, type(records))
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 937, in __get__
    self.compute_value(recs)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1111, in compute_value
    records._compute_field_value(self)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4037, in _compute_field_value
    field.compute(self)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 553, in _compute_related
    record[self.name] = self._process_related(value[self.related_field.name])
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5640, in __getitem__
    return self._fields[key].__get__(self, type(self))
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 937, in __get__
    self.compute_value(recs)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1111, in compute_value
    records._compute_field_value(self)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 410, in _compute_field_value
    return super()._compute_field_value(field)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4042, in _compute_field_value
    self.filtered('id')._validate_fields(fnames)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 1249, in _validate_fields
    check(self)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_move.py", line 1553, in _check_unique_sequence_number
    self.flush()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5413, in flush
    process(self.env[model_name], id_vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5404, in process
    recs._write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3728, in _write
    cr.execute(query, params + [sub_ids])
File "<decorator-gen-3>", line 2, in execute
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 101, in check
    return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 298, in execute
    res = self._obj.execute(query, params)
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 638, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 314, in _handle_exception
    raise exception.with_traceback(None) from new_cause
psycopg2.DataError: integer out of range

Deerom Technologies Pvt.Ltd

Hi,

Please refer this link Bank Statements Video

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Prevent duplicate importing bank statement import duplicate bankstatement	1 Nov 23	836
can i import journal entries from Excel import	1 Aug 24	352
Import from Winbooks Solved import	3 Aug 24	1821
Odoo 17 Studio import	1 Feb 24	1122
How to find credentials are updated in online synchronization? bankstatement	0 Jan 24	319

This question has been flagged

Enjoying the discussion? Don't just read, join in!