This discussion is archived
3 Replies Latest reply: Dec 2, 2012 10:36 PM by user8013866 RSS

Carry Over

user8013866 Newbie
Currently Being Moderated
Dears,

I Want to reset the Carry over every 2 Years, the example bellow will illustrates the case:

1- In 2012, my balance is 5 Days.
2- in 31-DEC-2012 run the PTO Carryover, the Process should Carry over those 5 days to 2013.
3- in 2013, my balance become 19 (14 + 5), Note: 14 is the Accrual Balance.
3- in 31-DEC-2013 run the PTO Carryover, Carry over should not Carry over the 5 Days to 2014, it should Carry over just 14.

R12.1.2

Thank you
  • 1. Re: Carry Over
    Duncan Casemore Expert
    Currently Being Moderated
    Hmm, great requirement - tricky one to do.

    In your Carry Over Fast Formula you have an Expiry Date. By default (meaning the seeded Fast Formulas) the expiry date is set to the end of the year into which it was carried forward. So, in your example, the Expiry Date of your 5 days from 2012 will expire on the 31st Dec 2013. That means when you run Carry Over from 2013 to 2014 it considers the 5 days from 2012. That's not what you want.

    What about if you set the Expiry Date to one day earlier, ie the 30th Dec 2013? Add something like this towards the end of your carryover Fast Formula:
    ...
    Expiry_Date = add_days(Expiry_Date, -1)
    ...
    RETURN Max_Carryover, Effective_date, Expiry_Date, Process
  • 2. Re: Carry Over
    user8013866 Newbie
    Currently Being Moderated
    Thank you so much, i will test it and feedback to you with the results.
  • 3. Re: Carry Over
    user8013866 Newbie
    Currently Being Moderated
    Thank you,

    Do you have another solution for such case.

    BR

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points