I am creating report i need to calculate sum of all quantity in sale order line how to do that
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2
Replies
9473
Views
[[ reduce(lambda x, obj: x+obj.qty , list , 0 ) ]] : Total qty of list (try "objects" as list)
source: https://doc.openerp.com/v6.1/developer/05_reports/
o.order_line would be for the list of sale order lines
product_uom_qty is the qty field in sale order lines so it would be
[[ reduce(lambda x, obj: x+obj.product_uom_qty, o.order_line, 0 ) ]]
Ohh !! Thanks its work perfectly..
plz be sure to mark it as correct answer ^^
Hi,
In this case you have create function field in report py file and in that just calculate # of qty. And for field use that function in rml file.