Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Human Capital Management
Lawson S3 HR/Payroll/Benefits
Point in Time Report
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5120
People Online:
Visitors:
238
Members:
0
Total:
238
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1357
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 HR/Payroll/Benefits
Point in Time Report
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Vandana
Basic Member
Posts: 4
8/22/2019 7:51 PM
Hi all, I recently joined a NGO in DC and we have Lawson S3. I am trying to find a report either within Lawson, or through Query add-ins that can give me point in time data. I need to look at salaries for all staff who were active from 1/1/17 to 12/31/18. I'd also like to include hours worked as a field if possible. Anybody have experience with this?
Ragu Raghavan
Veteran Member
Posts: 471
8/23/2019 12:50 PM
Not sure if there is a canned report.
The hours worked is fairly simple, just use the table PRTIME, SUM(HOURS) filtered by TR_DATE in the desired range summarized by employee.
The other is more complicated. You will need to use the table HRHISTORY (to see active status) and PRRATEHIST (to see salary) at any point in time based on EFFECTIVE_DATE. Don;t forget that the salary could have changed many times during the date range. Also, employee could have been termed/rehired and other change in status. You are probably looking for a custom report using 4GL/SQL/IPA or something.
Vandana
Basic Member
Posts: 4
8/28/2019 6:44 PM
Thanks Ragu! I got as far as setting up the PRTIME report - how can I adjust it so that it reads the total per employee on each line? Right now i'm seeing an exhaustive list for hours worked on each day for one employee, and then a total at the bottom.
Ragu Raghavan
Veteran Member
Posts: 471
8/28/2019 7:05 PM
Are you using Add-ins? Once the data is in excel, use the Subtotal function?
Vandana
Basic Member
Posts: 4
8/29/2019 2:16 PM
Hi, yes I'm in add ins and did try the subtotal within the Query wizard itself. The data only appeared for one employee, I am looking for total hours worked for all active staff in 2017 and 2018 (this is for the EEO-1 component 2 data requirement).
John Henley
Posts: 3352
8/29/2019 2:24 PM
If you're trying to do this for the new EEO-1 reporting requirement, Lawson/Infor has a new patch available that provides this capability.
Vandana
Basic Member
Posts: 4
8/29/2019 2:33 PM
Thanks John - they haven't released it for our environment yet
John Henley
Posts: 3352
8/29/2019 5:32 PM
which environment?
You are not authorized to post a reply.