Skip to Content
Menu
This question has been flagged
1 Reply
2501 Views



Environment is Odoo 14 - online 


Whilst reconciling some (miscellaneous) journals using the Accounting | Reconciliation menu, I got a message warning me that I was trying to reconcile items that were already reconciled; I unfortunately did not record the exact message.

After the above incident, I could not access the bank reconciliation function anymore as per the attached screen capture


The error message is:

Error:

Odoo Server Error


Traceback (most recent call last):

  File "/home/odoo/src/odoo/14.0/odoo/addons/base/models/ir_http.py", line 237, in _dispatch

    result = request.dispatch()

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 683, in dispatch

    result = self._call_function(**self.params)

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 359, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/home/odoo/src/odoo/14.0/odoo/service/model.py", line 94, in wrapper

    return f(dbname, *args, **kwargs)

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 347, in checked_call

    result = self.endpoint(*a, **kw)

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 912, in __call__

    return self.method(*args, **kw)

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 531, in response_wrap

    response = f(*args, **kw)

  File "/home/odoo/src/odoo/14.0/addons/web/controllers/main.py", line 1377, in call_kw

    return self._call_kw(model, method, args, kwargs)

  File "/home/odoo/src/odoo/14.0/addons/web/controllers/main.py", line 1369, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 392, in call_kw

    result = _call_kw_model(method, model, args, kwargs)

  File "/home/odoo/src/odoo/14.0/odoo/api.py", line 365, in _call_kw_model

    result = method(recs, *args, **kwargs)

  File "/home/odoo/src/enterprise/14.0/account_batch_payment/models/widget_reconciliation.py", line 61, in get_bank_statement_data

    res = super(AccountReconciliation, self).get_bank_statement_data(bank_statement_line_ids, srch_domain)

  File "/home/odoo/src/enterprise/14.0/account_accountant/models/reconciliation_widget.py", line 228, in get_bank_statement_data

    results = self.get_bank_statement_line_data(bank_statement_lines.ids)

  File "/home/odoo/src/enterprise/14.0/account_accountant/models/reconciliation_widget.py", line 170, in get_bank_statement_line_data

    matching_amls = reconcile_model._apply_rules(bank_statement_lines, excluded_ids=excluded_ids, partner_map=partner_map)

  File "/home/odoo/src/odoo/14.0/addons/account/models/account_reconcile_model.py", line 478, in _apply_rules

    partner = mapped_partner or rec_model._get_partner_from_mapping(st_line)

  File "/home/odoo/src/odoo/14.0/addons/account/models/account_reconcile_model.py", line 747, in _get_partner_from_mapping

    match_payment_ref = re.match(partner_mapping.payment_ref_regex, st_line.payment_ref) if partner_mapping.payment_ref_regex else True

  File "/usr/lib/python3.8/re.py", line 191, in match

    return _compile(pattern, flags).match(string)

  File "/usr/lib/python3.8/re.py", line 304, in _compile

    p = sre_compile.compile(pattern, flags)

  File "/usr/lib/python3.8/sre_compile.py", line 764, in compile

    p = sre_parse.parse(p, flags)

  File "/usr/lib/python3.8/sre_parse.py", line 948, in parse

    p = _parse_sub(source, state, flags & SRE_FLAG_VERBOSE, 0)

  File "/usr/lib/python3.8/sre_parse.py", line 443, in _parse_sub

    itemsappend(_parse(source, state, verbose, nested + 1,

  File "/usr/lib/python3.8/sre_parse.py", line 668, in _parse

    raise source.error("nothing to repeat",

Exception


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


Traceback (most recent call last):

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 639, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/home/odoo/src/odoo/14.0/odoo/http.py", line 315, in _handle_exception

    raise exception.with_traceback(None) from new_cause

re.error: nothing to repeat at position 0

I suspect that I inadvertently reconciled a journal item in duplicate causing a conflict in the database...

Is there a way to revert (unreconcile) journal reconciliations (not bank related ones) that were effected in the Accounting | Reconciliation submenu

Thank you for your advice



Avatar
Discard

Thanks for updating the community with your findings

Author Best Answer

I found the issue which was due to:

a syntax error (the Regex expression) which was introduced when adding a new line in the 'Invoices Matching Rule' bank reconciliation model.

Avatar
Discard