Skip to Content
This question has been flagged
invoicemany2oneone2manymany2many
1 Respondre
5323 Vistes
Avatar
Muszik Adrián

I wish to link(relate) two many2one lists, for example my custom module ng.machine and account.invoice

the account one:

'machine_ids' : fields.one2many('ng.machine', 'invoice_ids', 'Gépek'),

the machine one:

'invoice_ids' : fields.one2many('account.invoice', 'machine_ids', 'Számlák'),

but this gives me an error.If i change the fields to many2one then until i try to save everything works. when i try to save gives me this error:

ProgrammingError: can't adapt type 'dict'

How can i make it so that the 2 one2many list can relate to each other? bassickly on the machine's page see all the invoice that it is mentioned, and on the invoice see all the machines it mentions.

Avatar
Descartar
Avatar
Timo Talvitie, Vizucom Oy
Best Answer

Sounds like you should use a many2many relation for this: each of your machines can be linked to X invoices, and each of your invoices can be linked to Y machines. Try using the following fields:

In your invoice class:

'machine_ids':
   fields.many2many(
    'ng.machine',
    'ng_machine_rel',
    'invoice_id',
    'machine_id',
    'Gépek'),

And in your machine class the same thing but in reverse:

'invoice_ids':
   fields.many2many(
    'account.invoice',
    'ng_machine_rel', # same relation still
    'machine_id', # ...but fields of the relation now go in different order
    'invoice_id',
    'Számlák'),

The documentation has some notes on m2m usage here: https://doc.openerp.com/trunk/server/03_module_dev_02/

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Prevent selecting the same value in one2many field in odoo Solved
many2one one2many many2many
Avatar
Avatar
Avatar
Avatar
3
d’abr. 20
10937
Odoo V12 : ORM with One2many or Many2one
many2one one2many many2many odooV12
Avatar
Avatar
2
de maig 19
4271
Many2One inside One2Many domain filter from Many2Many
many2one one2many many2many osv.osv
Avatar
0
de maig 16
4885
How do I put One2many after Many2one defined? - transient module states reset
many2one one2many
Avatar
1
de març 23
2419
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines
many2one one2many
Avatar
0
de des. 22
3055