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

Missed Deduction Report

 4 Replies
 0 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
agersh
Veteran Member
Posts: 81
Veteran Member
New Poster
New Poster
Congrats on posting!
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: 142
Veteran Member
New Poster
New Poster
Congrats on posting!
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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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: 142
Veteran Member
New Poster
New Poster
Congrats on posting!
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