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

EMDEDMASTR vrs PAYDEDUNCT

 6 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
5/7/2013 2:47 PM
The benefits team will begin offering deferred compensation 457-roth option. They setup an employee with the new deduction code using PR14.1. Payroll added another record using the PR05 screen. I want to report the employee deduction and amount but I am not really sure if I have to read the payment master file and the payment deduction file or the EMDEDMASTR file. Any help would be greatly appreciated?  
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
5/7/2013 4:01 PM
If you want to know what was deducted, have you looked at the PR275? If that doesn't work for you, I believe you want to pull from PAYDEDUCTN. EMDEDMASTR stores PR14 information.
Chesca
Veteran Member
Posts: 490
Veteran Member
5/7/2013 4:24 PM
Hi Margie, but payroll would first have to create a payment for test employees setup with the new deduction code?
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member
5/7/2013 5:44 PM
Yes, if this is not yet in production. Did you set it up as a benefit plan or just a straight deduction?
Chesca
Veteran Member
Posts: 490
Veteran Member
5/7/2013 6:04 PM
Correct, it's not in production yet. he users had a work around in place  for the new Roth Deduction, but now Lawson has sent a ctp patch that should handle this the right way. BSI taxfactory is also setup for this deduction.  

I wrote a program to pull data from the PAYMASTR and PAYDEDUCTN files to list employees with ROTH deductions/contributions. What Lawson file/table has YTD contributions for the tax year for x employee? 
Chris
Basic Member
Posts: 8
Basic Member
5/9/2013 11:10 AM
I would think you could use the QuartDed file and roll up the totals for each quarter in the year desired for employee x.
Chesca
Veteran Member
Posts: 490
Veteran Member
5/10/2013 5:45 PM
I wrote code to pull the totals off the QuartDed file as you suggested and I am able to get YTD totals. I applied  Lawson CTP (addition of BSI benefit plan codes for Roth 457(b) and setup BSI code. So far so good, I just have to wait for the users to enter their test data so we can create a test file. Thank you Chris and Margie for your help!!! :)