the qty_available is computing by executing directly an sql query.
so the multi company filtering is not available
see the code bellow
if 'in' in what:
# all moves from a location out of the set to a location in the set cr.execute( 'select sum(product_qty), product_id, product_uom '\ 'from stock_move '\ 'where location_id NOT IN %s '\ 'and location_dest_id IN %s '\ 'and product_id IN %s '\
'' + (prodlot_id and ('and prodlot_id = ' + str(prodlot_id)) or '') + ' '\ 'and state IN %s ' + (date_str and 'and '+date_str+' ' or '') +' '\ 'group by product_id,product_uom',tuple(where))
results = cr.fetchall()
if 'out' in what:
# all moves from a location in the set to a location out of the set cr.execute( 'select sum(product_qty), product_id, product_uom '\ 'from stock_move '\ 'where location_id IN %s '\ 'and location_dest_id NOT IN %s '\ 'and product_id IN %s '\
'' + (prodlot_id and ('and prodlot_id = ' + str(prodlot_id)) or '') + ' '\ 'and state in %s ' + (date_str and 'and '+date_str+' ' or '') + ' '\ 'group by product_id,product_uom',tuple(where)) results2 = cr.fetchall()
the qty_available is computing by executing directly an sql query.
so the multi company filtering is not available
see the code bellow
if 'in' in what:
cr. execute(
'select sum(product_qty), product_id, product_uom '\
'from stock_move '\
'where location_id NOT IN %s '\
'and location_dest_id IN %s '\
'and product_id IN %s '\
'and state IN %s ' + (date_str and 'and '+date_str+' ' or '') +' '\
'group by product_ id,product_ uom',tuple( where))
cr. execute(
'select sum(product_qty), product_id, product_uom '\
'from stock_move '\
'where location_id IN %s '\
'and location_dest_id NOT IN %s '\
'and product_id IN %s '\
'and state in %s ' + (date_str and 'and '+date_str+' ' or '') + ' '\
'group by product_ id,product_ uom',tuple( where))
results2 = cr.fetchall()
# all moves from a location out of the set to a location in the set
'' + (prodlot_id and ('and prodlot_id = ' + str(prodlot_id)) or '') + ' '\
results = cr.fetchall()
if 'out' in what:
# all moves from a location in the set to a location out of the set
'' + (prodlot_id and ('and prodlot_id = ' + str(prodlot_id)) or '') + ' '\