[Jackie Miller]

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]

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]

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

[Joni Finnell]

Thanks Terry! This is awesome!

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