Customization of Vacation Leave from Calendar Year to FInancial Year
Hello,
I am seeking some information on how to change the calculation/accruing of vacation from calendar year to fiscal year. Currently our company uses the seed accrual formula which calculates vacation based on calendar year. we wish to change this to our financial year which starts 1st Oct and ends 30 Sep. based on what i have researched i will need to modify the formula to achieve this. The formula i will be modifying is the PTO_PAYROLL_BALANCE_CALCULATION since this formula is currently being used.
I have changed the variable Payroll_year_first_valid_date = to_date('0110'||char(calculation_date,'YYYY'), 'DDMMYYYY')