All Posts People Badges

टैग (View all)

About this forum

सहायता

Invoice Report Multiple Journal Line Print Error

print report odooV8

3 Replies

5362 डेटा देखने का तरीका

Patrizio Tafaro

Hello,

I'm running Odoo 8.

I tried to modify the invoice report to print move_lines.journal_id.name.

I have some invoices with multiples lines and i get an error:

Error:

File "/opt/odoo/odoo8/openerp/models.py", line 5320, in ensure_one
    raise except_orm("ValueError", "Expected singleton: %s" % self)
QWebException: "ValueError
Expected singleton: account.move.line(301, 299)" while evaluating
"translate_doc(doc_id, doc_model, 'partner_id.lang', 'account.report_invoice_document')"

Here is my modified report section:

<span t-if="o.move_lines.journal_id.name">
                    <strong>Payment method:</strong>
<t t-foreach="o.move_lines.journal_id" t-as="l">
<span t-field="l.name"/></t>
                    <br/>
                </span>

Any one can help me figure out why is not working?

Thank you very much

Dhaval Desai

Best Answer

Hello @ Patrizio Tafaro,

Your code:

wrong: <span t-if="o.move_lines.journal_id.name">
<strong>Payment method:</strong>
<t t-foreach="o.move_lines.journal_id" t-as="l">
<span t-field="l.name"/></t>
<br/>
</span>

Note: "move_lines" returns multiple records, you can not directly used in Report template. it is wrong so error face in system while print report.

"Expected singleton: account.move.line(301, 299)"

Solution:
<t t-foreach="o.move_lines" t-as="line">
    <span t-if="line.journal_id.name"/>
        <strong>Payment method:</strong>
        <span t-field="line.name"/>
</t>
Thank You.

Cybrosys Techno Solutions Pvt.Ltd

Hi,

Try with this code,

<t t-foreach="o.move_lines" t-as="ml">
    <span t-if="ml.journal_id.name"/>
    <strong>Payment method:</strong>
    <span t-field="l.name"/>
</t>

Thanks

Patrizio Tafaro

लेखक

Thank you @Dhaval you answer was super fine.

Now works fine!

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

साइन अप करें

Related Posts	Replies	डेटा देखने का तरीका
Multiple report on one button click qweb print report odooV8	6 जन॰ 20	9965
Is it possible to make a text-only report? print reporting report odooV8	0 नव॰ 15	4917
file field in the <report /> xml file report odooV8	2 अग॰ 17	11537
how to check if report has been printed print report	1 नव॰ 16	6495
Print report of another related model Solved report odooV8	1 मई 26	9496

This question has been flagged

Here is my modified report section:

Any one can help me figure out why is not working?

Thank you very much

Enjoying the discussion? Don't just read, join in!