Timecard reports/queries - Everything Else https://www.augforums.com/forums/everything-else/timecard-reports-queries/ Acumatica User Group Forums en-US Wed, 17 Jun 2026 01:31:57 +0000 wpForo 60 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-10905 Wed, 20 Sep 2023 15:58:37 +0000 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.

]]> Everything Else June Henderson https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-10905 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-8141 Sun, 24 Jan 2021 07:37:41 +0000 CONDITIONS tab into the Join conditions to get the employee to stay visible.]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-8141 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-7787 Mon, 09 Nov 2020 20:16:25 +0000 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?

]]> Everything Else Tricia Carlson https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-7787 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4649 Tue, 16 Jul 2019 04:44:35 +0000 What about something like this?

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4649 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4219 Thu, 09 May 2019 16:08:30 +0000 The report is nice, but I'm trying to build the GI based on this https://feedback.acumatica.com/ideas/ACU-I-1482

]]> Everything Else Leslie Alt https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4219 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4213 Thu, 09 May 2019 01:57:00 +0000 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.

TimecardReport.rpx

TimecardReportSubreportSummary.rpx

TimecardReportSubreportTimeSummary.rpx

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4213 RE: Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4182 Fri, 03 May 2019 18:05:15 +0000 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. 

]]> Everything Else Leslie Alt https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4182 Timecard reports/queries https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4070 Wed, 17 Apr 2019 15:54:38 +0000 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.  

]]> Everything Else mjcoman https://www.augforums.com/forums/everything-else/timecard-reports-queries/#post-4070