Kronos - Do you want Excel with that Timekeeper?

Raymond Ney — Sep 13

Customers spend a lot of money implementing and/or upgrading Kronos, so it only makes sense to get as much out of it as possible. So, what else can we do with it? Do we total the data and put it in a spreadsheet? Is it better presented as on a Report, in a Genie, or as a CSV file? What information is going to be beneficial to extract; what’s better to put in an email? What else can we do with Genies?

Read More

Kronos Timekeeper QuickTip - Searching for Employees Using QuickFind

Dwain Lambrigger — Apr 13

Searching for employees using the wrong genie in Workforce Timekeeper can be a frustrating experience.  All the scrolling up and down to find that specific individual.  It's one of those littly things that can drive you nuts, like traffic, that dumb song you can't get out of your head, or when your pen runs out of ink.  You know what I mean, those little irritations.  Kronos has developed the QuickFind genie to help users who experience this challenge. 

Read More

EXCELlent Reporting with Kronos Workforce Central

Jeffry Charnow — Jan 13

Did you know that some reports are formatted especially for Excel?  By this I mean that they are formatted in rows and columns that can transfer information to a spreadsheet easily.  If you cut and paste Kronos Workforce Central report information into excel with the normal reports, you have to do an awful lot of clean up to make the columns work.

Read More

Kronos Hyperfinds - Something "sweet" within WFC Suite

Raymond Ney — Jul 11


Most of us have heard the saying "Where do you want to go today?” When authoring Hyperfind™ queries in Kronos Workforce Central™, I envision a revised saying: "What do you want to view tomorrow?"  After designing them, that will allow your Workforce Central managers to get the sweet out of Reports and Genies using HFQs (Hyperfind Queries).

Read More

Best Practice, Kronos Workforce Central and the DCAA

Jeff Millard — Sep 10

Years ago when SOX404 standards became mandatory for public companies it was a common statement from IT, Finance and other managers—“Shouldn’t we be doing most of this stuff anyway?”   Sure the cost of moving from where we were to a more transparent, 404 compliant infrastructures was initially high but

Read More

The Kronos Transaction Assistant (cont)

Myron Oakes — Sep 10

If you have ever weeped or gnashed your teeth over the Kronos Transaction Assistant, then perhaps we can assist with at least the weeping part (see your dentist about the gnashing). There are two Kronos database tables that contain all the information that you need to know about errors that are displayed on Transaction assistant. These tables are FAILEDXMLDATA and FAILEDXMLBODY. And here’s a query that will pull all person-level data out:

select distinct a.failedxmldataid "Error ID",c.personnum "Empl ID",

       c.personfullname   "Employee Name",

       c.employmentstatus "Kronos Status",

       convert(char,c.employmentstatusdt,101) "Kronos Status Dt",

       convert(char,c.companyhiredtm,101) "Kronos Hire Dt",

       convert(char,b.updatedtm,120) "Error Dt/Time",b.errorcode "Err Code",

       substring(b.sourcedetails,1,25) "Import Source",

       rtrim(d.fieldname) "Field Name",

       substring(d.internalmesgtxt,charindex('The person',d.internalmesgtxt),190) "Error Message"

from failedxmlbody  a,

     failedxmldata  b,

     vp_employeev42 c,

     importresult   d

where a.failedxmldataid = b.failedxmldataid

  and substring(a.xmlreqbody,charindex('<PersonNumber>',a.xmlreqbody)+14,07)

      = c.personnum

  and charindex('<PersonNumber>',a.xmlreqbody) > 0

  and a.xmlreqkey = 0

  and b.importresultid = d.importresultid

  and b.updatedtm >= '@@Date to Display@@' + ' ' + '**Start Time (hh:mm)**' + ':00'

  and b.updatedtm <= '@@Date to Display@@' + ' ' + '**End Time (hh:mm)**' + ':59.999'

  order by c.personfullname

Read More

Kronos Transaction Assistant - The smartest dumb application

Myron Oakes — Sep 10

I like Kronos Workforce Central/ADP eTime. I really do – it’s a good system (though not the only good one out there), and I have many satisfied Kronos customers who share my viewpoint. It can do most anything that’s needed, can interface to most anything that it needs to interface to, derives payroll information accurately, handles exceptions well, and generally meets the business needs of my customers.

Read More

Most companies use less than 50% of Kronos workforce management software functionality. How much utilization do you have?

Would you benefit from a process that helps your organization verify your Kronos configuration and associated processes to ensure you are making the most of your Kronos application?

Learn more or download The Case for Gap Analysis.

file_downloadThe Case for Gap Analysis

Companies invest substantial labor and financial resources to deploy workforce management software Why do so many projects fail?

Do you know the best practices - and the pitfalls to watch for - to deliver a successful project?

Our white paper, Successful WFM Strategies, explores effective steps you can take to deliver a successful project.

file_downloadImplementation Strategies

Are you thinking about upgrading? There are different ways to approach an upgrade. Learn more, or download our Ready to Upgrade checklist, to explore your options.

file_downloadReady to Upgrade?

Subscribe to Email Updates


Posts by Topic

see all