Odoo Help


in report rml,mistak output?

on 1/30/16, 1:06 AM 373 views


 def _function(self, fromDate, toDate):

        sql = "select round(sum(aml.credit) - sum(aml.debit)) \

        from account_move_line as aml \

        join account_account as aa on aml.account_id=aa.id and aa.user_type=8 \

        where aml.date BETWEEN \'%s\' AND \'%s\'" %(fromDate, toDate)


        return self.cr.fetchall()


     <blockTable colWidths="186.0,94.0" style="Table12">



                <para style="P12">[[ repeatIn(function(data['form']['fromDate'], data['form']['toDate']),'p') ]]</para>

                <para style="P13">[[p[0] ]]</para>




output:   ( 1.28676738711e+11 )

why output???????????

Your Answer

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

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/30/16, 1:06 AM
Seen: 373 times
Last updated: 1/30/16, 2:21 AM