bu pick in purchase order sales match

1 files changed, 14 insertions, 0 deletions

diff --git a/indoteknik_custom/models/purchase_order_sales_match.py b/indoteknik_custom/models/purchase_order_sales_match.py
index 0bd0092b..2ea89dab 100644
--- a/indoteknik_custom/models/purchase_order_sales_match.py
+++ b/indoteknik_custom/models/purchase_order_sales_match.py
@@ -28,6 +28,20 @@ class PurchaseOrderSalesMatch(models.Model):
     purchase_price_po = fields.Float('Purchase Price PO', compute='_compute_purchase_price_po')
     purchase_line_id = fields.Many2one('purchase.order.line', string='Purchase Line', compute='_compute_purchase_line_id')
     hold_outgoing_so = fields.Boolean(string='Hold Outgoing SO', related='sale_id.hold_outgoing')
+    bu_pick = fields.Many2one('stock.picking', string='BU Pick', compute='compute_bu_pick')
+
+    def compute_bu_pick(self):
+        for rec in self:
+            stock_move = self.env['stock.move'].search([
+                ('reference', 'ilike', 'BU/PICK'),
+                ('state', 'in', ['confirmed','waiting','partially_available']),
+                ('product_id', '=', rec.product_id.id),
+                ('sale_line_id', '=', rec.sale_line_id.id),
+            ])
+            if stock_move:
+                rec.bu_pick = stock_move.picking_id.id
+            else:
+                rec.bu_pick = ''
 
     def _compute_purchase_line_id(self):
         for line in self: