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

Missed Deduction Report

 4 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
agersh
Veteran Member
Posts: 81
Veteran Member
5/30/2012 12:16 PM
    My organization is a new Lawson HR-Payroll customer. I have recently been assigned a task to create a accumulative report that shows those employees that have missed benefit premiums deductions. Whether it be partial or entire amounts missed per pay period/pay day. Can anyone provide me instruction on which Lawson tables I will need to accomplish this task and the criteria to use to determine a missed deduction? Or of anyone already has a crystal report or Lawson Add-in that they can share.

    Thank You in advance, your help is defiantly appreciated.
    Karen Sheridan
    Veteran Member
    Posts: 141
    Veteran Member
    5/30/2012 12:41 PM
      Do you mean deductions that go into arrears and can be viewed on the PR39.1?
      Ragu Raghavan
      Veteran Member
      Posts: 476
      Veteran Member
      5/30/2012 2:17 PM
        BENEFITS (to show enrollment), EMDEDMASTR (to show system created benefit deductions) and PAYDEDUCTN (to show deductions taken) may be a start.
        Mary Porter
        Veteran Member
        Posts: 337
        Veteran Member
        5/30/2012 2:35 PM
          We've only been on Lawson since January, but I run PR239 after payroll closes to see what went into arrears/missed deductions.
          Karen Sheridan
          Veteran Member
          Posts: 141
          Veteran Member
          5/30/2012 2:55 PM
            Arrears deductions go into the One Time Deduction Table (ONETMDED) with a record type of X or A

            If you don't want to include Company side deductions you can exclude Adjust Pay of C

            We created a benefits deduction class for the deduction codes we wanted to include

            // Benefits deduction class
            {DEDCODE.DED_CLASS} = 'BEN'
            and
            //not a company deduction
            {DEDCODE.ADJUST_PAY} <> 'C'
            and
            //Arrears deduction
            {ONETMDED.RECORD_TYPE} in ['A','X']

            I've attached a Crystal Report we use for this

            HTH,
            Karen
            Attachments