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
| 相關帖文 | 回覆 | 瀏覽次數 | 活動 | |
|---|---|---|---|---|
|
2
3月 21
|
6759 | ||
|
2
1月 16
|
6495 | ||
|
1
10月 22
|
2748 | ||
|
|
1
2月 22
|
2954 | ||
|
1
8月 24
|
11872 |
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.