openerp-india team mailing list archive

[Launchpad Bug Tracker <945213@xxxxxxxxxxxxxxxxxx>]

** Branch linked: lp:~openerp-dev/openobject-addons/trunk-bug-945213-jir

-- 
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/945213

Title:
  stock -- insufficient error message

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  the result of this error
  https://bugs.launchpad.net/bugs/945208

  stock/stock.py
  ...
          (_check_product_lot,
              'You try to assign a lot which is not from the same product',
              ['prodlot_id'])]

  we had some 100 data entries and you get this message on validate - horror !!!
  no chance to find the problem without other tools.

  please write error messages for humans. e.g 
  product <product_name> .....

  this sql shows the problematic rows

  select m.location_dest_id,m.product_id,m.prodlot_id ,t.name, l.name, pl.name
    from stock_move m,
         product_product p,
         product_template t,
         stock_location l,
         stock_production_lot pl
   where p.id = m.product_id
     and t.id = p.product_tmpl_id
     and l.id = m.location_dest_id
     and pl.id = m.prodlot_id
   and (m.product_id,m.prodlot_id) in (select product_id,prodlot_id from stock_move where prodlot_id is not null except (select  product_id,id from stock_production_lot));

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/945213/+subscriptions