Update Employee table when report is run

kolaboy

Hi
I am trying to calculate 15% of salary increment for all employees after every 3 years.
I want a report that will calculate this increment and update the salaries of all the employees automatically in the employee table.
How can i archeive this. Any code that can do the magic?
Thanks

Savatage

so it's 15 of the current amount not 15 from the starting salary right?

3 Years = Base salary + 15% up
6 Years = 3 Years + 15% up
9 Years = 6 Years + 15% up
12 Years = 9 Years + 15%up

correct?

kolaboy

Yes you got the idea.
When the report is run, the employee table should be updated(salary field) with the increased salary automatically.
Regards

Savatage

one suggestion would be to add these to the setup table. That way they can be simply changed in the future if needed instead of having to change any code.

Add:
-Years Between Pay Increase
-Increase Percent

kolaboy

one suggestion would be to add these to the setup table. That way they can be simply changed in the future if needed instead of having to change any code.

Add:
-Years Between Pay Increase
-Increase Percent

Which object am i going to put on the setup:
Is there any report you suggesting to me. I would like to see the report to do this.
Thanks