Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Report to calculate PTO, Sick leave hours for taken by an employee
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LindseyC
Past 24 Hours:
0
Prev. 24 Hours:
3
Overall:
5183
People Online:
Visitors:
169
Members:
0
Total:
169
Online Now:
New Topics
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
1348
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 Business Intelligence/Reporting/Crystal
Report to calculate PTO, Sick leave hours for taken by an employee
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
5/14/2010 2:27 PM
I am trying to create a report for all employees for their PTO hours, sick leave etc but for a month.
Since this report should show me all the pto time taken by the employee for a months and all payroll tables store hours by pay period end date I would like to find out if anybody has created anything like this.
This would mean that the pay period end date may fall on the first of the next month but have hours that belonged to the last 2 weeks of the previous month. Is there a formula that is generic that can be used to calculate this.
tia.
mark.cook
Veteran Member
Posts: 444
5/14/2010 4:14 PM
Ruma,
Are you looking just for the PTO transactions and balances? We run ours out of LP and show the PTO Hrs, Major Illness, and any PTO cash in elected. These transactions show on our report and keep a running balance of what was accrued and what was used. We show the last 6 months of data and employees access this via a dashboard tied to the ESS security role. Is this similar to what your looking for?
Ruma Malhotra
Veteran Member
Posts: 412
5/14/2010 5:23 PM
Hi Mark,
Actually I am trying to create this query out of crystal going to the lawson tables. The reason I cannot use a LP report or a payroll report is I am trying to create a smart note out of this query.
My goal is to give our AP department manager a tool for evaluating employee performances and the way she does this is she looks at the no. of invoices keyed in by an operator. Then she looks at invoices that have not been paid higher than the last 31 days and does a comparison for the number of PTO days, sick leaves etc an AP clerk takes and then finally she gives her employees a performance rating. I am helping her by creating this whole peice setup. I have setup the first 2 peices but struggling with this peice.
Thanks for your help anyways.
You are not authorized to post a reply.