Show related field from product template on account move

Question

Hi, I'd like to show intrastat_id field that is on product form in account move (when creating invoices)
I'm inheriting it like this

class ProductTemplate(models.Model):
_inherit = ' account.move.line' [1]
product_template_id = fields.Many2one('product.template')
intra_stat = fields.Many2one(related="product_template_id.intrastat_id", string='Intrastat #')
It shows nothing - blank field in lines. What am I doing wrong? I double checked if Intrastat is set on product.

[1] https://account.move

Samuel RAMAROSELY · Accepted Answer

Hello @Matija
Did you set a value for product_template_id in your account_move_line?
Otherwise, I think you don't have to create a new field 'product_template_id', you just have to set intra_stat field as related to product_id of account.move.line [1] .

intra_stat = fields.Many2one(related="product_id.intrastat_id", string='Intrastat #')

[1] https://account.move.line

Gerelateerde posts	Antwoorden	Weergaven
How to make lot_id a related field in product.product product.product related_fields product.template	1 mei 23	3478
Attempting to add 'lot_ids' to product.template - KeyError: 'lot_id' related_fields product.template Lots/Serial	0 jun. 22	2472
How can I group move line by account ? account.move.line	1 sep. 23	3991
odoo 13 related field to a custom field not working related_fields	2 apr. 23	8355
Acces field of other product.template Opgelost product.template	3 dec. 19	8347

Deze vraag is gerapporteerd

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