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
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
2
mar 21
|
6855 | ||
|
2
gen 16
|
6586 | ||
|
1
ott 22
|
2840 | ||
|
|
1
feb 22
|
3040 | ||
|
1
ago 24
|
11973 |
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.