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

Additional Pay per Hour

 7 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
MSheldon
Basic Member
Posts: 5
Basic Member
3/26/2015 4:53 PM

    We have a location where we are required to pay an additional hourly amount for employees who do not qualify for our vacation plan and an additional amount per hour for employees who do not elect to carry our insurance.  We would like to keep the base pay amount (shown under pay in the HR11) and then show separate pay codes that calculate the additional amount based on hours loaded into the PR36.  Is it possible to do this without a manual calculation?

    Example:  Hourly rate = $9.00, No health coverage = $0.50, No vacation = $1.50

    If the employee works 40 hours in a week we would like to see:

    40 Hours (regular) x $9.00

    40 Hours (health premium pay) x $0.50

    40 Hours (vacation premium pay) x $1.50

    Instead of having to lump it all together where we would see 40 Hours x $11.00.  Is it possible to do this for 1 location only without having to manually add the additional pay codes each pay period?

    Jimmy Chiu
    Veteran Member
    Posts: 641
    Veteran Member
    3/26/2015 7:09 PM
      I would create 2 additional employee groups. One emp group with no health premium and one emp group that do not qualify for vacation plan for that one location.

      So after you put in all the regular hours. Do a join query and export timerecord of the first employee group (no health premium). You just need to company/employee/paycode/hours/transDate etc. Change the pay code and addins upload that back in.

      Repeat the same for the (no vacation plan)

      If you want a more automatic time entry. you can customize PR36 to check if the employee has no health premium or not quality vacation plan etc. When it enter your regular time, it writes additional health premium pay time record + vacation premium pay time record automatically.
      MSheldon
      Basic Member
      Posts: 5
      Basic Member
      3/27/2015 11:41 AM
        We upload the time records from our time keeping system using an interface that loads them into the PR35.2.

        Can the customization be done there or only after it is released to the PR36?

        Also, how do you set the system up to check that in the PR36? Is it on another screen?
        Karen Ploof
        Veteran Member
        Posts: 118
        Veteran Member
        3/27/2015 11:50 AM
          If you're going to code customization anyway, I'd look at using the custom calculation type on the pay code with code to calculate the amount.
          MSheldon
          Basic Member
          Posts: 5
          Basic Member
          3/27/2015 12:33 PM
            I am planning to set up pay codes for the new amounts that need to be paid.

            Are you saying that you can customize the pay code look at what has been loaded?
            Karen Ploof
            Veteran Member
            Posts: 118
            Veteran Member
            3/27/2015 1:38 PM
              My experience has been that if we define a pay code to use the X-Custom Calculation type, a programmer can write a user-exit that can do ANYTHING :-). It's been a lot of years, but I think I had a union deduction that required we multiply the # of hours worked for pay types in a specific pay class by a flat rate. Sounds pretty similar to your situation.

              Ragu Raghavan
              Veteran Member
              Posts: 476
              Veteran Member
              3/27/2015 2:20 PM
                In my experience, a user exit is best used when it affects only one pay code. In this case, looks like based on hours in one pay code, the amounts in two different pay codes will be affected. Probably better to use a custom process (4GL, process_flow etc) that will run after the import. Look up certain pay codes, create new time records with the appropriate pay-code/hours/amt
                Karen Ploof
                Veteran Member
                Posts: 118
                Veteran Member
                3/27/2015 2:27 PM
                  Good to have an opinion on the different options. Thanks, I'll keep this in mind.

                  Karen