Daily updates from Odoo
Wednesday, April 10, 2024
7 changes
1 change
Enhancements to existing features
Accounting integrity checks now process records in smaller batches instead of loading an entire journal at once. This reduces memory usage and helps large accounting databases complete verification more reliably without changing day-to-day workflows.
Original PR description
Loading in memory all the moves of a journal may be too much. For this reason, we will now optimize the verification of the integrity with batches of 1000 records. task-id 3857188
2 changes
Enhancements to existing features
Financial report formulas will no longer silently turn division-by-zero results into zero by default, reducing the risk of misleading figures. Existing reports that intentionally used the old behavior were updated to preserve their results, while future report formulas must explicitly choose this fallback when needed.
Original PR description
In an aggregation, when a 0-division happens in a formula, the result of the formula will be set to 0. This way of handling 0-division is counter-intuitive and could potentially create errors in the reports. This commit takes the default 0-division safety off, which forces the dev to think about- and fix these issues. To enable the safety, a developer can enter 'ignore_zero_division' as a subformula on an aggregation. The 'ignore_zero_division' subformula was added to existing reports and testcases to stay consistent with earlier versions. task: 3774403
Aging reports can now use user-defined time intervals instead of being limited to fixed 30-day periods. This gives businesses more flexibility in reviewing overdue receivables and payables, while preventing invalid interval values below one.
Original PR description
This improvement expands the functionality of the ageing reports by introducing a customizable aging report based on aging intervals. Previously, the aging intervals were fixed at 30 days, but with this PR, users can now input intervals greater than one, Also for intervals less than one an error is thrown. Task-3669642
4 changes
Enhancements to existing features
The Luxembourg payroll tax brackets have been updated to reflect the official changes effective January 1, 2024. This ensures that employee tax calculations are accurate and compliant with the latest Luxembourg tax regulations.
Original PR description
The tax brackets have been updated since 01-01-2024 https://impotsdirects.public.lu/dam-assets/fr/baremes/baremes-impot-20240101-fr.pdf https://impotsdirects.public.lu/fr/baremes.html#Ex Add new parameter values to reflect the change. task-3748852
Database indexes have been added to the quality check system to speed up the Shop Floor App when it opens. This optimization reduces loading time and improves the overall user experience when quality management features are enabled in manufacturing operations.
Original PR description
Add missing indexes on quality_check. This speeds up search_read on mrp.production when the quality/quality_mrp modules are installed. It's mostly useful at the opening of the Shop Floor App to turn Seq Scans into Index Scans. COM PR: https://github.com/odoo/odoo/pull/160349
Database indexes have been added to the Manufacturing module to speed up the Shop Floor app when it loads production data. This optimization reduces the time needed to retrieve manufacturing orders and work orders, resulting in a faster user experience when opening the Shop Floor application.
Original PR description
Add missing indexes on stock.move and mrp.workorder to speed up search_read on mrp.production. That's mostly useful at the opening of the Shop Floor app. This turns Seq scans into Index scan, leading to an overall speedup. ENT PR: https://github.com/odoo/enterprise/pull/59998 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Database indexes have been added to improve the speed of analytic line queries, particularly during sales order creation. This optimization reduces database load and improves system responsiveness by making frequently-used searches more efficient.
Original PR description
## Description Add indexes affecting queries related to `account.analytic.line`. Based on heuristics like domains in `search`/`read_group` that are not really selective, or being an inverse of One2many. Some of these searches are on code-paths that are frequent, like creation of an SO. The goal is to reduce the number of Seq.Scan or non-selective Index Scan. ## Reference task-3724844 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr