How is the link between invoices and payments done?

Question

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

Janeesh · Accepted Answer

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.

Cyril Sester · Answer

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 ->

Gérald Janniaux · Answer

Well, it seems I have to look at the 'reconcile' like table.

Thanks you all for your answers. I'm looking forward.

Powiązane posty	Odpowiedzi	Widoki
How do I mark a "partial" invoice as paid, for real? invoice payment	1 mar 25	1301
How to create a payment for an invoice from python code in odoo15 invoice payment	1 mar 23	5058
How can you pay with write off invoice payment	1 paź 22	11238
How do I resolve "Entries are not of the same account!" error when trying to confirm a payment on an Invoice? Rozwiązane invoice payment	7 sty 22	18666
Difference Amount in Payment Rozwiązane invoice payment	1 sty 24	15004

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!