how to add a related field many2one?

Question

I have a field on stock_picking table I would like to relate it with stock_move

_inherit= 'stock.picking'

_column={

'user_id': fields.many2one('res.users', 'user', select=True),

}

I would like to relate the field user_id with stock_move
I tried this

_inherit= 'stock.move'

_column={

'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)

}

any Idea brothers?

Emipro Technologies Pvt. Ltd. · Accepted Answer

I think model in inherit it should be as follows:

_inherit= 'stock.picking'

_columns={ 'user_id': fields.many2one('res.users', 'user', select=True), }

_inherit= 'stock.move'

_columns={ 'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True) }

Mansi Kariya (mka) · Answer

Hello rachid,

you have added field in wrong model. try this,

_inherit= 'stock.move'

_columns={

'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)

}

and yeah this code is correct.

_inherit= 'stock.picking'

_columns={

'user_id': fields.many2one('res.users', 'user', select=True),

}

Hope this will help you. for more details on related field / check this. [1] /

[1] https://doc.odoo.com/6.0/developer/2_5_O

İlgili Gönderiler	Cevaplar	Görünümler
ver=Any: field meny2one the recommended way... many2one odoo	2 Mar 24	2424
Create many2one field in odoo16 error fields many2one odoo odoo16features	0 Mar 23	3632
Remove 'related' attribute from a existing related field. Çözüldü fields related_fields odoo changes Odoo13.0	1 Ağu 22	7504
Clear field many2one if a checkbox is deselected fields many2one	1 Oca 22	4206
How to find out whats the right text before a related field. Çözüldü stock fields related related_fields odoo	1 Oca 19	4268