I am working with payroll module of OpenERP and going mad with the following error.
This is what i have tried:
but when i am trying to approve the payslip,i am getting the error:
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
This occurs only when I select 'unpaid' leave in 'leave type' section.
Finally i found the solution to the question..
The issue occurred when the account corresponding to the LOP is entered into db as False
.
To resolve the problem,just select a General Account
for the LOP
row in the
salary structure
tab of Payslip.