I am trying to figure out a report that will show all missing timecards for employees. I was able to run a query to find anything that does not have a status of "P or X" but that only applies if they created a timecard for that week ending date. How do I capture all active employees who have not created a time card for a given date range or who has not posted yet?
Thank you in advance!
*This post is locked for comments
There is a Timecard Status Screen (TM.TCS.00) that does this very well. We copy and paste the screen into excel to create a report.
Thank you this report works great and shows what I need. Is there a way to bringing to see what pe_dates would be missing? Say I isolated my query to 4 week ending dates and it would look at those 4 dates to see if there is something missing.
Regards,
Frank
There is no such le_status for finding the missing time cards available in Dynamics SL.
In Process (I) – The timecard is available for maintenance. It cannot be approved or posted with this status.
Timesheet (T) – The timecard was created by the posting process in Project Timesheet Entry (TM.PTE.00). Timecard Entry (TM.TCE.00) treats it as if it were any in-process timecard. It may be modified and its status may be changed to Completed.
Completed (C) – Timecard Entry (TM.TCE.00) has been completed and the timecard now awaits approval. With this status, the document can no longer be maintained.
Approved (A) – The timecard has been reviewed and approved in Business Portal and will be posted by Time Review & Approval (TM.TRA.00) after clicking Begin Processing.
Edit (E) – Once a completed timecard has been saved, its status can be set to Edit to allow supervisors and managers to open the document in order to add bonus or flat pay. After setting status to Edit, click Save in order to make the timecard fields available for maintenance. When done, set status to Completed and click Save in order to queue the document for approval and posting.
Rejected (R) – The timecard has been rejected in Time Review & Approval (TM.TRA.00). It may now be corrected by the employee in Timecard Entry (TM.TCE.00). When done, the employee should change the status back to Completed to be resubmitted for another review.
Posted (P) – The timecard has been posted and can no longer be maintained. Revisions can be made via a button in Timecard Correction (TM.COR.00) using the procedure described for the correction process.
Corrected (X) – The original posted timecard has been revised and the correcting timecard posted. The original document can no longer be viewed or maintained.
These are the time card status available in Dynamics SL. The query that i have given on previous post was used to find the active employees who does not enter time cards in Dynamics SL .
Hope this explains
Hi Perumalsamy,
Thank you for your response. Which one of the le_status would represent a missing timecard? This is where I am getting confused.
Regards,
Frank
Hello fklioside,
There is no such report available in Dynamics SL. You have to develop the brand new report to find out the active employees who does not enter the Time card for the particular week ending Date.
Below is the sample query to find out the employees who does not enter time card for particular week ending date.
Select p.employee from PJEMPLOY p where p.emp_status = 'A'
Except
select b.employee from pjlabdet a join pjlabhdr b on a.docnbr = b.docnbr where b.le_status in ('P','C','A','I','X') and b.pe_date = 'XXXX-XX-XX'
Here XXXX-XX-XX is year-month-Day(YYYY-MM-DD)
Hope this explains.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (