Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilidad
Inventario
PoS
Proyectos
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

Invoice Report Multiple Journal Line Print Error

print report odooV8

3 Respuestas

4577 Vistas

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

Mejor respuesta

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

Autor

Thank you @Dhaval you answer was super fine.

Now works fine!

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Registrarse

Publicaciones relacionadas	Respuestas	Vistas
Multiple report on one button click qweb print report odooV8	6 ene 20	8931
Is it possible to make a text-only report? print reporting report odooV8	0 nov 15	3863
file field in the <report /> xml file report odooV8	2 ago 17	10102
how to check if report has been printed print report	1 nov 16	5338
Print report of another related model report odooV8	1 ago 16	8498

Se marcó esta pregunta

Here is my modified report section:

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

Thank you very much

¿Le interesa esta conversación? ¡Participe en ella!