Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Employee change role in company causes Duplicate SQL ID

Posted on by 22,647

We have a situation here where an employee who entered time via business portal and did not have access to GP client, has changed office roles and now needs access to GP client.

The standard convention is to use the Network ID (controlled by H/O) as the Business Portal login (have to) but that is then linked to the Employee ID in Canadian Payroll (not necessary to be the same as Network ID)

Situation here is that since the user was created to be a Business Portal User it appears that they are entered into SQL User list.  So, when I try to add that Network ID as the GP User ID and save from the Application (as sa of course) I get the message that the SQL Name already exists. 

I know we can use anything for the GP ID, however, that is going to be messy for someone that does not understand the flexibility of the GP to allow this.  The DB that I am working with is pretty fussy and I would l really like to make the Network User ID and the GP User ID and therefore the SQL User ID the same.

Is there a simple way to fix this so that I do not loose any data - this employee has BP / PDK and time entries in the system.  I can not loose data bottom line.

Thanks

*This post is locked for comments

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans