UpFront Accrual

 Hi All,

I am trying to create a new UpFront Accrual for one our clients. Because our client wants to give the leaves to employee in advance.  So, they want net entitlement and projected entitlement values should be same. I have a following basic accrual formula for this:

Simple UpFront Accrual Formula

INPUTS ARE

Calculation_Date (date)

Total_Accrued_PTO = 20

Effective_start_date =

to_date('0101'||to_char( calculation_date, 'YYYY'),'DDMMYYYY')

Effective_end_date =

to_date('3112'||to_char( calculation_date, 'YYYY'),'DDMMYYYY')

Accrual_end_date =

to_date('0101'||to_char( calculation_date, 'YYYY'),'DDMMYYYY')

RETURN Total_Accrued_PTO,