Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Advance Pay

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
VLH
New Member
Posts: 1
New Member
1/16/2007 12:14 AM
    We have not conquered how to deduct multiple advance pays within a single pay week.

    If we are advancing an employees pay they may receive up to 6 manual pay checks per week. The following week we are processing their time and entering in as one time deductions. In other systems we have used we have entered as one time deductions, netting the employees check down to zero. And in some cases the employee has gone into arrears.

    With Lawson, we have used the PR39 unsuccessfully. If the employee had more than one deduction it would not take the subsequent deductions and net the persons pay to zero. (or put into arrears) We checked all deductions codes in the pr05 and they are set up to net to zero and create arrears...

    We also tried to use the PR14 but this created confusion to the users when they retrieved the employee and the advanced pay deduction from the previous weeks deduction remained...was it deducted , did it create arrears...these are the many questions they would ask themselves.

    We are using Lawson 9.0. We process weekly payroll for over 5,000 people. (NOT ALL HAVING ADVANCE PAY..thank goodness!) We have been told that their is no automated solution. We should use the 14.1 and enter the deduction and NOT create arrears. Each week we should track manually what has or has not been deducted. THIS WILL NOT WORK LONG TERM!

    I know this is LONG and I am sorry...please respond if you have experience with advance pay and how to document in the system...or any other suggestions!
    Sam Simpson
    Veteran Member
    Posts: 239
    Veteran Member
    1/16/2007 2:55 PM
      Vicky,

      I thought the issue of retro pay/deductions has been resolve by version 9. In 8.0.x version I created a cobol program that do the retro pay and deduction from different benefit plans. It's a huge program that creates 2 csv files OTDLOADCSV for retro deductions and PRTRIN for retro pay. OTDLOADCSV is loaded via PR539(I forgot which program for PRTRIN). These two files has records that can expand into many pay period(depending on the size of the array. I usually have 26 pay periods). I also have created a pay calendar table that holds different pay period dates such as beginning, ending, check dates, etc. which is refreshed with new calendar every year. To create the current and future pay period, you have to have understanding about how some tables like ONETMDED and EMDEDMASTR are created. It took me many trial and errors to understand how these tables are populated. It has been a long while and I could not remember the full detail of the program but you can search in Lawson about the two csv files above.

      Hope this helps.
      Sam Simpson
      Veteran Member
      Posts: 239
      Veteran Member
      1/16/2007 3:15 PM
        Just came to my mind. PR530 is the program to load PRTRIN (PRTCSV). The program I created has been in place for more than 3 years now and I have not heard of any problems at all. Also in lieu of calendar table, you can also have the following parameters to enter various dates like Pay Period Start date, Start/End of review dates.