← Back to team overview

openerp-india team mailing list archive

[Bug 1014721] Re: product_visible_discount breaks sale order

 

Hello Cubells,

"account_invoice_payment_term " is part of the extra-addons, which are maintained by the community, including all the modules created by "OpenERP" or "Tiny", as none of these are actively developed by our teams anymore.
So if you or anyone from the community would like to work on it, please mark the bug as "In progress" and assign it to yourself (or ask us or anyone from OpenERP Drivers to do it for you). In the mean time, I will mark it as "Won't fix" to indicate that no further progress is expected at the moment.

Thank you!

PS: For whomever works on fixing this, you probably want to apply/merge your changes in both the 6.0 and trunk branches of extra-addons:
https://code.launchpad.net/~openerp-commiter/openobject-addons/extra-6.0
https://code.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons


** Changed in: openobject-addons
       Status: Incomplete => Won't Fix

-- 
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):
  Won't Fix

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


References