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
Thanks for updating the community with your findings