By using this website, you agree to our Terms of Use (click here)
Has any written a missing timecard report/query yet? I thought I had one figured out but the left join is not acting correctly. I want to pull all active employees, put the timecard ID beside the employee's name, missing id, missing timecard. I thought it would be easy.
I am trying to build the same right now but am also struggling. I can get all time card records to pull together, but not the list of employees with missing ID etc.
Not sure if this helps, but I put together this report a few years ago. The first one is the report, but you need the 2nd and 3rd reports since they are subreports in the main report.
TimecardReportSubreportSummary.rpx
TimecardReportSubreportTimeSummary.rpx
The report is nice, but I'm trying to build the GI based on this https://feedback.acumatica.com/ideas/ACU-I-1482
What about something like this?
I have created the above GI. The issue I am having is that once a timecard is created for an employee they fall off of the report.
Example - Week 2020-29 entered timecards for employees AJones and DSmith. When I run this report for week 29 it shows their info along with all the other employees that are missing timecards. When I then run this for week 30 these 2 employees are not on the report at all even though they do not have timecards created for this week.
Has anyone been able to get this to work correctly?
@tricia-carlson Ah, good point. I think you'd need to move what's on the CONDITIONS tab into the Join conditions to get the employee to stay visible.
I am trying to create a report for missing timecards for any weeks prior to the current week. I found this post from three years ago, was anyone sucessfull in doing this? I have created the GI, but not getting the results that I want. My plan is to use the timecard reports that Tim Rodman shares, set up a business event to generate the report on a daily basis and then create an email template to email each employee on the report a reminder to complete their timecards.