Daily updates from Odoo
Monday, October 14, 2024
14 changes
1 change
Resolved issues and error corrections
This update brings the embedded spreadsheet engine to a newer maintenance version and fixes several issues affecting formatting, exporting, find-and-replace, and session handling. Users should see more reliable spreadsheet behavior, especially when copying table styles, exporting styled sheets, and searching formulas.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/7e88becba [REL] 17.2.24 Task: 0 https://github.com/odoo/o-spreadsheet/commit/1b554f7e1 [FIX] session: ignore already…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/7e88becba [REL] 17.2.24 Task: 0 https://github.com/odoo/o-spreadsheet/commit/1b554f7e1 [FIX] session: ignore already processed SNAPSHOT_CREATED Task: 4243943 https://github.com/odoo/o-spreadsheet/commit/f562b8eed [FIX] clipboard: cannot paste whole table style Task: 4218988 https://github.com/odoo/o-spreadsheet/commit/2289fc357 [FIX] export: Fix default style ignored at export Task: 4178743 https://github.com/odoo/o-spreadsheet/commit/b57230ff5 [FIX] table: update table style on header group removal Task: 4081345 https://github.com/odoo/o-spreadsheet/commit/d73ba2ab8 [FIX] Find&Replace: always search cell content if `searchFormula` Task: 4175968 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: 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>
6 changes
Resolved issues and error corrections
This update combines several fixes and small improvements across Odoo, including more accurate purchase valuation calculations, better portal invoice-sending preferences, and smoother user interface hover behavior. It also resolves Point of Sale issues for company branches and superuser sessions, and updates German tax report presentation to better match local expectations.
Original PR description
Description of the issue/feature this PR addresses: Clean the drop down menu hover on the "mobile menu" word by remplacing the "mobile menu" to "QR menu" for better constancy with the settings Current behavior before PR: Desired behavior after PR is merged: --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
This update refreshes Odoo's spreadsheet engine with fixes and improvements for pivot tables, charts, formatting, autofill, clipboard handling, and Excel export. Users should see more reliable spreadsheet behavior, better chart handling, and fewer issues when duplicating or exporting spreadsheet content.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/1771f68b4 [REL] 18.0.1 Task: 0 https://github.com/odoo/o-spreadsheet/commit/7ea2733a9 [FIX] session: ignore already…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/1771f68b4 [REL] 18.0.1 Task: 0 https://github.com/odoo/o-spreadsheet/commit/7ea2733a9 [FIX] session: ignore already processed SNAPSHOT_CREATED Task: 4243943 https://github.com/odoo/o-spreadsheet/commit/77c19d8f8 [FIX] pivot: finer grained cycle detection Task: 4214188 https://github.com/odoo/o-spreadsheet/commit/246d233be [FIX] data validation: unify checkbox style Task: 4235283 https://github.com/odoo/o-spreadsheet/commit/2a83a3efc [FIX] pivot: date time measures are not supported Task: 4241036 https://github.com/odoo/o-spreadsheet/commit/7dfcb2a7c [IMP] pivot: duplicate pivot with table Task: 4048028 https://github.com/odoo/o-spreadsheet/commit/d29a874ba [FIX] paint format: properly paint borders and tables Task: 4213894 https://github.com/odoo/o-spreadsheet/commit/a006d0b46 [IMP] autofill: support date autofill Task: 4173602 https://github.com/odoo/o-spreadsheet/commit/941317f65 [FIX] pivot: remove forbidden chars when duplicating Task: 4221325 https://github.com/odoo/o-spreadsheet/commit/3fd1ef930 [FIX] clipboard: cannot paste whole table style Task: 4218988 https://github.com/odoo/o-spreadsheet/commit/eb412abf4 [FIX] xlsx: fix table total row export Task: 4206619 https://github.com/odoo/o-spreadsheet/commit/70e8b8f79 [FIX] pivot: wrong headers with hidden measures Task: 4190869 https://github.com/odoo/o-spreadsheet/commit/d85d4bc01 [FIX] pivot: running total display with multiple measures Task: 4207244 https://github.com/odoo/o-spreadsheet/commit/449782abe [IMP] charts: handles multiple bars in combo chart Task: 4164614 https://github.com/odoo/o-spreadsheet/commit/d89d673be [FIX] autocomplete: Stop the range selection after selecting a pivot proposal Task: 4176481 https://github.com/odoo/o-spreadsheet/commit/f0d1602ee [PERF] Actions: Fill missing ids with fast unique values Task: 4216427 https://github.com/odoo/o-spreadsheet/commit/cee2e47e8 [REL] 18.0 https://github.com/odoo/o-spreadsheet/commit/de00e5f17 [FIX] charts: fix combo chart export Task: 4092078 https://github.com/odoo/o-spreadsheet/commit/f1a7866f7 [IMP] Charts: ignore hidden row/cols in datasets and labels Task: 3976159 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: 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>
This fix gives avatar-based employee/user fields enough room in list views and prevents action buttons from spilling outside their columns. Work order lists should look cleaner and remain usable when buttons change after an action starts.
Original PR description
Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Closing a restaurant register now ignores unfinished local orders that do not yet have a final system ID. This prevents an error when canceling ongoing table orders, helping staff close sessions reliably.
Original PR description
Steps to reproduce:
---
- Install the ``pos_restaurant`` module
- Open Register of Restaurant > Select any table
- Add two tables from the (+) sign
- Complete the order in the first table and In the second table just order the food(Don't make payment)
- Now Close the register and cancel the orders
Traceback:
---
``Expected singleton: pos.order('p', 'o', 's', '.', 'o', 'r', 'd', 'e', 'r', '_', '3')``
Previous Behaviour:
---
When we closed the register and canceled an order, it included orders with a status of 'Ongoing.' These ongoing orders have an ``order ID like "pos.order_3"`` which is causing an error.
After Commit:
---
We will now only pass the order whose id will be in number when closing the register. Due to this, we will only have the order whose id is in number.
sentry-5703437687
---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-prThis fix prevents module upgrades from failing when payroll work entry types update their country information while existing work entries are present. Businesses can upgrade affected payroll localization modules without manually removing or changing existing work entry records.
Original PR description
A new constraint on model `hr.work.entry.type` triggers an error while updating `country_id` if related work entries exist. Since a lot of the data records from enterprise don't have the noupdate flag and they include the country as a field to update, the constraint is triggered just by upgrading the module. Steps to reproduce: - Install one of the affected modules (eg `l10n_au_hr_payroll`) - Create a work entry from one of the types from the module - Upgrade the module.
Fixed an error that prevented users from opening Vietnamese sales and purchase tax return reports in certain tax period views. This ensures companies using Vietnam localization can access required tax reports reliably.
Original PR description
Currently, a traceback is occurring when the user tries to open a Vietnamese tax returns report. To reproduce this issue: 1) Install l10n_vn_reports and switch to VN company 2) Create an invoice with a product and tax 3) Now open the Tax Returns and change the report as `Sales/Purchase Tax Report (VN)` and tax period in years Error:- ``` ProgrammingError: can't adapt type 'dict' ``` This error is occurring because in `column_group_options` we get the values as dict. For the method `_currency_table_apply_rate` we expect the value to be in the string. To handle the dict for returning the join conditions we use `_currency_table_aml_join`. sentry-5962808992
7 changes
Resolved issues and error corrections
This fix prevents duplicate accounting records from being created when setting up companies with parent-subsidiary relationships. The system now loads the chart of accounts from parent companies first during initialization and migration, ensuring clean and accurate financial data structures across all localization modules.
Original PR description
In migration and init scripts, when loading the chart of accounts or parts of it, we should always start with the parent companies to avoid creating duplicate chart records
This update resolves a crash that occurred when users tried to print or export the trial balance report to Excel. The issue was caused by a recent code change that didn't properly handle certain data conditions, resulting in an error message instead of a successful export. Users can now export trial balance reports without encountering errors.
Original PR description
before this commit, on printing trial balance report in excel, raises an exception when the level is None it cannot be compared with >= and thus exception is shown: elif level >= 3: TypeError: '>=' not supported between instances of 'NoneType' and 'int'  introduced in the commit: https://github.com/odoo/enterprise/commit/9d1f27082cc2e837951a3a5c3337cc90531de04a after this commit, no error wont be shown when printing trial balance in excel Forward-Port-Of: odoo/enterprise#71846
This fix prevents helpdesk timesheets from being incorrectly merged together when tracking time on different helpdesk tickets. Previously, when users tracked time on different tickets within the same helpdesk project, the system would combine them into a single timesheet entry instead of creating separate ones. This update ensures each ticket gets its own timesheet record, improving time tracking accuracy for helpdesk teams.
Original PR description
Steps to reproduce: - Helpdesk app > Any team > : Menu > Enable 'Timesheets' setting - Timesheets app > Start timer - Set your helpdesk project and any task (Do not add a description) - Stop timer >…
Steps to reproduce: - Helpdesk app > Any team > : Menu > Enable 'Timesheets' setting - Timesheets app > Start timer - Set your helpdesk project and any task (Do not add a description) - Stop timer > Do it again with same the project and a different task - Stop timer > Time is added to previous timesheet The expected behavior would be to create a new timesheet since the task is different. The reason both timesheets are merged is that we check 'task_id' for redundance while helpdesk 'tasks' are instead recorded in the 'helpdesk_ticket_id'. Since it is forbidden for a timesheet to have both a 'task_id' and 'helpdesk_ticket_id', it is guaranteed that task_id will be False for both of our entries, leading to a merge. Similarily we can use that property since adding helpdesk_ticket_id to the domain won't change the usual behavior (the field will always be False if the project is not from Helpdesk) to add an extra condition here. Source: we have a contraint '_check_no_link_task_and_ticket' which ensures that. opw-4203678
This fix improves the default configuration for document projects by automatically setting the correct group assignment. Previously, users could easily forget to configure the proper group settings, leading to incorrect access permissions. This change reduces manual configuration errors and ensures documents are properly organized from the start.
Original PR description
It’s too easy to forget to set the right group opw-4206894 Forward-Port-Of: odoo/enterprise#70894
Fixed a system error that occurred when calculating taxes on invoices with multiple product lines using different cost centers, where the same tax applied to each line. The system now properly handles multiple tax lines for the same tax by distributing any rounding differences evenly across all affected lines, preventing calculation failures.
Original PR description
Set up Avatax environment Create an Invoice with 2 lines: - Prod A, Analytic Account A - Prod B, Analytic Account B Compute taxes Now open one of the newly added taxes On the repartition line click on the 3 dots menu, show 'Tax Closing Entry' Disable 'Tax Closing Entry' on the invoice repartition line Now go back to the invoice Compute taxes again Issue: Traceback will raise 'ValueError: Expected singleton: account.move.line(...' This occurs because, with this tax configuration, on the move we will have 2 tax lines for the same tax, as the lines needs a different analytic account and cannot be grouped together. When we compare the amount per tax we'll have a recordset and it will raise an error. A solution is to acknowledge that we might have more than 1 line and split the possible difference evenly on the tax lines opw-3976597
This fix resolves an issue where users received a CSRF error when uploading documents through the document request feature. The problem was caused by JavaScript files loading in the wrong order, preventing security tokens from being properly added. The fix reorders the file loading sequence to ensure all necessary components are available before they're needed.
Original PR description
Current behaviour: --- When you click on the "request a document" link, then upload a document, you get a CSRF error Steps to reproduce: --- 1. Install documents 2. In documents, click the arrow next to "new", then "request" 3. Add a name, and a "request to", then click "request" 4. Go to messages, copy the link in the generated email 5. Paste the link in an incognito window 6. Upload a document, CSRF error Cause of the issue: --- The js file that adds the CSRF token (documents_public_pages.js) could not be loaded due to an error caused by website_sale_renting: `TypeError: odoo.define is not a function` The mixin file was loaded before the odoo module loader. Caused by: https://github.com/odoo/enterprise/commit/93d09071a08bd5de948886729d827b1c46e907d9 Fix: --- Put js code from website_sale_renting before owl.js which is right after assets_frontend_minimal, containing module_loader.js opw-4138333
This fix resolves a problem where the real-time connection breaks when users delete and recreate a spreadsheet in different browser tabs. The system now properly checks if a spreadsheet exists before attempting to update it, preventing connection failures when working with spreadsheets.
Original PR description
Steps to reproduce: - open a first tab - create a new spreadsheet - open a second tab - from that new tab, delete the spreadsheet (send to trash, then permanently delete it from the trash) - create a new spreadsheet => update a few cells, the websocket connection is broken. Task: 4252590