Odoo Changelog — 2025-01-31

Friday, January 31, 2025

6 changes · saas-18.1

Bug Fixes(6)

Resolved issues and error corrections

[FIX] stock: account for context in product.template quantities calculation

PR #195730

Coresaas-18.1stockMedium

Product availability and forecasted quantities now respect the selected warehouse, so each warehouse shows its own stock figures instead of reusing the first warehouse's values. This helps POS users and inventory teams make decisions based on accurate multi-warehouse stock information.

Original PR description

Currently, the available and forecasted product quantities are not always calculated correctly across multiple warehouses.

### Steps to reproduce

1. Install the `stock` and `point_of_sale` modules.
2. Ensure that a product exists in multiple warehouses, with different quantities in each warehouse.
3. Make sure the product is available in the POS.
4. Start the POS.
5. Find the product and click the "i" button in the top-right corner to view more details.

Expected Behavior: The system should display the correct available and forecasted quantities for each warehouse. Actual Behavior: All warehouses incorrectly show the same available and forecasted quantities.

### Cause

The system retrieves product quantities by reading the `qty_available` and `virtual_available` fields on the product template record, applying a `warehouse_id` context key for each warehouse (see [here](https://github.com/odoo/odoo/blob/afac1319a2bf230ec0702a7822fca405638fc38b/addons/point_of_sale/models/product_template.py#L215-L221)). However, these fields are computed and do not depend on the context, meaning only the quantities for the first warehouse are computed correctly. For all other warehouses, the values are retrieved from the cache, resulting in all warehouses displaying the same quantities.

opw-4421070

#inventory#warehouse#point_of_sale#stock quantities

[FIX] account: prevent error on opening catalog

PR #195268

Coresaas-18.1accountMedium

Fixes a crash that could happen when users opened the Catalog from invoice lines on a new invoice. This makes invoice creation smoother by ensuring the product catalog loads reliably instead of showing an error.

Original PR description

This error occurs when we click on the ``Catalog`` button in move lines.

Steps to reproduce:
---
- Install ``Invoicing`` module
- Open NEW invoice > Click on ``Catalog`` in Invoice lines

Traceback:
---
```
IndexError: list index out of range
  File "odoo/http.py", line 2406, in __call__
    response = request._serve_db()
  File "odoo/http.py", line 1934, in _serve_db
    return self._transactioning(
  File "odoo/http.py", line 1997, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "odoo/service/model.py", line 137, in retrying
    result = func()
  File "odoo/http.py", line 1964, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "odoo/http.py", line 2214, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "odoo/addons/base/models/ir_http.py", line 334, in _dispatch
    result = endpoint(**request.params)
  File "odoo/http.py", line 733, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "addons/web/controllers/dataset.py", line 31, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "odoo/service/model.py", line 51, in call_kw
    ids, args = args[0], args[1:]
```

The issue arises because the absence of the ``@api.model`` decorator in the original implementation prevents Odoo's ORM from properly recognizing the method as a ``model method``. To resolve this, the ``@api.model`` decorator was added above the ``search_read`` method.

sentry-6232832214

---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

[FIX] spreadsheet: update o_spreadsheet to latest version

PR #195937

Coresaas-18.1spreadsheetMedium

This update brings Odoo's spreadsheet engine up to the latest 18.1 version with multiple fixes for editing, formulas, pivot values, imports/exports, and display behavior. Users should see fewer spreadsheet errors, more accurate calculations, and smoother interactions when working with cells, selections, and Excel files.

Original PR description

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0 https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide…

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0
https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide auto-complete when selecting a cell Task: 4022927
https://github.com/odoo/o-spreadsheet/commit/79e6457ce [FIX] locale: wrong parsing with "." thousand separator Task: 4525746
https://github.com/odoo/o-spreadsheet/commit/44edb8365 [FIX] ui_sheet: batch resize commands in `AUTORESIZE_ROWS` Task: 4504918
https://github.com/odoo/o-spreadsheet/commit/1f36f4e2d [FIX] pivot: use displayed value in computed measure Task: 4517312
https://github.com/odoo/o-spreadsheet/commit/a11ef279d [REL] 18.1.4 Task: 0
https://github.com/odoo/o-spreadsheet/commit/47d6c123e [FIX] session: useless snapshot on leave Task: 4356913
https://github.com/odoo/o-spreadsheet/commit/936b264ca [FIX] xlsx: fix data validation range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/9dbe36b4e [REF] range: rename useFixedReference Task: 4506120
https://github.com/odoo/o-spreadsheet/commit/52dabf1e4 [FIX] xlsx: export data validation with unbounded range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/7ffac1e6e [REL] 18.1.3 Task: 0
https://github.com/odoo/o-spreadsheet/commit/7365956a3 [FIX] TextValueProvider: Avoid duplicate key in template Task: 4483494
https://github.com/odoo/o-spreadsheet/commit/14bd65a68 [FIX] formulas: binary search returning incorrect index for multiple exact matches Task: 4328300
https://github.com/odoo/o-spreadsheet/commit/967f484a9 [FIX] selection: drag and drop resized cols and rows Task: 4454025
https://github.com/odoo/o-spreadsheet/commit/c2b340c95 [FIX] popover: wrong position on updated popover Task: 3814260
https://github.com/odoo/o-spreadsheet/commit/a8ed632af [FIX] Selection: selection follows the moved header Task: 4461901
https://github.com/odoo/o-spreadsheet/commit/655904b57 [FIX] icons: Missing dimension on icon Task: 4461359
https://github.com/odoo/o-spreadsheet/commit/739edba84 [FIX] GridComposer: Fix CellReference pill display Task: 4501136
https://github.com/odoo/o-spreadsheet/commit/817bf51d4 [FIX] renderer: Fix grid rendering Task: 4448426

Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com>
Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com>
Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com>
Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com>
Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com>
Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com>
Co-authored-by: Florian Damhaut (flda) <flda@odoo.com>
Co-authored-by: Rémi Rahir (rar) <rar@odoo.com>
Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com>
Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>

[FIX] spreadsheet: update o_spreadsheet to latest version

PR #195936

Coresaas-18.1spreadsheetMedium

This update refreshes Odoo's spreadsheet component with several bug fixes that make spreadsheets behave more reliably. Users should see more accurate number handling, formula results, pivot values, Excel exports, selections, and on-screen positioning when working with spreadsheets.

Original PR description

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0 https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide…

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0
https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide auto-complete when selecting a cell Task: 4022927
https://github.com/odoo/o-spreadsheet/commit/79e6457ce [FIX] locale: wrong parsing with "." thousand separator Task: 4525746
https://github.com/odoo/o-spreadsheet/commit/44edb8365 [FIX] ui_sheet: batch resize commands in `AUTORESIZE_ROWS` Task: 4504918
https://github.com/odoo/o-spreadsheet/commit/1f36f4e2d [FIX] pivot: use displayed value in computed measure Task: 4517312
https://github.com/odoo/o-spreadsheet/commit/a11ef279d [REL] 18.1.4 Task: 0
https://github.com/odoo/o-spreadsheet/commit/47d6c123e [FIX] session: useless snapshot on leave Task: 4356913
https://github.com/odoo/o-spreadsheet/commit/936b264ca [FIX] xlsx: fix data validation range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/9dbe36b4e [REF] range: rename useFixedReference Task: 4506120
https://github.com/odoo/o-spreadsheet/commit/52dabf1e4 [FIX] xlsx: export data validation with unbounded range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/7ffac1e6e [REL] 18.1.3 Task: 0
https://github.com/odoo/o-spreadsheet/commit/7365956a3 [FIX] TextValueProvider: Avoid duplicate key in template Task: 4483494
https://github.com/odoo/o-spreadsheet/commit/14bd65a68 [FIX] formulas: binary search returning incorrect index for multiple exact matches Task: 4328300
https://github.com/odoo/o-spreadsheet/commit/967f484a9 [FIX] selection: drag and drop resized cols and rows Task: 4454025
https://github.com/odoo/o-spreadsheet/commit/c2b340c95 [FIX] popover: wrong position on updated popover Task: 3814260
https://github.com/odoo/o-spreadsheet/commit/a8ed632af [FIX] Selection: selection follows the moved header Task: 4461901
https://github.com/odoo/o-spreadsheet/commit/655904b57 [FIX] icons: Missing dimension on icon Task: 4461359
https://github.com/odoo/o-spreadsheet/commit/739edba84 [FIX] GridComposer: Fix CellReference pill display Task: 4501136
https://github.com/odoo/o-spreadsheet/commit/817bf51d4 [FIX] renderer: Fix grid rendering Task: 4448426

Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com>
Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com>
Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com>
Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com>
Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com>
Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com>
Co-authored-by: Florian Damhaut (flda) <flda@odoo.com>
Co-authored-by: Rémi Rahir (rar) <rar@odoo.com>
Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com>
Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>

[FIX] spreadsheet: update o_spreadsheet to latest version

PR #195934

Coresaas-18.1spreadsheetMedium

This update brings the spreadsheet component to a newer maintenance version with multiple fixes for editing, selection, imports and exports. Users should see fewer glitches when working with cell references, pivots, row or column resizing, locale-specific numbers, and Excel file validation rules.

Original PR description

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0 https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide…

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0
https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide auto-complete when selecting a cell Task: 4022927
https://github.com/odoo/o-spreadsheet/commit/79e6457ce [FIX] locale: wrong parsing with "." thousand separator Task: 4525746
https://github.com/odoo/o-spreadsheet/commit/44edb8365 [FIX] ui_sheet: batch resize commands in `AUTORESIZE_ROWS` Task: 4504918
https://github.com/odoo/o-spreadsheet/commit/1f36f4e2d [FIX] pivot: use displayed value in computed measure Task: 4517312
https://github.com/odoo/o-spreadsheet/commit/a11ef279d [REL] 18.1.4 Task: 0
https://github.com/odoo/o-spreadsheet/commit/47d6c123e [FIX] session: useless snapshot on leave Task: 4356913
https://github.com/odoo/o-spreadsheet/commit/936b264ca [FIX] xlsx: fix data validation range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/9dbe36b4e [REF] range: rename useFixedReference Task: 4506120
https://github.com/odoo/o-spreadsheet/commit/52dabf1e4 [FIX] xlsx: export data validation with unbounded range Task: 4505771
https://github.com/odoo/o-spreadsheet/commit/7ffac1e6e [REL] 18.1.3 Task: 0
https://github.com/odoo/o-spreadsheet/commit/7365956a3 [FIX] TextValueProvider: Avoid duplicate key in template Task: 4483494
https://github.com/odoo/o-spreadsheet/commit/14bd65a68 [FIX] formulas: binary search returning incorrect index for multiple exact matches Task: 4328300
https://github.com/odoo/o-spreadsheet/commit/967f484a9 [FIX] selection: drag and drop resized cols and rows Task: 4454025
https://github.com/odoo/o-spreadsheet/commit/c2b340c95 [FIX] popover: wrong position on updated popover Task: 3814260
https://github.com/odoo/o-spreadsheet/commit/a8ed632af [FIX] Selection: selection follows the moved header Task: 4461901
https://github.com/odoo/o-spreadsheet/commit/655904b57 [FIX] icons: Missing dimension on icon Task: 4461359
https://github.com/odoo/o-spreadsheet/commit/739edba84 [FIX] GridComposer: Fix CellReference pill display Task: 4501136
https://github.com/odoo/o-spreadsheet/commit/817bf51d4 [FIX] renderer: Fix grid rendering Task: 4448426

Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com>
Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com>
Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com>
Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com>
Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com>
Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com>
Co-authored-by: Florian Damhaut (flda) <flda@odoo.com>
Co-authored-by: Rémi Rahir (rar) <rar@odoo.com>
Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com>
Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>

[WIP][FIX] l10n_be_hr_payroll: fix traceback for sales on payroll

PR #78264

Enterprisesaas-18.1hr_payrolll10n_be_hr_payrollMedium

Creating a new payslip for Belgian salespeople with specific leave work entries no longer triggers an error. This helps payroll teams process affected employee payslips without interruption before the record is saved.

Original PR description

Bug:
When creating a new payslip for a salesperson with work entries of code LEAVE1731, we would get a traceback.

Reason:
Since we were creating the record and did not yet save, the code was calling a method that did an SQL query on ids of self which is empty.

Fix:
We created a new method that uses the orm instead to handle this specific case.

#payroll#belgium#payslips#sales

Currently, the available and forecasted product quantities are not always calculated correctly across multiple warehouses. ### Steps to reproduce 1. Install the `stock` and `point_of_sale` modules. 2. Ensure that a product exists in multiple warehouses, with different quantities in each warehouse. 3. Make sure the product is available in the POS. 4. Start the POS. 5. Find the product and click the "i" button in the top-right corner to view more details. Expected Behavior: The system should display the correct available and forecasted quantities for each warehouse. Actual Behavior: All warehouses incorrectly show the same available and forecasted quantities. ### Cause The system retrieves product quantities by reading the `qty_available` and `virtual_available` fields on the product template record, applying a `warehouse_id` context key for each warehouse (see [here](https://github.com/odoo/odoo/blob/afac1319a2bf230ec0702a7822fca405638fc38b/addons/point_of_sale/models/product_template.py#L215-L221)). However, these fields are computed and do not depend on the context, meaning only the quantities for the first warehouse are computed correctly. For all other warehouses, the values are retrieved from the cache, resulting in all warehouses displaying the same quantities. opw-4421070

This error occurs when we click on the ``Catalog`` button in move lines. Steps to reproduce: --- - Install ``Invoicing`` module - Open NEW invoice > Click on ``Catalog`` in Invoice lines Traceback: --- ``` IndexError: list index out of range File "odoo/http.py", line 2406, in __call__ response = request._serve_db() File "odoo/http.py", line 1934, in _serve_db return self._transactioning( File "odoo/http.py", line 1997, in _transactioning return service_model.retrying(func, env=self.env) File "odoo/service/model.py", line 137, in retrying result = func() File "odoo/http.py", line 1964, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "odoo/http.py", line 2214, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "odoo/addons/base/models/ir_http.py", line 334, in _dispatch result = endpoint(**request.params) File "odoo/http.py", line 733, in route_wrapper result = endpoint(self, *args, **params_ok) File "addons/web/controllers/dataset.py", line 31, in call_kw return call_kw(request.env[model], method, args, kwargs) File "odoo/service/model.py", line 51, in call_kw ids, args = args[0], args[1:] ``` The issue arises because the absence of the ``@api.model`` decorator in the original implementation prevents Odoo's ORM from properly recognizing the method as a ``model method``. To resolve this, the ``@api.model`` decorator was added above the ``search_read`` method. sentry-6232832214 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/97acb8b19 [REL] 18.1.5 Task: 0 https://github.com/odoo/o-spreadsheet/commit/4210ee378 [FIX] auto-complete: hide auto-complete when selecting a cell Task: 4022927 https://github.com/odoo/o-spreadsheet/commit/79e6457ce [FIX] locale: wrong parsing with "." thousand separator Task: 4525746 https://github.com/odoo/o-spreadsheet/commit/44edb8365 [FIX] ui_sheet: batch resize commands in `AUTORESIZE_ROWS` Task: 4504918 https://github.com/odoo/o-spreadsheet/commit/1f36f4e2d [FIX] pivot: use displayed value in computed measure Task: 4517312 https://github.com/odoo/o-spreadsheet/commit/a11ef279d [REL] 18.1.4 Task: 0 https://github.com/odoo/o-spreadsheet/commit/47d6c123e [FIX] session: useless snapshot on leave Task: 4356913 https://github.com/odoo/o-spreadsheet/commit/936b264ca [FIX] xlsx: fix data validation range Task: 4505771 https://github.com/odoo/o-spreadsheet/commit/9dbe36b4e [REF] range: rename useFixedReference Task: 4506120 https://github.com/odoo/o-spreadsheet/commit/52dabf1e4 [FIX] xlsx: export data validation with unbounded range Task: 4505771 https://github.com/odoo/o-spreadsheet/commit/7ffac1e6e [REL] 18.1.3 Task: 0 https://github.com/odoo/o-spreadsheet/commit/7365956a3 [FIX] TextValueProvider: Avoid duplicate key in template Task: 4483494 https://github.com/odoo/o-spreadsheet/commit/14bd65a68 [FIX] formulas: binary search returning incorrect index for multiple exact matches Task: 4328300 https://github.com/odoo/o-spreadsheet/commit/967f484a9 [FIX] selection: drag and drop resized cols and rows Task: 4454025 https://github.com/odoo/o-spreadsheet/commit/c2b340c95 [FIX] popover: wrong position on updated popover Task: 3814260 https://github.com/odoo/o-spreadsheet/commit/a8ed632af [FIX] Selection: selection follows the moved header Task: 4461901 https://github.com/odoo/o-spreadsheet/commit/655904b57 [FIX] icons: Missing dimension on icon Task: 4461359 https://github.com/odoo/o-spreadsheet/commit/739edba84 [FIX] GridComposer: Fix CellReference pill display Task: 4501136 https://github.com/odoo/o-spreadsheet/commit/817bf51d4 [FIX] renderer: Fix grid rendering Task: 4448426 Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com> Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com> Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com> Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com> Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com> Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com> Co-authored-by: Florian Damhaut (flda) <flda@odoo.com> Co-authored-by: Rémi Rahir (rar) <rar@odoo.com> Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com> Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>

Bug: When creating a new payslip for a salesperson with work entries of code LEAVE1731, we would get a traceback. Reason: Since we were creating the record and did not yet save, the code was calling a method that did an SQL query on ids of self which is empty. Fix: We created a new method that uses the orm instead to handle this specific case.