set_partner_move.sql

WITH partner_move AS (
  SELECT 
    p.partner_id, 
    m.id 
  FROM 
    stock_move AS m 
  INNER JOIN 
    purchase_order_line AS pl ON pl.id=m.purchase_line_id 
  INNER JOIN 
    purchase_order AS p ON p.id=pl.order_id 
  WHERE 
    m.purchase_line_id IS NOT NULL AND 
    m.partner_id IS NULL) 
UPDATE 
  stock_move AS m 
SET 
  partner_id=pm.partner_id 
FROM 
  partner_move AS pm 
WHERE 
  m.id=pm.id;