← Back to team overview

openerp-india team mailing list archive

  1. openerp-india team
  2. Mailing list archive
  3. Message #12672

[Bug 1014721] [NEW] product_visible_discount breaks sale order

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

Openerp-server: 6.0.4
Openerp-web: 6.0.4

I've created a pricelist version and every pricelist version line has a
discount for every category product.

If product_visible_discount is installed and I try to add a line to the
sale order, all it's okay: Order line form has price correctly and the
discount is added to the textbox as it is expected.

But if I click on Save & Close or Save & new button of the Sale Order
line form I got this error:

LINE 1: ...r_line.price_unit,sale_order_line.product_uom_qty,sale_order...
                                                             ^
, in query SELECT sale_order_line.product_uos_qty,sale_order_line.procurement_id,sale_order_line.product_uom,sale_order_line.sequence,sale_order_line.order_id,sale_order_line.price_unit,sale_order_line.product_uom
_qty,sale_order_line.price_subtotal,sale_order_line.price_subtotal_incl,sale_order_line.discount,sale_order_line.product_uos,sale_order_line.invoiced,sale_order_line.delay,sale_order_line.name,sale_order_line.type
,sale_order_line.notes,sale_order_line.company_id,sale_order_line.salesman_id,sale_order_line.state,sale_order_line.product_id,sale_order_line.order_partner_id,sale_order_line.th_weight,sale_order_line.product_pac
kaging,sale_order_line.margin,sale_order_line.purchase_price,sale_order_line.address_allotment_id,sale_order_line.id FROM "sale_order_line" WHERE sale_order_line.id IN %s ORDER BY sequence, id desc
[2012-06-18 16:23:35,033][vspcenter] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/sale/sale.py", line 360, in write
    return super(sale_order, self).write(cr, uid, ids, vals, context=context)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3471, in write
    result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/fields.py", line 516, in set
    result += obj._store_get_values(cr, user, [id_new], act[2].keys(), context)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3776, in _store_get_values
    ids2 = fncts[fnct][2](self, cr, 1, ids, context)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/sale/sale.py", line 188, in _get_order
    result[line.order_id.id] = True
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 292, in __getattr__
    return self[name]
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 205, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 2979, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3038, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column sale_order_line.price_subtotal does not exist
LINE 1: ...r_line.price_unit,sale_order_line.product_uom_qty,sale_order...
                                                             ^

** 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/1014721

Title:
  product_visible_discount breaks sale order

Status in OpenERP Addons (modules):
  New

Bug description:
  Openerp-server: 6.0.4
  Openerp-web: 6.0.4

  I've created a pricelist version and every pricelist version line has
  a discount for every category product.

  If product_visible_discount is installed and I try to add a line to
  the sale order, all it's okay: Order line form has price correctly and
  the discount is added to the textbox as it is expected.

  But if I click on Save & Close or Save & new button of the Sale Order
  line form I got this error:

  LINE 1: ...r_line.price_unit,sale_order_line.product_uom_qty,sale_order...
                                                               ^
  , in query SELECT sale_order_line.product_uos_qty,sale_order_line.procurement_id,sale_order_line.product_uom,sale_order_line.sequence,sale_order_line.order_id,sale_order_line.price_unit,sale_order_line.product_uom
  _qty,sale_order_line.price_subtotal,sale_order_line.price_subtotal_incl,sale_order_line.discount,sale_order_line.product_uos,sale_order_line.invoiced,sale_order_line.delay,sale_order_line.name,sale_order_line.type
  ,sale_order_line.notes,sale_order_line.company_id,sale_order_line.salesman_id,sale_order_line.state,sale_order_line.product_id,sale_order_line.order_partner_id,sale_order_line.th_weight,sale_order_line.product_pac
  kaging,sale_order_line.margin,sale_order_line.purchase_price,sale_order_line.address_allotment_id,sale_order_line.id FROM "sale_order_line" WHERE sale_order_line.id IN %s ORDER BY sequence, id desc
  [2012-06-18 16:23:35,033][vspcenter] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/sale/sale.py", line 360, in write
      return super(sale_order, self).write(cr, uid, ids, vals, context=context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3471, in write
      result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/fields.py", line 516, in set
      result += obj._store_get_values(cr, user, [id_new], act[2].keys(), context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3776, in _store_get_values
      ids2 = fncts[fnct][2](self, cr, 1, ids, context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/sale/sale.py", line 188, in _get_order
      result[line.order_id.id] = True
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 292, in __getattr__
      return self[name]
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 205, in __getitem__
      field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 2979, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/orm.py", line 3038, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column sale_order_line.price_subtotal does not exist
  LINE 1: ...r_line.price_unit,sale_order_line.product_uom_qty,sale_order...
                                                               ^

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next