← Back to team overview

openerp-india team mailing list archive

[Bug 1105548] [NEW] Assigning Serial Numbers to incoming products (warehouse)

 

Public bug reported:

I need to assign unique serial numbers to incoming products. Multiple
products of the same type need to be split into unique serial numbers so
these can be traced in later process steps.

When trying to assign serial number to incoming products causes an issue
as follows:


Tested on Runbot / Deb 7.0 latest and windows version with the same result.
(Build 2320)
server (4769)
addons (8518)
web (3671)
 

Procedure:
1. Configure Serial number in settings/warehouse
2. menu  /warehouse/ incoming products/  select an incoming product (e.g [GRAPs/w] GrapWorks Software in runbot)
3. Select the dropdown menu in the field 'serial number'causes the following error to appear: 


Client Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/controllers/main.py", line 1083, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/controllers/main.py", line 1075, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 43, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)


Server Traceback (most recent call last):
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/netsvc.py", line 289, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/service/web_services.py", line 614, in dispatch
    res = fn(db, uid, *params)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 169, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 123, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 179, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
    return fct_src(cr, uid, model, method, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 166, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/stock/stock.py", line 1409, in name_search
    ids = self.search(cr, uid, args, limit=limit, context=context)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 2356, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 4845, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 4678, in _where_calc
    where_clause, where_params = e.to_sql()
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/expression.py", line 1205, in to_sql
    q, p = self.__leaf_to_sql(leaf)
  File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/expression.py", line 1156, in __leaf_to_sql
    query, params = self.__leaf_to_sql((left, '=', right), model)
TypeError: __leaf_to_sql() takes exactly 2 arguments (3 given)

** Affects: openobject-addons
     Importance: Undecided
         Status: New

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

Title:
  Assigning Serial Numbers to incoming products (warehouse)

Status in OpenERP Addons (modules):
  New

Bug description:
  I need to assign unique serial numbers to incoming products. Multiple
  products of the same type need to be split into unique serial numbers
  so these can be traced in later process steps.

  When trying to assign serial number to incoming products causes an
  issue as follows:

  
  Tested on Runbot / Deb 7.0 latest and windows version with the same result.
  (Build 2320)
  server (4769)
  addons (8518)
  web (3671)
   

  Procedure:
  1. Configure Serial number in settings/warehouse
  2. menu  /warehouse/ incoming products/  select an incoming product (e.g [GRAPs/w] GrapWorks Software in runbot)
  3. Select the dropdown menu in the field 'serial number'causes the following error to appear: 


  
  Client Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/http.py", line 195, in dispatch
      response["result"] = method(self, **self.params)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/controllers/main.py", line 1083, in call_kw
      return self._call_kw(req, model, method, args, kwargs)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/controllers/main.py", line 1075, in _call_kw
      return getattr(req.session.model(model), method)(*args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 43, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 31, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 104, in send
      raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

  
  Server Traceback (most recent call last):
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/web/session.py", line 90, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/netsvc.py", line 289, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/service/web_services.py", line 614, in dispatch
      res = fn(db, uid, *params)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 169, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 123, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 179, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr
      return fct_src(cr, uid, model, method, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/osv.py", line 166, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/addons/stock/stock.py", line 1409, in name_search
      ids = self.search(cr, uid, args, limit=limit, context=context)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 2356, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 4845, in _search
      query = self._where_calc(cr, user, args, context=context)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/orm.py", line 4678, in _where_calc
      where_clause, where_params = e.to_sql()
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/expression.py", line 1205, in to_sql
      q, p = self.__leaf_to_sql(leaf)
    File "/home/odoo/runbot/static/openerp-dev-trunk-2320/server/openerp/osv/expression.py", line 1156, in __leaf_to_sql
      query, params = self.__leaf_to_sql((left, '=', right), model)
  TypeError: __leaf_to_sql() takes exactly 2 arguments (3 given)

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


Follow ups

References