Thursday, November 23, 2023
5 changes · 17.0
Enhancements to existing features
The expression editor now makes it easier to choose fields by showing them in a searchable, familiar selector with clearer debug information. It also correctly supports the “between” operator, reducing errors when users build conditions or formulas.
The point of sale product list no longer shows the special discount product used behind the scenes. This keeps the sales screen cleaner and helps staff focus on real sellable products, while still allowing demo products to be loaded if no other products are available.
Original PR description
…sale This commit prevent the discount product to be shown in the frontend of the PoS and abling him to download demo data on the flight if he does not have other products available. --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Return slips now show the two barcodes with extra spacing between them. This reduces the chance of scanning the wrong barcode during warehouse return processing.
Original PR description
Description of the issue/feature this PR addresses: On the return slip, the 2 barcodes are too close to each other. So, it's too easy to scan the wrong barcode. We should add a bit more space between the 2 barcodes (For the demo, I had to take another document for managing the scanning) 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 improvement eliminates an unnecessary confirmation dialog when opening quality check worksheets on work orders. Previously, users would see an empty dialog with a "Fill Worksheet" button; now the worksheet form opens directly, reducing clicks and improving the user experience during manufacturing quality checks.
Original PR description
Before this commit, if there was no instructions on the workorder an empty confirmation dialog opens to show the button "Fill Worksheet". After this commit, the dialog is not shown and the worksheet form is opened directly.
This update significantly speeds up the Budget Analysis report, which was running very slowly for companies with large amounts of budget data. The fix reduces loading time from 40-70 seconds down to 3-4 seconds by optimizing how the system processes budget calculations, making the report practical to use even with thousands of budget lines.
Original PR description
## Description The pivot view of the budget analysis can be really slow for large database with lots of `crossovered.budget.lines`. This issue is also present if one exports the view to the Dashboard…
## Description The pivot view of the budget analysis can be really slow for large database with lots of `crossovered.budget.lines`. This issue is also present if one exports the view to the Dashboard app. ## Analysis The pivot view will request multiple `read_group`, computing the sum of `practical_amount`, triggering it's compute. Said compute loops over all lines, making a separate SQL query for each. In the context of having a large amount lines, the inherent cost of running a query (serialization/deserialization, network transfer) can accumulate to some non-negligible amount. ## Fix Group by the lines on their date-range and account_id. In the case of line that has an `account.analytic.line` associated with it, we also make sure that if a `general_budget_id` is present on the `crossovered.budget.lines`, then the accounts of the budget should match those of the analytic line. ## Benchmark Database on 16.0, 17k `crossovered.budget.lines`, 18k `account.analytic.line`, 31k `account.move.line`. Loading the Budget Analysis pivot view (lines have an analytic account on them) | | Before | After | |-------------|----------|----------| | Timing | 40 secs | 3.1 secs | | Query count | 39k | 150 | Loading the Budget Analysis pivot view (lines have *no* analytic account on them) | | Before | After | |-------------|---------|--------| | Timing | 70 secs | 4 secs | | Query count | 35k | 130 | ## Reference opw-3535910 opw-3573566 Forward-Port-Of: odoo/enterprise#51282 Forward-Port-Of: odoo/enterprise#49871