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

Question re Missed Deduction Report

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
MP
New Member Send Private Message
Posts: 2
New Member
4/3/2010 8:45 PM
Hello Folks - I've been thrown in Lawson and am "supposed" to pick up where the previous expert left off... my hope is to swim rather than sink !! Please help on the following - user needs following report - I've been reading - will I get the following information from either BN320 , PR214, BN400, PR280 or PR276 - amount of deduction missed is key. Thanks in advance.

Emp Name
Address
City
State
Zip
Plan – Medical, Dental, etc.
Amount of the deduction missed, per plan (ex. $23 – Medical, $7 – Dental, etc.)
Deduction missed (Date of the miss and/or corresponding paycheck date)
Deleted User
New Member Send Private Message
Posts: 0
New Member
4/5/2010 9:31 AM
Depending on how your organization's deduction structure is set up, the data you're looking for can be obtained using the Add-ins - start with the ONETMDED table for the deductions and amounts that have been missed, then pull your ee info from the EMPLOYEE table. As long as deductions are set up to go into arrears, it's fairly simple. If you do not have them set up to go into arrears, unfortunately you may be up the proverbial creek.
Carolyn Lee
Veteran Member Send Private Message
Posts: 53
Veteran Member
4/6/2010 6:23 PM
if you know crystal well, create a custom report on open payments to run after final PR140 and before PR197, joining EMPLOYEE, BENEFIT, EMDEDMASTR, PAYDEDUCTN, PAYMASTR, ONETMDED to account for all benefit deductions. otherwise it will be labor intensive to csv out all those lawson reports and piece them together on excel.