跳至內容
選單
此問題已被標幟
1 回覆
5059 瀏覽次數

How to put manufacturer name of products on sales order line in the quotation to customers (rml) ? I set the manufacturer name of each products at the procurement tab .. Please help me

頭像
捨棄

Hi Manu,

If there will be more than 1 supplier/manufacturer of the product in the procurement tab of the product, then how'd you like to display it on the sale_order quotation report? Let me know and I can try with that in my local and get back to you.

Let me give you a hint as well for how we can achieve this, we can pass the product_id for each order_line to a method (say get_manufacturer(line.product_id)) from RML, then in the sale_order.py file we need to define this method and fetch the name from product.supplier_info table by filtering it with the product_id.

Cheers

作者

Hi ASP, Thanks for your kind reply.. sorry for the late reply.. I have only one manufacturer for each product. I just wanted to put the manufacturer name of each product on each order lines in quotation report. Anyway I achieved this in a way which is given below on answer section.. Thanks for your help.. Can you give a look on this question please . I really stuck on this. Thanks in advance..http://help.openerp.com/question/51004/dont-allow-to-quote-below-the-sales-price-of-a-product/

作者 最佳答案
  1. In OpenERP Report Designer → Modify Existing Report → Sales Order - Quotation / Order – Open Report.
  2. On Order Lines add a new column named Manufacturer.
  3. Press the "Convert Brackets to Fields" button in the openerp toolbar
  4. Go to Add a field → line(Sales Order Line) → /Product/Manufacturer/Name → ok
  5. Export to RMl.
頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
6
1月 17
15687
1
3月 15
4052
1
1月 25
8647
3
7月 24
8594
1
1月 24
4887