Odoo Help


i want to get al invoice record with invoice line

on 10/20/15, 5:53 AM 709 views

hi in account module i want to get all invoice record with invoice line and customer wise filter

i create one parser file parser.py

in which following function is used

def invoices(self):


"SELECT * FROM account_move_line l ")

res = self.cr.dictfetchall()

return res

after i access in report.xml file


<t t-foreach="invoices()" t-as="i">



<span t-esc="i['ref']"/>



<span t-esc="i['id']"/>



<span t-esc="i['date_created']"/>



<span t-esc="i['name']"/>



<span t-esc="i['partner_id']"/>



<span t-esc="i['credit']"/>




but it will nit return information properly

how can i get all invoice with invoice line in report.xml

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: 10/20/15, 5:53 AM
Seen: 709 times
Last updated: 10/20/15, 5:53 AM