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.
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.
Online Members
