Hours worked report

  • Hours worked report

    Posted by DSC Communities on March 8, 2017 at 11:18 am
    • Jackie Miller

      Member

      March 8, 2017 at 11:18 AM

      I am in need of an EASY way to get YTD hours for each employee?  We are going to have to start reporting this info to our 401k plan each pay period.  I know the Employee Wage and Hour report does it, but I’m hoping there is some way to get something that will just give us name, ID #, & YTD hours; the Wage & Hour report lists & breaks out all the pay codes individually….that’s a lot of data to sift through.  We are hoping for something that we can just copy &  paste every pay day. 

      Or is there a way to create an edited version the Wage and Hour report to just give totals?

      Any suggestions would be greatly appreciated!!   Thanks

      ——————————
      Jackie Miller
      HR/Payroll Mgr.
      Transit Management of Alexandria, Inc.
      Alexandria VA
      ——————————

    • Terry Heley

      Member

      March 8, 2017 at 2:40 PM

      Hi Jackie, what I did was create a quick view that sums the hours in the UPR30301 table which is our summary table by month for all pay codes
      Where I have TWO, put your company DB and run this in SQL (1 time to do)
      Once the view is created, we can create a Smartlist Designer report from that view.
      Attached is my ACA doc that as steps to do this from other views
      In this case use the name hours like I have below or whatever you call it.

      USE [TWO]

      GO

      SET ANSI_NULLS ON

      GO

      SET QUOTED_IDENTIFIER ON

      GO

      CREATE VIEW [dbo].[hours]

      AS

      select EMPLOYID, SUM(MTDHOURS_1+MTDHOURS_2+MTDHOURS_3+MTDHOURS_4+ MTDHOURS_5 + MTDHOURS_6 + MTDHOURS_7 + MTDHOURS_8 + MTDHOURS_9 + MTDHOURS_10 + MTDHOURS_11 + MTDHOURS_12) as YTDHOURS

      FROM dbo.upr30301

      where PYRLRTYP=‘1’ and YEAR1=‘2017’

      group by EMPLOYID

      select * From UPR30301

      This is a basic dump of data, you can add formatting or dump to excel too and the view will be in your smartlist.

      ——————————
      Terry Heley
      HR/PR expert
      Microsoft
      west fargo ND
      ——————————
      ——————————————-

    • Terry Heley

      Member

      March 8, 2017 at 2:40 PM

      ——————————
      Terry Heley
      HR/PR expert
      Microsoft
      west fargo ND
      ——————————
      ——————————————-

    • Joni Finnell

      Member

      March 9, 2017 at 4:46 PM

      Thanks Terry! This is awesome!

      ——————————
      Joni Finnell
      Project Accountant/GP Troubleshooter
      Consumer Support Services, Inc.
      Newark OH
      ——————————
      ——————————————-

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

Sorry, there were no replies found.

The discussion ‘Hours worked report’ 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!