Skip to Content
Menu
This question has been flagged
1 Atsakyti
5012 Rodiniai

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>

Portretas
Atmesti
Autorius 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>

Portretas
Atmesti

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 Replies Rodiniai Veikla
2
rugs. 24
2597
5
rugp. 19
47089
4
birž. 18
20732
0
birž. 18
3742
2
geg. 16
17775