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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Get field value from another model

product field sale.order.line model v12

4 Antwoorden

17964 Weergaven

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

Auteur Beste antwoord

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

Auteur

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 ?

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? Opgelost product field employee model	3 jan. 17	3835
How to create a incremental custom field , that increase its value for each stockable product? product field sequence sale.order.line stockable	0 feb. 16	3666
How to create a incremental custom field , that increase its value for each product stockeable? product field sequence sale.order.line stockable	0 feb. 16	4369
what's the field '_date_name' means in a model field model	0 mrt. 24	4280
Change Sale Quotation Form so Product is Not Required? product sale.order.line	2 mrt. 18	4157

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!