web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

How to delete/obsolete/deactivate operations resources

(6) ShareShare
ReportReport
Posted on by 18
Dear all,
 
Did anyone come across a good solution to delete/obsolete/deactivate operations resources that are not required anymore? 
 
When trying to use the delete button, there is always something dependent (e.g. Production route) that prevents deletion.
 
Thanks
Florian
I have the same question (0)
  • Suggested answer
    Danny Bilodeau Profile Picture
    4,934 Super User 2026 Season 1 on at
    Hi Florian,
    I suspect that you already looked at Operations > Relations to pinpoint which routes may be linked to you obsolete resource? 
     
     
  • FH-24101032-0 Profile Picture
    18 on at
    Hi Danny,
     
    Thank you for your response!
     
    I did look at Operations>Relations and according to it, there are no routes linked to my obsolete resource.
     
    When trying to delete a certain resource, I'm getting following message:
    Resources cannot be deleted while dependent Production route exist. Delete dependent Production route and try again.
     
    When I open the production routes, all I can find are in works orders that are in status "Ended". I anyway tried to delete them through Excel AddIn, but that gave me following error message:
     
    Error Publishing Row

    Details:
    The deletion of a row in data set ProductionOrderRouteOperations was not published. Error message: 'Delete failed for table row of type 'ProdProductionOrderRouteOperationEntity'. Infolog: Info: Cannot delete a record in Resource requirement set (WrkCtrActivityRequirementSet).
    An update conflict occurred due to another user process deleting the record or changing one or more fields in the record..'
     
    That's where I'm currently stuck at, and I'm also not sure if I actually should delete the data in WrkCtrActivityRequirementSet or in the production routes.
     
    Would you know of any setup that would allow me to set a resource to obsolete or deactivated without deleting it?
     
    Thanks and BR
    Florian
  • Verified answer
    Danny Bilodeau Profile Picture
    4,934 Super User 2026 Season 1 on at
    Hi Florian,
    Completely overlooked that old routes copied to Production orders would interfere.  You would have to delete the old production orders that use an obsolete resource that you'd like to remove.  There are obviously some downside such as loss of history or traceability, so someone would need to weigh the importance of keeping there records against the need to remove obsolete resources. 
     
    If you have access to a copy of Production Environment, I suggest that you test this and assess just how far back you would need to go to be able to remove the obsolete resources.
     
    Go to Production Control>Periodic Tasks > Clean-Up >Production orders clean-up.  You see that there is no query beyond the <Ended before> date field to limit which production orders get deleted.
     
     
     
     
    Not sure of the reason to deactivate the resource, but alternatives to deleting production orders could be a combination of these:
    1) Change the description to highlight that they are Obsolete ("Obs-Coating", "Coating-No longer use", "ZZ-Coating")
    2) If its a Resources of Human resource type, terminate the Worker in HR module and delete the worker assignment from the resource.
    3) Depending on mechanism for resource assignment, remove anything that scheduling engine would use:
    - Remove Resource from any Resource groups
    - Remove any calendar assignment or assign to a Calendar that has not open days/hours
    - Change Efficiency percentage to 0
    - Remove any Capabilities (in FastTab) taht could be use to assign job 
     
    There might be other ideas out there...
     
     
  • FH-24101032-0 Profile Picture
    18 on at
    Hi Danny,
     
    Thank you for your detailed suggestions!
     
    I was hoping for a toggle or something similar that would prevent a resource from being used but it sounds like something like that is not available. We are inconsistently using your suggestion 1) Change the description to highlight that they are Obsolete ("Obs-Coating", "Coating-No longer use", "ZZ-Coating")
    so I will propose to my teams to standardize this approach so it can be used in filters etc.
     
    BR
    Florian
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 296

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 234 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 145 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans