Thursday, July 16, 2026
1 change · 19.0
Enhancements to existing features
The bank reconciliation screen now finds eligible accounting entries more efficiently on large databases. This reduces long wait times when loading reconciliation suggestions, helping accounting teams work faster without changing their workflow.
Original PR description
The bank reconciliation widget's `search_read` on `account.move.line` use `search_account_id.reconcile` to filter reconcilable accounts. This caused PostgreSQL to prefer an ordered index scan on `_date_name_id_idx`, walking ~3M rows for ~100 matches (40+ seconds on large db). Solution : match the approach already applied on the Python side in `_get_default_amls_matching_domain` This lets the planner use the existing _unreconciled_index partial index instead. opw-6328640