How can I create a field that show info acording to a sales order / bill status?

Question

Hello Odoo community.
I have been asked to create a field that displays the date of the last purchase that the customer has made. There are pre-existing related fields that allow me to do that but the invoice model is for both invoices and sales so the date displayed even includes quotations.
I don't have much knowledge in Python but somehow I manage to intuit the scope of its logic. I know that it is possible to create a field that displays the date of the invoices according to their status: pa

Lucas · Answer

Where are you trying to show the field?
You want to show the date of the latest purchase. This could mean one of several things:
- The date that the most recent sales order was confirmed
- The date of the last invoice
- The date of the last payment

I'll assume that you mean the date of the last invoice.
Therefore, the field you are looking for is: self.invoice_ids.date [1]

If you have Odoo Studio you can add this by adding a 'Related Field' to the list view with the path Self > Invoices > Date

Related Posts	Odgovori	Prikazi
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 feb. 25	3332
Orden de venta borrada por error sales.order	1 dec. 24	2844
How to create a subsection in the product order line and make the main section sum the total of the subsections in Odoo? Solved sales.order	2 mar. 24	3232
Managing orders from repeat customers Solved sales.order	2 mar. 24	3794
Sales order from customer order. sales.order	0 sep. 23	2166

This question has been flagged

Enjoying the discussion? Don't just read, join in!