Wednesday, November 26, 2025
1 change · 17.0
Enhancements to existing features
This update ensures queries in our project accounting modules use fully qualified column names (e.g., `account_move.balance`). This clarifies data sources and prevents ambiguity, especially when joining tables like `account_move` and `account_move_line`. It also helps avoid confusion with custom module columns, leading to more reliable reporting and data accuracy.
Original PR description
Use fully qualified column names when constructing a query, more specifically, include the table that the column is originating from. The rule of thumb is that we always include the table name alongside the column name. In this particular case, the query will do a `JOIN` on `account_move` and there may be ambiguousness as to whether to take the `balance` column from `account_move` or `account_move_line`. The former column used to exist in the past and was likely kept for data retention purposes. Hence, there are still databases in 17.0 where `account_move.balance` exists. Another reason to include the table name is to prevent confusion with columns coming from custom modules. --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr