Script SQL Autocorreccion de Margenes

Corrección de Margenes Negativos o erróneos a partir de SQL

update sale_order set margin = amount_untaxed-(select sum(sol.purchase_price*sol.product_uos_qty) 
   from sale_order_line as sol join sale_order as so on so.id = sol.order_id and so.id=sale_order.id)