This question has been flagged
2 Replies
6119 Views

Hi Folks,

I am not able to register employee payslip I am getting an error

Integrity Error
 The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set
 [object with reference: contract_id - contract.id]

The log I am getting on Terminal is 

ZVEMPL openerp.sql_db: bad query: insert into "hr_payslip_line" (id,"slip_id","condition_select","code","amount_select","rate","sequence","condition_python","amount","amount_python_compute","company_id","quantity","amount_percentage","appears_on_payslip","condition_range","active","category_id","amount_fix","name",create_uid,create_date,write_uid,write_date) values (17,16,'none','BASIC','fix','100.00',5,'
# Available variables:
#----------------------
# payslip: object containing the payslips
# employee: hr.employee object
# contract: hr.contract object
# rules: object containing the rules code (previously computed)
# categories: object containing the computed salary rule categories (sum of amount of all rules belonging to that category).
# worked_days: object containing the computed worked days
# inputs: object containing the computed inputs

# Note: returned value have to be set in the variable ''result''

result = rules.NET > categories.NET * 0.10','27000.00','
# Available variables:
#----------------------
# payslip: object containing the payslips
# employee: hr.employee object
# contract: hr.contract object
# rules: object containing the rules code (previously computed)
# categories: object containing the computed salary rule categories (sum of amount of all rules belonging to that category).
# worked_days: object containing the computed worked days.
# inputs: object containing the computed inputs.

# Note: returned value have to be set in the variable ''result''

result = contract.wage * 0.10',1,'1.00','0.0000','True','contract.wage','True',1,'0.00','Basic',1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/home/server/workspace/openerp/openerp-7.0server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "contract_id" violates not-null constraint

 

Avatar
Discard
Author

Hi Med Said BARA, I know what to write in Worked Days but I dont know how to use Days and Inputs I tried it as Incentives  -    BONUS -  95000.00  -  Contract for Priya And then I computed salary But still there is an same error I would be very greatful to you if please tell me what exaclty the error means what are the steps I should follow

Author

Hi Med Thanks for your reply , Actually I got now, earlier I was calculating Salary computation before confirming it . Thanks you resolved the issue

Best Answer

First:

Begin by creating a contract for your employee

Second:

If it's already done, select this contract ( i mean a valid contract for this employee) in the Employee Payslip (under the Tab : Worked Days & Inputs).

 

 

Avatar
Discard
Author Best Answer

Hi Med Thanks for your reply ,

Actually I got now, earlier I was calculating Salary computation before confirming it .

Thanks you resolved the issue

 

 

Avatar
Discard