diff options
| author | nie <nie@odoo.com> | 2020-10-19 14:21:47 +0000 |
|---|---|---|
| committer | nie <nie@odoo.com> | 2020-10-20 13:03:48 +0000 |
| commit | e7186966975c588cde21cfbf893c0e5d7c788400 (patch) | |
| tree | b29b4d9b1aa7314f9f8ac6b144d9b6740fb76d7a | |
| parent | 2766eee14341a2475bc1c33a032ea05b50becc29 (diff) | |
[FIX] sale_margin: confusing margin percentage in pivot
Steps to reproduce the bug:
- Activate Margins in Sales > Settings
- Go to the pivot view of quotations
- In Measures, click Margin (%)
Bug:
Margin percentages are aggregated by computing the sum of the margin sub-percentages instead of using the data of the aggregated row (i.e. agg. margin / agg. total).
Explanation:
This is one of the flaws of the pivot view. The best way to solve this would be to create a custom aggregation in PostgreSQL.
This commit is just hiding the measure for now.
opw:2349896
closes odoo/odoo#60297
X-original-commit: 1e3fc6894b13d51a3f6327653afbf8d5a316a21d
Signed-off-by: backspac <backspac@users.noreply.github.com>
| -rw-r--r-- | addons/sale_margin/views/sale_margin_view.xml | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/addons/sale_margin/views/sale_margin_view.xml b/addons/sale_margin/views/sale_margin_view.xml index c90dcec5a37..5c7ea8f0927 100644 --- a/addons/sale_margin/views/sale_margin_view.xml +++ b/addons/sale_margin/views/sale_margin_view.xml @@ -44,4 +44,15 @@ </field> </record> + <record model="ir.ui.view" id="sale_margin_sale_order_pivot"> + <field name="name">sale.order.margin.view.pivot</field> + <field name="model">sale.order</field> + <field name="inherit_id" ref="sale.view_sale_order_pivot"/> + <field name="arch" type="xml"> + <pivot position="inside"> + <field name="margin_percent" invisible="1"/> + </pivot> + </field> + </record> + </odoo> |