CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I need to sum the amount_tax in a report just like it shows in the account_invoice tree view or sales_order view as a total in my invoice report, i don't want lines in my invoice. please help its seriously very urgent!
Aeroo has got a funtion called sum_field that sum all the value for a field in yuor class.
This is an example that sum all amount_total in sale order
This is a link to official documentation: http://www.alistek.com/wiki/index.php/Extra_Functions_-_sum
Above suggested answer is right. It uses report_aeroo functionality if you want to achieve it with base_report_designer using sxw & report.py file then you need to follow below steps.
Define a global variable & do the calculation for sum in it in report.py file. Then at the end of the report in .sxw file call a function and return that global variable. This is how you can have sum amount in your report at the end. For more in detail you can refer Location Content report of Stock.
Here are some examples,
For version 6.0
For version 7.0
Hope this solve your problem.
About This Community
Odoo Training Center
|Asked: 5/16/13, 7:51 AM|
|Seen: 8037 times|
|Last updated: 3/16/15, 8:10 AM|