Skip to Content
This question has been flagged
qwebreportingaccount.invoice
1 Respondre
5032 Vistes
Avatar
Lindari Solutions

I am creating a report that is based on the sale.order model, I want to show whether or not the order has been paid which is in the account.invoice model. The link between them is docs.invoice_ids = account_invoice.number, is there a way to pull this information into my report?

<t t-if="docs.invoice_ids == account_invoice.number and account_invoice.state != 'Paid'">
    <b>****ORDER UNPAID****</b>
</t>
<t t-else="">
    ****ORDER PAID****
</t>

Avatar
Descartar
Avatar
Lindari Solutions
Autor Best Answer

I worked it out.. :)

<t t-if="docs.invoice_ids.state != 'paid'">
<b>****ORDER UNPAID****</b>
</t>
<t t-else="">
****ORDER <span style="text-transform: uppercase" t-esc="docs.invoice_ids.state"/>****
</t>

Avatar
Descartar
Niyas Raphy (Walnut Software Solutions)

It will work fine as long as there is only single invoice for the sale order. You will get error message if there is multiple invoice for the sale order

Related Posts Respostes Vistes Activitat
How can I display all tasks (including completed ones) in a QWeb report in Odoo?
qweb reporting
Avatar
Avatar
2
de set. 24
2627
How do i create report in Qweb? Solved
qweb reporting
Avatar
Avatar
Avatar
Avatar
Avatar
5
d’ag. 19
47109
How to update default header in PDF report (qWeb)? Solved
qweb reporting
Avatar
Avatar
Avatar
Avatar
Avatar
4
de juny 18
20759
Odoo 11 CE: "background" document template will generate extra page
qweb reporting
Avatar
0
de juny 18
3774
What is QWeb (Odoo's reporting engine)? Solved
qweb reporting
Avatar
Avatar
2
de maig 16
17816