Skip to Content

Account Reconcile OCA

by , ,
Odoo
v 16.0 Third Party 3102
Download for v 16.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Community Apps Dependencies
Lines of code 3589
Technical Name account_reconcile_oca
LicenseAGPL-3
Websitehttps://github.com/OCA/account-reconcile
Versions 16.0 17.0 18.0
You bought this module and need support? Click here!
Odoo Community Association

Account Reconcile OCA

Beta License: AGPL-3 OCA/account-reconcile Translate me on Weblate Try me on Runboat

This addon allows to reconcile bank statements and account marked as reconcile.

Table of contents

Usage

Bank reconcile

Access Invoicing / Dashboard with a user with Full Acounting capabilities. Select reconcile on the journal of your choice.

Account reconcile

Access Invoicing / Accounting / Actions / Reconcile All the possible reconcile options will show and you will be able to reconcile properly. You can access the same widget from accounts and Partners.

Note : in case this module is installed on a migrated database, the reconciliation models will not be set by default. So they need to be set manually.

![Reconciliation model : full payment](../static/description/reconcile-model-full.png)

![Reconciliation model : partial payment](../static/description/reconcile-model-partial.png)

Known issues / Roadmap

The following bugs are already detected:

  • Creation of activities on the chatter do show automatically

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • CreuBlanca
  • Dixmit

Contributors

  • Enric Tobella

Other credits

The system has been improved to handle currency amounts more effectively with the financial support of Sygel Technology.

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:

etobella

This module is part of the OCA/account-reconcile project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Appeare error
by
PT Ecosains Hayati
on 1/9/24, 12:13 PM

RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 989, in get
    cache_value = field_cache[record._ids[0]]
KeyError: 8

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1160, in __get__
    value = env.cache.get(record, self)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 996, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'account.bank.statement.line(8,).can_reconcile'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 989, in get
    cache_value = field_cache[record._ids[0]]
KeyError: 8

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1160, in __get__
    value = env.cache.get(record, self)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 996, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'account.bank.statement.line(8,).reconcile_data_info'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1589, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1616, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1820, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 697, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 466, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2989, in read
    return self._read_format(fnames=fields, load=load)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3168, in _read_format
    vals[name] = convert(record[name], record, use_name_get)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5904, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1209, in __get__
    self.compute_value(recs)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1391, in compute_value
    records._compute_field_value(self)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4225, in _compute_field_value
    fields.determine(field.compute, self)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 100, in determine
    return needle(records, *args)
  File "/usr/lib/python3/dist-packages/odoo/addons/base_sparse_field/models/fields.py", line 52, in _compute_sparse
    values = record[self.sparse]
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5904, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1209, in __get__
    self.compute_value(recs)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1391, in compute_value
    records._compute_field_value(self)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4225, in _compute_field_value
    fields.determine(field.compute, self)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 97, in determine
    return needle(*args)
  File "/mnt/extra-addons/account_reconcile_oca/models/account_bank_statement_line.py", line 333, in _compute_reconcile_data_info
    record.reconcile_data_info = record._default_reconcile_data(
  File "/mnt/extra-addons/account_reconcile_oca/models/account_bank_statement_line.py", line 444, in _default_reconcile_data
    *self._reconcile_data_by_model(
  File "/mnt/extra-addons/account_reconcile_oca/models/account_bank_statement_line.py", line 362, in _reconcile_data_by_model
    for line in reconcile_model._get_write_off_move_lines_dict(
  File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_reconcile_model.py", line 523, in _get_write_off_move_lines_dict
    if currency.is_zero(balance):
UnboundLocalError: local variable 'balance' referenced before assignment

The above server error caused the following client error:
null

Reconciliation Issue
by
Tadelo Ferede
on 8/28/23, 5:05 AM

UncaughtPromiseError > TypeError
Uncaught Promise > Cannot read properties of undefined (reading 'model')
TypeError: Cannot read properties of undefined (reading 'model')
at ReconcileController.selectRecord (http://localhost:8069/web/assets/197-143a6dd/web.assets_backend.min.js:13946:94)
at ReconcileController.openRecord (http://localhost:8069/web/assets/197-143a6dd/web.assets_backend.min.js:13949:31)
at ReconcileKanbanRecord.onGlobalClick (http://localhost:8069/web/assets/197-143a6dd/web.assets_backend.min.js:4243:410)
at Object.mainEventHandler (http://localhost:8069/web/assets/187-281ebe1/web.assets_common.min.js:1997:77)
at HTMLDivElement.listener (http://localhost:8069/web/assets/187-281ebe1/web.assets_common.min.js:1240:15)

error
by
breb7760@gmail.com
on 8/17/23, 2:42 AM

RPC_ERROR

Odoo Server Error

Traceback (most recent call last):
  File "/root/odoo16/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/root/odoo16/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/root/odoo16/odoo/http.py", line 1611, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/root/odoo16/odoo/http.py", line 1815, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/root/odoo16/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/root/odoo16/odoo/http.py", line 697, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/root/odoo16/addons/web/controllers/dataset.py", line 46, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "/root/odoo16/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/root/odoo16/odoo/api.py", line 461, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/root/odoo16/odoo/api.py", line 448, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/root/odoo16/addons/account/models/account_payment.py", line 1003, in button_open_statement_lines
    if len(self.reconciled_statement_lines_ids) == 1:
AttributeError: 'account.payment' object has no attribute 'reconciled_statement_lines_ids'


Error
by
Ahmad Fatoni Febri Wihando
on 6/13/23, 5:41 AM

Please fix it because there is an error in the reconciliation section 

Caused by: RPC_ERROR: "Odoo Server Error
at makeErrorFromResponse (http://localhost:8069/web/assets/199-c669b9f/web.assets_backend.min.js:970:163)
at XMLHttpRequest. (http://localhost:8069/web/assets/199-c669b9f/web.assets_backend.min.js:978:13)"