3 Replies Latest reply on Dec 3, 2012 6:36 AM by user8013866

    Carry Over


      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.


      Thank you
        • 1. Re: Carry Over
          Duncan Casemore
          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
            Thank you so much, i will test it and feedback to you with the results.
            • 3. Re: Carry Over
              Thank you,

              Do you have another solution for such case.