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
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
How to get Invoice Payment amount - Custom Report
Diselesaikan
|
|
2
Mar 21
|
6878 | |
|
2
Jan 16
|
6594 | ||
|
1
Okt 22
|
2868 | ||
|
|
1
Feb 22
|
3054 | ||
|
1
Agu 24
|
11994 |
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.