Skip to main content

Notifications

Announcements

No record found.

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

Monitoring the working hours of company employees

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

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans