diff options
| author | Arnold Moyaux <arm@odoo.com> | 2019-04-11 15:05:53 +0000 |
|---|---|---|
| committer | Arnold Moyaux <arm@odoo.com> | 2019-04-11 15:43:21 +0000 |
| commit | e5b19bd5aa47fdb2da547cb75de9d33a20e1e180 (patch) | |
| tree | c0aba36486e3f1893f60d01f30072dce99985d3b /addons | |
| parent | 8c642167e9bb826d89b8a53f93a8c1fb2e8cfd4a (diff) | |
[FIX] stock: force group by date when ordered by date
When displaying forecasted inventory if there is no default order,
the default order forced on date and id. In that case, if the date is
not in the "group by", it causes warning.
With this commit, the date is forced in the SQL view.
closes odoo/odoo#32633
Signed-off-by: Raphael Collet (rco) <rco@openerp.com>
Diffstat (limited to 'addons')
| -rw-r--r-- | addons/stock/report/report_stock_forecast.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/addons/stock/report/report_stock_forecast.py b/addons/stock/report/report_stock_forecast.py index 59e788ac4b6..1bf69ab5719 100644 --- a/addons/stock/report/report_stock_forecast.py +++ b/addons/stock/report/report_stock_forecast.py @@ -129,6 +129,8 @@ class ReportStockForecat(models.Model): WHERE final.product_qty != 0 OR final.reference = 'Starting Inventory' %s + ORDER BY + date ) """ % (self._select(), self._left_join(), self._groupby()) self.env.cr.execute(query) @@ -185,7 +187,6 @@ class ReportStockForecat(models.Model): order to analyze different quantities in different situations. """ # Sort result by date_expected and id. - orderby = 'date, id' if not orderby else orderby if 'cumulative_quantity' in fields and 'quantity' not in fields: fields.append('quantity') res = super(ReportStockForecat, self).read_group(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy) |