I would like to find the many2many relation between an invoice and payments attached to it. It seems to be done via a payment_ids field in the view but do not know where to look for it.
Many thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I would like to find the many2many relation between an invoice and payments attached to it. It seems to be done via a payment_ids field in the view but do not know where to look for it.
Many thanks
Normally many2many fields are storing in a table whose name is given in field declaration. But in invoice , payment_ids is a functional field. It deosn't storing on any table.
Hi Gérald.
The payment_ids is a function fields who refers to some move lines. The _compute_lines function searches for move_lines (partially) reconciled with the move_lines generated by the invoice. For example :
Invoice inv_1 generates 1 move (mov_1) when the invoice is validated.
mov_1 contains 2 move_line (ml_1, ml_2).
Payment mov_2 is created and contains 2 lines (ml_3, ml_4).
You reconcile ml_4 with ml_2. The _compute_lines function finds that ml_4 is reconciled with ml_2 -> Payment mov_2 is attached to inv_1.
Hope it helps... !
Well, it seems I have to look at the 'reconcile' like table.
Thanks you all for your answers. I'm looking forward.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
Mar 23
|
2964 | ||
|
1
Oct 22
|
9458 | ||
|
7
Jan 22
|
16139 | ||
Difference Amount in Payment
Solved
|
|
1
Jan 24
|
13227 | |
|
1
Oct 19
|
2668 |