Missing timesheet report & email function flagging timesheets when month starts on a weekend

(2) Share

Report

Posted on by Median

102

We have been facing an issue with our D365 f&O environment when a Month begins with a weekend a working timeperiod is generated which results in these periods giving a false indication of a missing timesheet. We have set saturday and sundays as "Closed for pickup" within the working time templates section (see below ) :

We then generated the timesheet periods within the Timesheet period types section with auto split week enabled. Unfortunately this leaves us with weekend periods being generated when a Month begins on a weekend. An example would be March 2025 (see below ) :

We have 1 timesheet period per legal entity and they are all identical, we have these timesheet periods set against our employees.

We work with a third party support who are MS gold partners but they are informing us this can't be fixed and MS or unwilling to assist with this when they have opened a ticket with them. The only fix is for them to build a customisation package (additional paid for service) to work around this problem.

Given this is an out of the box set of features and we hav no cusotmisations around timesheets or the missing timesheet functionality it seems wrong we need to add customisations to to make it work correctly. I can't help but think we have simply missed a setup step so any advice in relation to this would be much appreciated.

Thanks in advance

Median

Categories:

Dynamics 365 Finance

All responses (5)

Answers (1)

Suggested answer

Abhilash Warrier 831 on at

Like (0)

Report

Missing timesheet report & email function flagging timesheets when month starts on a weekend

Hi Median,

Could you please confirm the current status of timesheets posted by the employees.

If the timesheet is already posted by the employees, you won't be able to delete the timesheet period lines directly. You will require technical help from the partner & Microsoft to rectify the same.

Please follow below steps to proceed with the rectification-

1. Identify the records for which the timesheet entries that are posted for that specific period Week 9 (2) - Wk:1 01/03/2025 and 02/03/2025, use SQL query to get the accurate details/information as per the criteria.

2. Remove the timesheet period for workers

3. Remove periods from Show timesheet periods

4. Remove period from Periods

5. Once all the records are cleared, delete the period lines records from All Timesheet page.

6. Go to Periods, add the new period manually.

7. Update timesheet periods.

8. Update worker periods.

7. Try to generate the timesheet again for the following week.

This solution requires lots of testing, first start with individual entity and later you can do bulk correction. I have provided the solution based on the same experience with a client project. Thank You.
Suggested answer

Abhilash Warrier 831 on at

Like (0)

Report

Missing timesheet report & email function flagging timesheets when month starts on a weekend

Hi Median,

I have faced the same issue regarding the Timesheet period, and the bug was escalated to the Microsoft support team. Unfortunately, this was not fixed.

Workaround is to manually delete the wrong period lines and update it with correct records. You can use Excel Add-ins if the records are more.

It is advised to correct it as earliest as possible. If the employees post the timesheet wrongly, you will not be able to do correction manually and require SQL scripts for updating the records from the backend.

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.
Suggested answer

André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at

Like (0)

Report

Missing timesheet report & email function flagging timesheets when month starts on a weekend

Hi Median,

There is a public data entity for the worker periods. It is possible to use the Dynamics Connector in Excel, load the data, remove rows that you don't need and then publish the changes. This will be an option for a mass removal. You can use the Workbook designer in the Organization Administration menu to create the Excel sheet including the Dynamics Connector.
Median 102 on at

Like (0)

Report

Missing timesheet report & email function flagging timesheets when month starts on a weekend

Hi Andre

Thanks for responding.

This was an intial idea, but when we looked into this we get the below error when we try and delete a period in the Period Transactions :

If we try delete from the "Show timesheet periods" the option to delete is greyed out.

We have hundreds of employees so removing the period type from them all would be painful. Unforutnately the Accounts department have already generated all the timesheet periods for this finanicial year.

If there a way to delete these periods in this situation or is it a case of creating a new Period type, genating the periods and deleting the ones we dont want then manually assigning the period type to all the employees in that legal entity?

Thanks

Median
Verified answer

André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at

Like (0)

Report

Missing timesheet report & email function flagging timesheets when month starts on a weekend

Hi Median,

In other implementations, I suggested to delete this type of weekend periods from the timesheet periods and the worker periods after the generation of the periods. It will then skip the reporting for a missing timesheet.

No customization is required for this workaround.