Account Reconcile Partner Regex SQL Fix
Account Reconcile Partner Regex SQL Fix
This module patches partner matching logic for bank statement reconciliation to handle translated JSONB partner names correctly when building regex matches.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0This module fixes how Odoo finds the right partner when reconciling bank statement lines, especially when partner names are stored in multiple languages. It replaces the standard partner search with a more robust database query.
When you import a bank statement, Odoo tries to guess the partner for each line. This module changes that guessing logic on account.bank.statement.line so it works correctly with translated partner names.
- It still checks the partner already set on the line, the bank account number, and the partner name.
- It also checks reconciliation models and their partner mappings.
- The main fix is a new database query that compares the text on the statement line (payment reference, narration, or reference) against partner names. It uses PostgreSQL regular expressions and unaccent to ignore accents and match words of three or more characters.
- The query handles partner names stored as JSONB (translated names) by extracting the plain text value.
- It only considers active partners and limits the search to the company of the statement line.
This module does not add menus, buttons, or reports. It only changes the automatic partner detection during bank reconciliation, making it more reliable for companies that use translated partner names.
Depends on
Models and fields (1)
- account.bank.statement.line · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 18.0
Confirmed on 2026-11-03 in branch 18.0 of OCA/l10n-bulgaria.
terminal Installation and usage
No verified informationInstallation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.