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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Get field value from another model

product field sale.order.line model v12

4 Vastaukset

17963 Näkymät

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

Tekijä Paras vastaus

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

Tekijä

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 ?

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? Ratkaistu product field employee model	3 tammik. 17	3833
How to create a incremental custom field , that increase its value for each stockable product? product field sequence sale.order.line stockable	0 helmik. 16	3664
How to create a incremental custom field , that increase its value for each product stockeable? product field sequence sale.order.line stockable	0 helmik. 16	4369
what's the field '_date_name' means in a model field model	0 maalisk. 24	4278
Change Sale Quotation Form so Product is Not Required? product sale.order.line	2 maalisk. 18	4156

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!