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>