Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Monitoring the working hours of company employees

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I'm new to working with Dynamics 365 and new to the forum, hope I ask in the right place.

I have a table containing all the employees of the company, and another table containing the projects we are working on.
Each employee can work on several projects, and each project can have several employees.
Each employee writes in their own Excel table a date and how many hours they worked on each project. For example:

Date 1001 1002
21/12/20 4 5
22/12/20 8 0

* 1001 and 1002 are projects, and the numbers below are working hours.


I want to upload the tables at the end of each month to the dynamics system.
What I want to happen:


1. All the hours that each employee worked will appear under his information so that it will be possible to know how many hours he worked on a particular day/month.
2. All working hours done for each project will appear under the project information.
This means that I can view a report with the total hours that employees worked on the project in a given period.

I would love a general explanation of how to approach this matter or even the guides who will help me understand the matter.

Thank you!

  • Abdulaziz Albloshi Profile Picture
    Abdulaziz Albloshi 365 on at
    RE: Monitoring the working hours of company employees

    There was a standard report in AX 2012 for this. I am not sure if it exist in D365. Check this link docs.microsoft.com/.../users-online-time-report-sysusersonline.

    If not available, you can customize one by using online users data.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Monitoring the working hours of company employees

    Hi Ron,

    I do not know exactly what is meant by "products".

    Until now I have used power apps to create tables of employees and projects.

    In addition, I plan to build a canvas app / model-driven app through which all the data can be viewed.

    The most important thing for me right now is the matter of uploading the Excel spreadsheet and extracting the data from it.

    Is there a tool I can customize to do this?

    Thank you!

  • Suggested answer
    darcnus Profile Picture
    darcnus 235 on at
    RE: Monitoring the working hours of company employees

    What Dynamics 365 product are you using?

    The tracking functionality you want is most likely already there, but your input method (uploading a spreadsheet) would need to be custom-designed.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans