thank you for the support. but removing the if condition did not worked for me. Debit and credit fields are default computed fields with no stored value. kindly suggest what should be done as in this case "balance" field is also computed field with no stored value.

regards

then define balance as also compute field instead of on changing it on onchange

balance = fields.Monetary(compute='_compute_balance', string='Total Balance')

@api.mulit

def _compute_balance(self)

for record in self:

record.balance = record.debit - record.credit

Note: if you want it to be searchable implement inverse/search

Thanks a lot it worked. i had two views for debit and credit and one of them was invisible so code update was not working properly. i have changed the code as per your suggestion and removed the duplicate view and it worked.

Cool, it's my pleasure :)