Invoice Report Multiple Journal Line Print 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

Author

Thank you @Dhaval you answer was super fine.

Now works fine!

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