Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Employee Life-To-Date Hours

Posted on by 3,954

Is there anywhere in GP to get life-to-date hours worked by employee?  I know we can print the Employee Wage and Hour report by date range but we'd like to see it in an Inquiry window.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Employee Life-To-Date Hours

    Not sure about an inquiry window but if you run this SQL statement SELECT * FROM UPR30301 it will you that information.  You might look that table up and only bring back the columns you need as SELECT * is a terrible thing to do I just used it as an example.  Then you build a SSRS report for it or SmartList item.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans