Pivot report in sale order

Question

Hello Dear can anyone let me know why we use l in below code what it is mean also what is meant of factor and why we use it please explain below query
sum (l.product_uom_qty / u.factor * u2.factor) as product_uom_qty FROM    sale_order_line    ​

Nizar Muhammed · Answer

User can select the required unit of measure(UOM) while selling or purchasing a product. While the user selects  a UOM which is different from the default UOM of that product. The above code is used to convert the selected UOM quantity to default UOM quantity.

Paresh Wagh · Answer

This is for converting the value of quantity from the UoM specified on the Sale Order Line to the main UoM specified on the Product template.

Gerelateerde posts	Antwoorden	Weergaven
We need cross model pivot tables pivot Reporting pivotreport	1 jul. 25	3342
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 mrt. 25	4476
How to get value from another model and use it in pivot table? module models pivot pivotreport	1 nov. 22	6121
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 nov. 21	4382
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 jun. 21	5694

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!