Odoo Changelog — 2025-11-24

Monday, November 24, 2025

2 changes · 18.0

Improvements(2)

Enhancements to existing features

[IMP] l10n_co_{dian, edi}: Generate correct XML for plastic bags tax

Enterprise18.0l10n_co_dianl10n_co_ediHigh impact

Colombian e-invoices now handle the plastic bags tax correctly, generating the required XML structure for DIAN. This helps prevent validation errors and allows invoices that include this tax to be submitted successfully.

Original PR description

Before PR:
-The plastic bags tax (INC Bolsas) was not handled by a specific flow. 
-This resulted in incorrect XML generation for Colombian e-invoices, leading to
 validation errors from the DIAN.

After PR:
-Dedicated logic flow has been added to correctly handle the INC Bolsas tax. 
-Generated XML now correctly reports this tax in a separate `TaxTotal` block. 
-It populates the `BaseUnitMeasure` and `PerUnitAmount` fields with the fixed
 tax rate per bag.

Impact:
-Colombian e-invoices that include plastic bags tax are now generated correctly. 
-Ensures compliance with DIAN's specific requirements for this nominal tax. 
-Prevents validation errors and allows for successful submission of invoices
 containing this tax.

task-5086926

#colombia#dian#e-invoicing#tax#xml

[PERF] account_reports: fast path for account_id domains

PR #100365

Enterprise18.0account_reportsHigh impact

Financial reports now run much faster by reusing precomputed balance data instead of recalculating the same information many times. This reduces wait times significantly for large reports while keeping the results unchanged.

Original PR description

### Issue Large financial reports are slow to compute due to repeated re-aggregation of account_move_line balances for each formula, even when most formulas share the same base domain (usually…

### Issue

Large financial reports are slow to compute due to repeated re-aggregation of account_move_line balances for each formula, even when most formulas share the same base domain (usually filtered by account_id fields).

### Analysis

Each report line formula independently aggregates balances from account_move_line, even when their domains only differ on account_id-related fields such as account_id.account_type or account_id.non_trade.
This leads to redundant scanning and aggregation of the same dataset multiple times within a single report execution.

### Solution

Introduce a lightweight in-memory caching layer for aggregated balances by account_id, stored in self.env.cr.cache.

For each (options, date_scope) pair:
The report engine now computes once the mapping
{account_id: {'amt': total_balance, 'count_aml_lines': count}}.
This mapping is stored in the cursor cache and reused across all formulas whose domains filter exclusively on account_id fields.
A small domain transformation step allows AML domains based on account_id.* fields to be evaluated directly against the cached account aggregates.
This approach avoids redundant SQL aggregation, remains fully read-only (no database writes), and is safe for execution on read replicas.

### Benchmarks

Profiling get_report_information_readonly on different reports. Database has ~11.6 million account_move_lines, 305 account_accounts, and 16 account_types

| Report Name | Before | After | % Speed Up |
| --- |---|---|---|
| Balance Sheet | 35s | 6.2s | ~550% |
| Profit and Loss | 7.2 | 2.1 | ~300% |
| Cash Flow Statement | 1.5s | 0.4s | ~300% |
| Executive Summary | 24s | 6.3 | ~400% |

### References

opw-5130725

Before PR: -The plastic bags tax (INC Bolsas) was not handled by a specific flow. -This resulted in incorrect XML generation for Colombian e-invoices, leading to validation errors from the DIAN. After PR: -Dedicated logic flow has been added to correctly handle the INC Bolsas tax. -Generated XML now correctly reports this tax in a separate `TaxTotal` block. -It populates the `BaseUnitMeasure` and `PerUnitAmount` fields with the fixed tax rate per bag. Impact: -Colombian e-invoices that include plastic bags tax are now generated correctly. -Ensures compliance with DIAN's specific requirements for this nominal tax. -Prevents validation errors and allows for successful submission of invoices containing this tax. task-5086926

### Issue Large financial reports are slow to compute due to repeated re-aggregation of account_move_line balances for each formula, even when most formulas share the same base domain (usually filtered by account_id fields). ### Analysis Each report line formula independently aggregates balances from account_move_line, even when their domains only differ on account_id-related fields such as account_id.account_type or account_id.non_trade. This leads to redundant scanning and aggregation of the same dataset multiple times within a single report execution. ### Solution Introduce a lightweight in-memory caching layer for aggregated balances by account_id, stored in self.env.cr.cache. For each (options, date_scope) pair: The report engine now computes once the mapping {account_id: {'amt': total_balance, 'count_aml_lines': count}}. This mapping is stored in the cursor cache and reused across all formulas whose domains filter exclusively on account_id fields. A small domain transformation step allows AML domains based on account_id.* fields to be evaluated directly against the cached account aggregates. This approach avoids redundant SQL aggregation, remains fully read-only (no database writes), and is safe for execution on read replicas. ### Benchmarks Profiling get_report_information_readonly on different reports. Database has ~11.6 million account_move_lines, 305 account_accounts, and 16 account_types | Report Name | Before | After | % Speed Up | | --- |---|---|---| | Balance Sheet | 35s | 6.2s | ~550% | | Profit and Loss | 7.2 | 2.1 | ~300% | | Cash Flow Statement | 1.5s | 0.4s | ~300% | | Executive Summary | 24s | 6.3 | ~400% | ### References opw-5130725