Odoo Help

0

Display a custom variable into a view from pricelists

By
Alessandro D'Armiento
on 8/10/15, 6:43 AM 737 views

Hell. I need to show into my wholesale shop a Suggested Retail Price (SRP) float value.
As this example:

http://s16.postimg.org/prh80q0rp/Cattura.png  (Please manually select it and open in another tab since I don't have enaugh Karma Points to put direct links)

This value has to be bound with the pricelist, so it can be different according to the customer in the shop.


I created a custom field "x_retail_suggested_price" into my product.pricelist.item model and correctly added it into my product.pricelist.item.form view, as you can see.

http://s7.postimg.org/dkmwk6n3v/Cattura.png


Now my problem is that I'm not able to display it into my Frontend view. I tryied many options like 

<span t-field="product_pricelist_item.x_retail_suggested_price" style="white-space: nowrap;" t-field-options="{ "widget": "monetary", "display_currency": "user_id.partner_id.property_product_pricelist.currency_id" }"> </span>


But everytime QWeb cannot parse it and return me error 500.

As always, thanks for your help


0
Alessandro D'Armiento
On 8/13/15, 10:54 AM

UPDATE:

Here you can see the content of public_product_pricelist_item table into DB,

[img]http://s13.postimg.org/5pgs30gfq/Screenshot_from_2015_08_13_16_43_39.jpg[/img]

As you can see, any row contains product_id, pricelist_id and the SRP field I need.
What should I do, is to perform an SQL query that returns the SRP vaule where pricelist_id is equal to pricelist_id associated with the customer (I don't know in which table this is stored) and product_id is equal to the product_id of product template.
Any advice?

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 8/10/15, 6:43 AM
Seen: 737 times
Last updated: 8/13/15, 10:54 AM