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.

相关帖文	回复	查看
We need cross model pivot tables pivot Reporting pivotreport	1 7月 25	1289
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 3月 25	2299
How to get value from another model and use it in pivot table? module models pivot pivotreport	1 11月 22	4047
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 11月 21	2880
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 6月 21	3810

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！