Skip to Content
This question has been flagged
productfieldsale.order.linemodelv12
4 Replies
15945 Views
Avatar
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 !

Avatar
Discard
Avatar
CAVAILLÈS
Author Best Answer

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

Avatar
Discard
Avatar
Kiran K
Best Answer

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')
Avatar
Discard
CAVAILLÈS
Author

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 ?

Related Posts Replies Views Activity
Could you confirm that the field product_id in hr_employee model doesn't exist in Odoo 10? Solved
product field employee model
Avatar
Avatar
Avatar
3
Jan 17
2387
How to create a incremental custom field , that increase its value for each stockable product?
product field sequence sale.order.line stockable
Avatar
0
Feb 16
2440
How to create a incremental custom field , that increase its value for each product stockeable?
product field sequence sale.order.line stockable
Avatar
0
Feb 16
3019
what's the field '_date_name' means in a model
field model
Avatar
0
Mar 24
2099
Change Sale Quotation Form so Product is Not Required?
product sale.order.line
Avatar
Avatar
Avatar
2
Mar 18
2777