Friday, September 18, 2026
2 changes · saas-19.4
Enhancements to existing features
Stock availability searches now run much faster when filtering products by free quantity, especially in large inventories. This reduces wait times and database load for users working with product and stock lists.
Original PR description
**Problem:** Searching on free_qty can be slow when there are many stock.move and stock.quant. The search method uses _compute_quantities_dict() to compute the free_qty based on stock.move and…
**Problem:** Searching on free_qty can be slow when there are many stock.move and stock.quant. The search method uses _compute_quantities_dict() to compute the free_qty based on stock.move and stock.quant, which is expensive. **Solution:** A similar field, qty_available, has a faster search method based on stock.quant only. This method can be adapted to support fast searching on free_qty by also aggregating the reserved_qty and subtracting it from the qty_available. **Perf Table:** Record: product.template, with ~20k stock.picking and most products w/o moves. |Record count|Time before|Queries before|Time after|Queries after| |------------|-----------|--------------|----------|-------------| |10k |2.14s |214 |370ms |45 | |50k |6.06s |644 |829ms |50 | |100k |11.42s |1196 |1.05s |46 | opw-6266096 Forward-Port-Of: odoo/odoo#287363 Forward-Port-Of: odoo/odoo#270434
Customers with unpaid invoices can now still add money to their account at the point of sale. This makes account deposits more flexible and avoids forcing customers to settle existing balances before adding funds.
Original PR description
"Deposit money" was only offered in the partner list when the customer had no due, so a customer with open invoices could not put money on their account without settling those invoices. Always offer it when a customer account payment method exists. opw-6514079 Forward-Port-Of: odoo/enterprise#131268