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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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.
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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
0
Jun 24
|
387 | ||
|
0
Sep 23
|
1064 | ||
|
1
Nov 22
|
2727 | ||
|
0
Nov 21
|
2099 | ||
|
0
Jun 21
|
2980 |