in plan pto_payroll_balance_calculation formula has been attached.
I have requirement like,
PTO is awarded on 1st day of the year.
0 - 5 years --120hours
5 - 15 years -160 hours,
15 - 99 -240 hours,
Employees are only allowed to rollover 40 hours a year.
Example for requirement :
John Smith get 120 hours of vacation based on how long he has been at company.
From here I need this amount to decrease as he uses his PTO so when I look at his balance it should show his remaining balance.
The at the end of the year when I run the carry over process he is allowed to carry over any unused PTO up to 40 Hours.
For absence type ,it chosen as increment.
You need to give more details, from what you have stated I don't see where you would need to modify the formulas at all. Please explain exactly what gaps you have that cannot be solved by doing using seeded functionality.