q.sql

	select sum(product_qty) filter (spt.code = 'incoming') as incoming, product_id, sloc.name, sm.location_id, picking_type_id, spt.code 
	from stock_move sm 
	inner join stock_picking_type spt on sm.picking_type_id = spt.id 
	left join stock_location sloc on sm.location_id = sloc.id
	left join stock_location slocd on sm.location_dest_id = slocd.id
	where sm.state = 'done'
	and inventory_id is null
	group by product_id, sloc.name, sm.location_id, picking_type_id, spt.code;