I am working in Trial environment. In sample data the leave and absence Unit is Hours. I want to change this to Days since the company I am working for is following leave plans in days. In order to change the unit we need to remove everything in leave and absence entities (more details shared by Nicu in his post Here). So, I removed everything in the same order and data is deleted successfully but still I cannot change unit type.On further digging I found out that there are couple of Time off requests in COMPLETED status. But there is no option to delete these records. Can you help me how I can delete these records so I could finally be able to change unit? As you can see below there is no Delete option. I also tried to cancel these request but no cancel option available too. Please help!!
Hi QianQW,
I deleted all records in LeaveAndAbsenceRequest entity in CDS but Completed TimeOffRequests are still present in HR. This is such a nightmare. Thanks for your support though!
Hi CRMDeveloper1,
Unfortunately, I don't have the environment right now, so I can't test it step by step.
But logically, firstly delete the approved time off in the CDS entity and check if the approved line still exists. Then you can change the status to cancelled in the LeaveRequest entity and publish the entity. Finally, you can delete the request of cancelled status.
Try it and check the status again. If it still doesn't work, please create a ticket to Microsoft.
I am sorry to ask but how exactly status can be changed indirectly?
Thanks.
You need to change the status in the entity first and then delete it. There is no option to directly cancel the complete records.
Yes already saw that but unable to carry out step-2 which is "Update status to cancelled of the corresponding leave request line in LeaveRequest entity. Publish the change". When I go to timeoff request view there is no option to cancel completed records!!
Try the steps provided by Agne.
community.dynamics.com/.../how-to-delete-completed-time-off-request
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 823 User Group Leader
André Arnaud de Cal... 673 Super User 2025 Season 2
Martin Dráb 491 Most Valuable Professional