Skip to Content
This question has been flagged
importbankstatement
3 Replies
5016 Zobrazenia
Avatar
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?

Avatar
Zrušiť
Avatar
Masin Al-Dujaili
Best Answer

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.

Avatar
Zrušiť
Avatar
Jan Fischer
Autor Best Answer


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

Avatar
Zrušiť
Avatar
Deerom Technologies Pvt.Ltd
Best Answer

Hi,

   Please refer this link Bank Statements    Video

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Prevent duplicate importing bank statement
import duplicate bankstatement
Avatar
Avatar
1
nov 23
2772
Issue with import and comma in Excel File (odoo 19)
import
Avatar
0
sep 25
234
Looking for a bank statement import template and guidance on how to import into Odoo
bankstatement
Avatar
Avatar
1
jún 25
3586
Importacion de Atributos y Valores
import
Avatar
Avatar
Avatar
2
máj 25
2291
Import from Winbooks Solved
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
máj 25
6733