openerp-india team mailing list archive

[Pierre Girard <1048801@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I was trying to make a purchase order with price base on "Partner
section of the product form"...

But I could not get the price I set...

After a little research i found that the price list used is defined in
price_get_multi() function of the product_pricelist object.

It seems that in the sql query:
base <> -2 OR %s IN (SELECT name FROM product_supplierinfo WHERE product_id = %s)

We pass a product.product id instead of a product.template id, which is
the target of product_id in the product_supplierinfo object.

I think as long we have a ratio 1:1 for the template and product it's
not a problem, but actually i used product_variant_multi who create many
product for only one template which make differ the id...

So, the SELECT name FROM product_supplierinfo WHERE product_id = %s query always return false and then the query 
base <> -2 is always used...

-2 is the sql value for "Partner section of the product form"

I tried to inherit the product_supplierinfo object to change the target
of product_id but it seems to want to change...

I'am working on ubuntu 12.04lts
this project is on a 6.1 openerp-server
i'am working with a 6.1 gtk client

Thank you for any help!

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

Title:
  [6.1]purchase order can't use the "Partner section of the product
  form"

Status in OpenERP Addons (modules):
  New

Bug description:
  I was trying to make a purchase order with price base on "Partner
  section of the product form"...

  But I could not get the price I set...

  After a little research i found that the price list used is defined in
  price_get_multi() function of the product_pricelist object.

  It seems that in the sql query:
  base <> -2 OR %s IN (SELECT name FROM product_supplierinfo WHERE product_id = %s)

  We pass a product.product id instead of a product.template id, which
  is the target of product_id in the product_supplierinfo object.

  I think as long we have a ratio 1:1 for the template and product it's
  not a problem, but actually i used product_variant_multi who create
  many product for only one template which make differ the id...

  So, the SELECT name FROM product_supplierinfo WHERE product_id = %s query always return false and then the query 
  base <> -2 is always used...

  -2 is the sql value for "Partner section of the product form"

  I tried to inherit the product_supplierinfo object to change the
  target of product_id but it seems to want to change...

  I'am working on ubuntu 12.04lts
  this project is on a 6.1 openerp-server
  i'am working with a 6.1 gtk client

  Thank you for any help!

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