Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

DateInactivated in SY01400 not populating when User Inactivated

Posted on by Microsoft Employee

The controller would like to be able to verify the dates users are inactivated in the system so they were going to do a SQL query on SY01400. However, the DateInactivated field is not changing when the user is inactivated.

They are on GP 2015 R2 so I would expect it to work at this point.

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DateInactivated in SY01400 not populating when User Inactivated

    Hi Justin, are there any updates on this issue?

  • Verified answer
    RE: DateInactivated in SY01400 not populating when User Inactivated

    Hello Nola and everyone,

    Thank you very much for using the Microsoft Dynamics GP Forums!

    I wanted to follow up and let everyone know that we are now aware of this issue.

    Currently there is no estimated release for a fix for this issue due to its recent discovery, however the Connect suggestion will surely provide this issue greater visibility.

    Please let me know if you have any additional questions on this.

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: DateInactivated in SY01400 not populating when User Inactivated

    I can confirm that it doesn't work both in GP2013R2 & GP2015R2... I've opened a ticket in Connect to report the issue. You can vote for it here : connect.microsoft.com/.../2517060

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DateInactivated in SY01400 not populating when User Inactivated

    I also get the same results as you do.  You could use the modify date if needed.

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: DateInactivated in SY01400 not populating when User Inactivated

    Don't have an answer for you but I tested this on GP 2015 R2 and am getting the same results where it does not update if the user is inactivated.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans