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!!! :)