diff options
| author | Simon Lejeune <sle@openerp.com> | 2020-03-19 09:15:30 +0000 |
|---|---|---|
| committer | Simon Lejeune <sle@openerp.com> | 2020-03-19 10:56:36 +0000 |
| commit | d0fc2ecfaa56e10ae339cbb9c6ec0a4045f3d499 (patch) | |
| tree | 930e7672f2f6e7cff2fe2d6c74db32f429cb3b6a | |
| parent | 5b7cff06f75728103acec4d811c838a1b2d735c7 (diff) | |
[FIX] stock: unlink zero quants
If you create a quant through the inventory mode of the list view and
you don't set a quantity, the quantity is null and the quant isn't
unlinked by _unlink_zero_quants.
Also consider null quantity as 0.
We don't have the issue for the reserved_quantity field since this one
is not nullable.
closes odoo/odoo#48005
X-original-commit: 08e428458aa545b3602c56b6866a447126cf8825
Signed-off-by: Simon Lejeune (sle) <sle@openerp.com>
| -rw-r--r-- | addons/stock/models/stock_quant.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/stock/models/stock_quant.py b/addons/stock/models/stock_quant.py index f819e85ad84..ed914734021 100644 --- a/addons/stock/models/stock_quant.py +++ b/addons/stock/models/stock_quant.py @@ -507,7 +507,7 @@ class StockQuant(models.Model): """ precision_digits = max(6, self.sudo().env.ref('product.decimal_product_uom').digits * 2) # Use a select instead of ORM search for UoM robustness. - query = """SELECT id FROM stock_quant WHERE round(quantity::numeric, %s) = 0 AND round(reserved_quantity::numeric, %s) = 0;""" + query = """SELECT id FROM stock_quant WHERE (round(quantity::numeric, %s) = 0 OR quantity IS NULL) AND round(reserved_quantity::numeric, %s) = 0;""" params = (precision_digits, precision_digits) self.env.cr.execute(query, params) quant_ids = self.env['stock.quant'].browse([quant['id'] for quant in self.env.cr.dictfetchall()]) |