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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/16/13, 7:51 AM|
|Seen: 6603 times|
|Last updated: 3/16/15, 8:10 AM|