OpenErp 6.0 Payroll

Question

OpenERP , how to calculate tax based on a text field in HR → Configuration-> salary → salary chapters there is a text field “ Based on ”, I want to calculate income tax calculation based on

if base <150

don't deduct 

else if base <650

  deduct basic*0.1 -50 

elseif basic <1400

  deduct basic*0.15 -270 

I need to calculate something like this. Please help me. I from Ethiopia really appreciate your help. Im using OpenERP 6.0 v

thanks

Answer 1

I am using OpenERP 6.1 - you might want to update it since it has a much better imho interface.

In 6.1, you add a salary rule to the salary structure that is associated with the employee contract.

The Salary rule will contain the calculation. In fact, you have two options:

1) write all the calculations in python code of one rule - something like this:

 if categories.BASIC < 150: result = 0 elif categories.BASIC < 650: result = - categories.BASIC * 0.1 + 50 else: result = - categories.BASIC * 0.15 + 270 

2) use a rule range condition based on .BASIC categories and define some rules with python:

 # For 150 - 650 result = - categories.BASIC * 0.1 + 50 # For 650 - 1400 result = - categories.BASIC * 0.15 + 270 

3) If you want to complicate it even more, go to the rules of the percentage value of the range of values, then you do not need to enter the python rule code in the rules, but you will have double the number of rules - one set for percent (-basis * 0.1) and one set for displacement (50)

Depends on what you prefer, as this will decide what payslip will look like. Although the financial effect will be the same.

Forgot to note that the sequence number is needed! .BASIC categories will only include rule values ​​that were previously calculated according to the serial number.