Tuesday, September 23, 2025
2 changes · 18.0
New functionality added to Odoo
Odoo spreadsheets can now calculate account residual amounts for selected periods and partner balances directly with new formulas. This helps finance teams build more complete reports without manual exports, while related performance improvements make accounting spreadsheet calculations faster and more predictable.
Original PR description
Problem --------- There is currently no formula to get the residual amount of accounts in a given period of time in spreadsheets. Similarly, there is no formula to get the balance of a partner. Objective --------- Add the formula ODOO.RESIDUAL and ODOO.PARTNER.BALANCE that does just that. Furthermore, this PR contains a refactor of the addons/spreadsheet_account/models/account.py for easier management and faster computation of the functions. Check the relevant commits for more details. --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Resolved issues and error corrections
This fix prevents key details on confirmed and locked sales orders from being changed in another browser window. It helps avoid data corruption when multiple users or tabs interact with the same order at the same time.
Original PR description
Add _get_protected_fields() method and protection logic to prevent modification of critical fields when sale order is locked, matching the existing protection in sale.order.line. Problem Critical…
Add _get_protected_fields() method and protection logic to prevent modification of critical fields when sale order is locked, matching the existing protection in sale.order.line. Problem Critical vulnerability where multiple users could simultaneously edit the same sale order, causing data corruption when an order was confirmed (and locked) in one window while still being edited in another. Specific scenario: Sale order opened in 2 windows/tabs simultaneously User A confirms the order → automatically locked ([locked=True](vscode-file://vscode-app/Applications/Visual%20Studio%20Code.app/Contents/Resources/app/out/vs/code/electron-browser/workbench/workbench.html)) User B can still modify [partner_id](vscode-file://vscode-app/Applications/Visual%20Studio%20Code.app/Contents/Resources/app/out/vs/code/electron-browser/workbench/workbench.html) from the other window Result: Corrupted data in confirmed order --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr