openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #12733
[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