Employee Hours Report

Hello,

Does anyone know of a report or have a query that will show me hours and associated wages by person, by pay date. I am putting together info for a tax credit and the PR260 and the PR262 create multiple lines per employee. This is a company with over 5000 employees so making manual adjustments to an excel file would be way too time consuming. I need every pay code/hours for each employee for each pay date.

Company EE ID Full Name Pay Code Item Item Hours Item Wages

Thank you for your time!

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Accepted answers

All comments

tdwaters

I have to do this also. I am pulling the information form the PR transaction file. It will print a separate line for each pay code for the week.

gwilson

Thanks! Are you pulling this as a query?

tdwaters

Yes. We use excel with the ODBC connection to pull this information.

darcey-timek

Do you use MS Access?

tdwaters

I have not used access. Is there a better way to get this information?

unknown

H GZ, run a query over PRTIME for wages and hours. PRTIME has the period begin and end dates. If you need the check date, join to PAYMASTR on CHECK_ID. Join to EMPLOYEE to get the the name.

gwilson

Thanks!

gwilson

Great..thanks!

gwilson

Would you explain how to join the query fields please? I've needed that for quite some time!

tdwaters

You find common fields in each file to tie the files together

Copyright © 2025 Infor. All rights reserved.