Desperate for payroll report help

  • Desperate for payroll report help

    Posted by DSC Communities on December 29, 2016 at 4:50 pm
    • Kathy Minnick

      Member

      December 29, 2016 at 4:50 PM

      I need to find the table that has a history of deductions for employees.

      I need to get a finished report of employee, deduction, sum of deduction for year.

      I can’t find the table that has the deduction amount for each paycheck for the year to do a sum on.

      Can anyone help me? Please?

      Kathy

      ——————————
      Kathy Lees
      Human Resources Assistant
      Black HIlls Surgical Hospital
      Rapid City SD
      ——————————

    • Tom Franz, CPP

      Member

      December 29, 2016 at 5:59 PM

      Payroll transactions (including deductions transactions) are stored in the UPR30300 table. Deduction-specific transactions will have a “PYRLRTYP” of 2. The following SQL statement should get you started:

      You may want to join the UPR30100 table and restrict to non-voided checks.

      Hope this helps!

      select EMPLOYID, PAYROLCD, sum(UPRTRXAM)

      from UPR30300

      where PYRLRTYP = 2

      and CHEKDATE >= ‘2016-01-01’

      and CHEKDATE <= ‘2016-12-31’

      group by EMPLOYID, PAYROLCD

      ——————————
      Tom Franz, CPP
      Product Manager
      Integrity Data
      Lincoln IL
      ————————————————————————-

    • Jeff Martin

      Member

      December 30, 2016 at 11:08 AM

      Hi Kathy,

      Have you looked at the Reports – Payroll – Employee Lists – List by Deductions report? It does not show the transaction detail but may work if you are only looking for a total for the year.  There are not any options to change the layout but it will give you a sum of each deduction by employee.  The report can be exported to at file if you want to rearrange the layout.  You should include Inactive Employees to make you get all the deductions for the date range that you enter.

      Have a happy New Year.

      ——————————
      Jeff Martin
      Director of IT
      DeRosa Corporation
      Wauwatosa WI
      ————————————————————————-

    • Tommy Tastet

      Member

      December 30, 2016 at 3:13 PM

      You can use SmartList -> Payroll Historical Transactions -> Check Information Current Year to get all of the deduction details. You can then export to Excel to format, total, etc.     

      ——————————
      Tommy Tastet
      President
      Diamond Software
      Covington LA
      ————————————————————————-

    DSC Communities replied 7 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Desperate for payroll report help’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!