← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 681438] [NEW] can't sort by customer in line to invoice

 

Public bug reported:

line to invoice (from Sales/Invoicing/Lines to Invoice) 
      - bug when you sort by Customer (click on column header) -> you can fin traceback here under

reorganise group by : Salesman | Product  Order | State

Traceback (most recent call last):
  File "/home/aline/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/aline/openerp/trunk/server/bin/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 1834, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 4049, in _search
    order_by = self._generate_order_by(order, query)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 4016, in _generate_order_by
    order_by_clause = self._generate_m2o_order_by(order_field, query)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 3977, in _generate_m2o_order_by
    assert order_field_column._classic_write or getattr(order_field_column, 'store', False), "Many2one function/related fields must be stored to be used as ordering fields"
AssertionError: Many2one function/related fields must be stored to be used as ordering fields

** Affects: openobject-addons
     Importance: Low
     Assignee: OpenERP R&D Addons Team 3 (openerp-dev-addons3)
         Status: Confirmed

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

-- 
can't sort by customer in line to invoice
https://bugs.launchpad.net/bugs/681438
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: Confirmed

Bug description:
line to invoice (from Sales/Invoicing/Lines to Invoice) 
      - bug when you sort by Customer (click on column header) -> you can fin traceback here under

reorganise group by : Salesman | Product  Order | State

Traceback (most recent call last):
  File "/home/aline/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/aline/openerp/trunk/server/bin/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/openerp/trunk/server/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 1834, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 4049, in _search
    order_by = self._generate_order_by(order, query)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 4016, in _generate_order_by
    order_by_clause = self._generate_m2o_order_by(order_field, query)
  File "/home/aline/openerp/trunk/server/bin/osv/orm.py", line 3977, in _generate_m2o_order_by
    assert order_field_column._classic_write or getattr(order_field_column, 'store', False), "Many2one function/related fields must be stored to be used as ordering fields"
AssertionError: Many2one function/related fields must be stored to be used as ordering fields





Follow ups

References