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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to handle ex-emplo...
Microsoft Dynamics AX (Archived)

How to handle ex-employees

(0) ShareShare
ReportReport
Posted on by Trashman01 5

First off, I do not work with or develop in AX. I am simply trying to find an answer for a problem we are currently facing and not getting the info needed from those who do work with AX...

As far as I know, employees are never deleted in our system. Their accounts and records are maintained indefinitely. This is starting to cause an issue with new employees not having unique active directory IDs. Our AD users are retained for 120 days from their disabled date, but each time we get a new employee with a common name we have to accommodate for the the AX user history and give them a non-standard username. 

I have tried my best to search for workarounds, with no luck. Is there a way to rename/re-associate a terminated user in AX? We need to retain their account/sales history but want to un-link their userID to the old alias. For example, John Smith hasn't worked here in 4 years and we've hired several other John Smith's since then, but have been forced to create their AD user as JSmith2 or Jsmith3 etc. in order to create a unique AX user ID. Is there a way to remove the account association to the users old SID? What is the best way to convert or change Ex-Employees in AX while maintaining their history in AX but freeing up the user ID so we can keep our active user accounts naming convention standardized? 

*This post is locked for comments

I have the same question (0)
  • Trashman01 Profile Picture
    Trashman01 5 on at
    RE: How to handle ex-employees

    Thank you for that, I will test this out. Yes, the naming convention needs to be changed. But other than firstname.lastname I'm not sure what else would work. Firstname.lastname has been an issue as we have a large user base with very long names.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: How to handle ex-employees

    You should be able to change the networkAlias (and SID) field of UserInfo table with an x++ job. Or if this is a frequent use case for you, you can make similar logic accessible via the UI.

    This job would update the userInfo record for JSmith1.

    static void Job1(Args _args)
{
    userInfo userInfo;
    
    ttsBegin;
    select firstOnly forUpdate userInfo
        where userInfo.networkAlias == 'JSmith1';
    
    userInfo.networkAlias = "JSmith1Old";
    userInfo.sid = "1234567890";
    userInfo.update();
    
    ttsCommit;
}


    Remember that you should not change the AX user id (UserInfo.id). 

    I don't have any real information, but is it really so common to recycle the unique AD user names to new employees? Maybe your AD user id naming convention could be revised to produce duplicates less often? I would guess AX is not the only place where this can cause headache.

  • Trashman01 Profile Picture
    Trashman01 5 on at
    RE: How to handle ex-employees

    This is the correct forum for this question right? I'm not sure where else to ask this. Can anyone point me to an article/blog on breaking the link between AD and AX for ex-employees? Surely there's a termination process that keeps us from cluttering up the system with non-existing AD user IDs? If the AD alias is the master record for linking the systems, then there has to be a way to re-associate the users in AX if that AD user ID or SID no longer exists on the domain.

    Thanks!

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans