Skip to Content
This question has been flagged
invoicemany2oneone2manymany2many
1 Atsakyti
6052 Rodiniai
Portretas
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.

Portretas
Atmesti
Portretas
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/

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Prevent selecting the same value in one2many field in odoo Solved
many2one one2many many2many
Portretas
Portretas
Portretas
Portretas
3
bal. 20
11682
Odoo V12 : ORM with One2many or Many2one
many2one one2many many2many odooV12
Portretas
Portretas
2
geg. 19
4822
Many2One inside One2Many domain filter from Many2Many
many2one one2many many2many osv.osv
Portretas
0
geg. 16
5322
How do I put One2many after Many2one defined? - transient module states reset
many2one one2many
Portretas
1
kov. 23
3271
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines
many2one one2many
Portretas
0
gruod. 22
3876