In Odoo V13 enterprise.

I have an invoice and I want to find the relevant payment record but the invoices ID is in the 'reconciled_invoice_ids' many2many field.

If I do env['account.payment'].search([('reconciled_invoice_ids','=',invoice.id)]) it returns quite a few payments without the relevant ID in the reconciled field.

If I try .search([(invoice.id,'in','reconciled_invoice_ids')]) it gives me an invalid leaf error.

I am not really sure what the correct way to do this is.