Previous Year's Employee Hours Missing

Question

Hello, I've been working on a custom export where I need a list of employees that have worked over 500 hours for 2019. While testing, I run the report in my current year company and everything is great. I go back to my 2019 company file to run the custom export and what I get is random employees with hours such as 4.12487e. I check in Maintain Employees>choose an employee>Totals and all I get is 0 for all hours except for those random employees, which show 4.1e under Regular hours. 
 How do I fix this?

Vince Settipane · Accepted Answer

The way to tell is to LOGIN to the Company, If its not converted, it will ask to convert. (or should ask) 
 If you are connecting via ODBC in Excel / Access without converting, I would suspect you may see garbage data 
 Also, see about updating the DSN - see the program in the Sage BusinessWorks (start menu) 
 Only a few idea's about the data weirdness 
 Otherwise contact support

Coleen Graber · Answer

I am not sure what could be causing those results for your custom report. To troubleshoot that further, I would also recommend opening a case with a technical support analyst. 
 But if you are looking for a report to give you employee hours you can go to Employee Hours List from PR, Reports, Employee Reports, Employee Lists, Employee Hours List. Although this report may run slow, so just be patient with it, it is a useful report. 
 You can call reviewed This article from our Knowledge base at SageKB.com How to get a list or report of total hours worked by employee (26646) 
 Sincerely, 
 Coleen

Sage BusinessWorks

Previous Year's Employee Hours Missing

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING