AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Timecard reports/qu...
 
Notifications
Clear all

Timecard reports/queries  

    Last Post
RSS

mjcoman
Posts: 43
 mjcoman
April 17, 2019 11:54 am
(@mjcoman)
21-50 Posts
Joined: 9 months ago

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.  

Leslie Alt liked
Topic Tags
timecard query report
6 Replies
Leslie Alt
Posts: 3
 Leslie Alt
May 3, 2019 2:05 pm
(@leslie-alt)
Member
Joined: 3 years ago

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. 

Reply
Tim Rodman
Posts: 2519
 Tim Rodman     ★★ All-Star ★★
May 8, 2019 9:57 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

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
Reply
Leslie Alt
Posts: 3
 Leslie Alt
May 9, 2019 12:08 pm
(@leslie-alt)
Member
Joined: 3 years ago

The report is nice, but I'm trying to build the GI based on this https://feedback.acumatica.com/ideas/ACU-I-1482

Reply
Tim Rodman
Posts: 2519
 Tim Rodman     ★★ All-Star ★★
July 16, 2019 12:44 am
(@timrodman)
Over 200 Posts
Joined: 5 years ago

What about something like this?

Reply
Tricia Carlson
Posts: 1
 Tricia Carlson
November 9, 2020 3:16 pm
(@tricia-carlson)
1 Post 🙂
Joined: 4 months ago

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?

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2519
January 24, 2021 2:37 am
Reply toTricia CarlsonTricia Carlson

@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.

Reply
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Inventory Ageing Report
    1 month ago
  • Business Events with GI to Excel without creating a new report
    4 months ago
  • Time Zone Issue
    6 months ago
  • General Ledger Detail report showing all transactions for a period
    8 months ago
  • Adding custom reports to screens
    8 months ago
Topic Tags:  timecard (2), query (1), report (4),
  Forum Statistics
11 Forums
1,707 Topics
7,873 Posts
11 Online
1,159 Members

Latest Post: GI with customer and customer location Our newest member: mpryor@vyapay.com Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×