PR260 Wage Query

Does anyone have a query to produce something similar to the PR260, wages only, but by pay code instead of by check description? I have tried to do it but my numbers do not match the PR260.

[Updated on 7/2/2015 1:34 PM]

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

unknown

Hi Steve, have you tried the PR270?

patrycja-szymanska

PR270 uses pay summary group description not the pay code or even the pay summary group code. When you create a csv file from the report the employee number is not on each line that there are pay summary descriptions.

sriman-shivakoti

Have you tried a HR65 query and run it via HR70 or HR170? You would need to select type = history and detail topic of PW. It is a little tricky to slect the dates to run it with so it doesn't take a long time. I leave it blank in HR65 and enter the range on HR170. OR............create in a third party tool.

cockrell

For ad hoc reporting, we use Add Ins for Excel. The Add Ins provides access to your entire S3 database through Excel. You can choose the fields you want from multiple tables, as long as they are related, and filter based on criteria such as pay code (i.e. you can pull all payroll data related to a single pay code). The data comes out looking much cleaner in an excel format than trying to export a system report and you do not experience the same missing employee number problem.

patrycja-szymanska

Hi, I'm actually using MS Access to build the query with - similar to doing it with Excel through Add-Ins. The issue I have is that I cannot get my query to exactly duplicate the wages by pay code that are reported on the PR260. Most employees Gross Wages are good but I have exceptions. So I was hoping someone may have done this already and knows better than I do how to link the table to exactly produce what is reported on the PR260.

denise-buggs

Have you tried linking the PRT-PCD-SEQ-NBR from PRTIME to PCD-SEQ-NBR from PRPAYCODE? you can get the pay code from PRPAYCODE, and have the hours and amount from PRTIME.

patrycja-szymanska

Yes, here is my query

SELECT EMPLOYEE.HM_ACCT_UNIT AS [Home AU],
PRTIME.EMPLOYEE AS [Emp Num],
Trim([last_name]) & ", " & Trim([first_name]) & " " & Trim([middle_name]) AS Name,
PRPAYCODE.PAY_CODE AS PayCode,
Sum(PRTIME.WAGE_AMOUNT) AS Amount INTO AuditorData
FROM ((PRTIME INNER JOIN PRPAYCODE ON PRTIME.PCD_SEQ_NBR = PRPAYCODE.SEQ_NBR)
INNER JOIN EMPLOYEE ON PRTIME.EMPLOYEE = EMPLOYEE.EMPLOYEE)
INNER JOIN PRCHECK ON PRTIME.CHECK_ID = PRCHECK.CHECK_ID
WHERE (((PRCHECK.CHECK_DATE) Between #7/1/2014# And #6/30/2015#))
GROUP BY EMPLOYEE.HM_ACCT_UNIT, PRTIME.EMPLOYEE, PRPAYCODE.PAY_CODE
ORDER BY EMPLOYEE.HM_ACCT_UNIT, PRTIME.EMPLOYEE, PRPAYCODE.PAY_CODE;

patrycja-szymanska

I figured it out, I was using the wrong table with PrCheck I should have used PayMaster. Now it balance to the PR260, PrCheck does not contain adjustments.

Copyright © 2025 Infor. All rights reserved.