get list of invoices that were created from a sale order.

Question

Good day everyone,
I'm trying to get a list of the related invoices that were create from a sale order.  I noticed this field invoice_ids it seems like an array style where each invoice is stored , but I can't figure the way to extract from there the invoice numbers and store it in a separate char field.

Thanks in advance,

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
The field ‘invoice_ids’ of model ‘sale.order’ represents the ‘account.move’ model records of the corresponding sales order. You can access the invoice number of each invoice using the ‘name’ field of each invoice_ids inside a for loop, in order to avoid singleton error and store inside the required char field.
Regards

Avash · Answer

Thanks Cybrosy.

Related Posts	Replies	Views
Odoo14: Sales order reference to invoice line when multiple SO invoices sale.order references	0 Oct 21	1449
Sale order Balance sale.order	2 Nov 24	477
Invoice Wishlist percentage invoices	0 Feb 24	218
Mark a sales order as fully invoiced despite Order amount and invoiced amount do not match () Solved sale.order	4 Feb 24	10166
How to add invoice payment date and tax number in invoice tree view? invoices	5 Jan 24	4869

This question has been flagged

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