** Changed in: openobject-addons
Status: Fix Committed => Fix Released
** Changed in: openobject-addons
Milestone: None => 7.0
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/998631
Title:
stock wrong computation of internal moves in get_product_available
Status in OpenERP Addons (modules):
Fix Released
Bug description:
this is a rare hidden bug and will ony happen if
* what is only 'in' OR 'out'
* multiple internal location are selected
* stock moves between the selected internal location exist
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()
this can be fixed by elimination of the marked conditions
see patch
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/998631/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
