Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
We need some data in the stock.picking module. The base document Sales Order can get the SO Number, but we also need some data coming from stock.picking.
I saw this question but no answer yet. https://www.odoo.com/forum/invoicing-5/accessing-stock-picking-from-invoice-184557
Hi,
Already we have a link between sale.order.lines to account.invoice.lines. We can create a Many2one computed field on invoice. Then we get all related sale orders.
sale_order_id = fields.Many2one('sale.order', compute='_compute_sale_order', store=True)@api.depends('invoice_line_ids.sale_line_ids.order_id')
def _compute_sale_order(self):
for rec in self:
rec.sale_order_id = rec.mapped('invoice_line_ids.sale_line_ids.order_id')Inside the sale.order model we have picking_ids. So we get those pickings by sale_order_id.picking_ids.
Regards
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Mar 21
|
6706 | ||
|
2
Jan 16
|
6461 | ||
|
1
Oct 22
|
2722 | ||
|
|
1
Feb 22
|
2921 | ||
|
1
Aug 24
|
11787 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Do you want data from invoice on stock.picking or do you want data in sale order from stock.picking? Please clarify your question.
Oh sorry for confusion. From invoice we need some data coming in stock.picking.