Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Get field value from another model

product field sale.order.line model v12

4 الردود

17945 أدوات العرض

CAVAILLÈS

Hi,

I want to add product type in sale order lines but the field is on another model.

How can I get its value ?

Thanks in advance !

CAVAILLÈS

الكاتب أفضل إجابة

I put it here in case someone needs to do it as well.

Here is the final code :

class SaleOrder(models.Model):

_inherit = "sale.order"

class SaleOrderLine(models.Model):

_inherit = "sale.order.line"

product_type_id = fields.Selection(related='product_id.product_tmpl_id.type', string='Type')

I found it thanks to this link : https://www.odoo.com/fr_FR/forum/aide-1/question/odoo-10-how-to-set-a-product-category-field-to-the-sale-order-line-128344

Kiran K

When you need to show the value of a field from a relational model to the current model you can do that by defining a related field. To do that you need in the field definition to define attribute related with value sequence of field names.

class AccountInvoiceInherited(models.Model):

    _inherit = 'account.invoice'

    company_selection = fields.Many2one('account.analytic.account', string="Company")

class AccountMoveInherited(models.Model):

    _inherit = 'account.move'

    rel_account_invoice = fields.Many2one('account.invoice', string='Related Account Invoice')

    rel_company_selection = fields.Many2one('account.analytic.account', string="Company",          related='rel_account_invoice.company_selection')

CAVAILLÈS

الكاتب

OK, so I have this :

class SaleOrder(models.Model):

_inherit = "sale.order"

class ProductTemplate(models.Model):

_inherit = 'product.template'

class SaleOrderLine(models.Model):

_inherit = "sale.order.line"

type_id = fields.Many2one("product.template", string="Type")

rel_type_id = fields.Many2one("product.template.type", string="Type", related="type_id.type")

What am I missing ?

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? تم الحل product field employee model	3 يناير 17	3825
How to create a incremental custom field , that increase its value for each stockable product? product field sequence sale.order.line stockable	0 فبراير 16	3655
How to create a incremental custom field , that increase its value for each product stockeable? product field sequence sale.order.line stockable	0 فبراير 16	4349
what's the field '_date_name' means in a model field model	0 مارس 24	4269
Change Sale Quotation Form so Product is Not Required? product sale.order.line	2 مارس 18	4152

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!