Skip to Content
This question has been flagged
invoicemany2oneone2manymany2many
1 Reply
6001 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
Prevent selecting the same value in one2many field in odoo Solved
many2one one2many many2many
Avatar
Avatar
Avatar
Avatar
3
Apr 20
11640
Odoo V12 : ORM with One2many or Many2one
many2one one2many many2many odooV12
Avatar
Avatar
2
May 19
4775
Many2One inside One2Many domain filter from Many2Many
many2one one2many many2many osv.osv
Avatar
0
May 16
5287
How do I put One2many after Many2one defined? - transient module states reset
many2one one2many
Avatar
1
Mar 23
3203
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines
many2one one2many
Avatar
0
Dec 22
3804