Missed Deduction Report - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

agersh

Veteran Member

Posts: 81

New Poster

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

New Poster

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

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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.

Deleted User

New Member

Posts: 0

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

New Poster

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