Hello Masood,

i hope this will help to you

The issue you're facing with the domain [('spot_id.out_currency_id', '=', 'spot_id.company_currency_id')] not working is because you're trying to directly compare two fields within the domain, and this is not supported in Odoo's domain filtering.

In Odoo's domain filters, you can't compare two fields directly like that. However, you can achieve your goal using a technique called "inverse relationship" or "related field" along with a search() function.

Here's how you can modify your search domain to achieve the desired result:

# Use a related field to retrieve the company's currency for each payment

spot_company_currency = fields.Many2one(

related='spot_id.company_currency_id',

string='Spot Company Currency',

readonly=True,

)

# In your XML, use the domain as follows:

[('spot_id.out_currency_id', '=', spot_company_currency)]

In this approach, you're creating a related field spot_company_currency which retrieves the currency of the company associated with the spot. Then, in your XML domain, you're comparing the out_currency_id of the spot with the spot_company_currency of the payment, which is the equivalent of comparing these two fields.

This should allow you to filter the payments as you intended.