Hello,

Odoo is referencing the sales order for a reference in every invoice.

In our use case we bill the customer by deliverd items.
So we want to reference the delivery slip in the invoice.

I already tried several solutions in Odoo Studio but failed with a rendering error or not the wanted result.

Attempts so far:

<t t-out="max(env['stock.picking'].search([('origin', '=', object.invoice_origin)]), key=lambda p: p.scheduled_date).name if object.invoice_origin else 'No delivery slip found'"/>

<t t-out="object.invoice_origin and object.invoice_origin[0].picking_ids and object.invoice_origin[0].picking_ids[0].name or 'No delivery slip found'"/>

But also broken down it is not working  o.sale_id.picking_ids[0].name

Thanks in advance and best Regards