EMDEDMASTR vrs PAYDEDUNCT

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
    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
      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
        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
          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
            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
              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
                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!!! :)
                You are not authorized to post a reply.