← Back to team overview

openerp-india team mailing list archive

[Bug 944723] [NEW] Approving Unpaid leaves creates error in payslip

 

Public bug reported:

I am working with payroll module of OpenERP and going mad with the
following error. This is what i have tried.

a)Created a unpaid leave in Leave Type and selected a payroll head 'LOP'
and created an Analytic account for the same

b)An employee requested for this unpaid leave from 'Leave Request
Section'

c)While calculating the payslip for that employee,the leaves and the
leave deductions are calculated and displayed in the payslip.

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.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

** Description changed:

  I am working with payroll module of OpenERP and going mad with the
  following error. This is what i have tried.
  
  a)Created a unpaid leave in Leave Type and selected a payroll head 'LOP'
  and created an Analytic account for the same
  
  b)An employee requested for this unpaid leave from 'Leave Request
  Section'
  
  c)While calculating the payslip for that employee,the leaves and the
- leave deductions are shown are calculated and displayed in the payslip.
+ leave deductions are calculated and displayed in the payslip.
  
  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.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/944723

Title:
  Approving Unpaid leaves creates error in payslip

Status in OpenERP Addons (modules):
  New

Bug description:
  I am working with payroll module of OpenERP and going mad with the
  following error. This is what i have tried.

  a)Created a unpaid leave in Leave Type and selected a payroll head
  'LOP' and created an Analytic account for the same

  b)An employee requested for this unpaid leave from 'Leave Request
  Section'

  c)While calculating the payslip for that employee,the leaves and the
  leave deductions are calculated and displayed in the payslip.

  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/944723/+subscriptions


Follow ups

References