LP64 Absence Balance - Extra Accrual

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Kelci
Basic Member
Posts: 11
Basic Member
    Hi everyone,
    I'm stumped with this one, so I'm hoping someone out there can point me in the right direction!  Our employees are on accrual vacation and PTO plans that reset each January 1st and carryover balances are created.  For one of our smaller employee groups, the LP64 balance isn't lining up with the balance when we manually calculate it via the LP264 - the LP64 is exactly one accrual higher than we would expect. 

    I'm running the LP264 from 1/1 to present for all transactions.  I sorted the output by plan name and transaction date so that I could compare it exactly with the LP64, and everything lines up:  Carryover balances are the same in both places, and the usage and weekly accruals all match up; but when I total the LP264 spreadsheet transactions, we see the one accrual difference.  Has anyone encountered this issue before?  We recompiled our LP31 and LP64, but that didn't solve the discrepancy, and other other employee absence plans aren't affected - their LP64 and LP264 balances match up just fine.

    Any suggestions or troubleshooting tips so that I can understand what's happening would be appreciated!
    Kelci
    M.J.
    Veteran Member
    Posts: 38
    Veteran Member
      Hi Kelsi,

      One thing you might check is on LP31 for the 'Accrual Last' and 'Hours last period end' -  does it match your last pay period? 
      Kelci
      Basic Member
      Posts: 11
      Basic Member
        Hi M.J.,
        Thanks for your comment! The LP31 screen appears correct with the correct Accrual Last date, so I started looking at prior years in the LP264 and found the issue. We posted the last 2013 accrual for this group on 1/6/2014; unbeknownst to me Lawson treated it as an "Available" accrual instead of rolling it into the "Carryover" balance (I think this may have been due to the order our year-end LP140 transactions.)

        Based on the instructions of my predecessor - who knew a great deal more about the absence plans than I - our payroll team ran the LP140 using Option 3 - Events/Usage Only to pick up hours used, then ran LP197 to close it out. We then ran a second LP140 using option 6 (Carryover Only), and LP197. Finally, a 3rd LP140 was processed using Option 1 (All processing), with LP197.

        If I understand the process correctly, that meant that the Carryover balance was calculated before the last 2013 accrual was processed. Could we prevent that by modifying the process to:
        1. LP140 Option 3 (Events/Usage); LP197
        2. LP140 Option 7 (Retroactive Accruals); LP197
        3. LP140 Option 6 (Carryover); LP197
        4. LP140 Option 1 (All); LP197

        Or are we over-complicating the process entirely? Any (and all) feedback is appreciated!
        -K.