ERP Software Logo1

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

The Resource Group

Microsoft Dynamics GP Tip: How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account


Email | Print

Many of you may have already heard about all of the cool new features of Microsoft Dynamics GP 2013 R2. One feature that I really like is the ability to log in to Microsoft Dynamics GP with only your Windows password. The one caveat is that you can only do this through the Microsoft Dynamics GP Web Client, but even so, it’s a really cool feature. So how do you do it? In Microsoft Dynamics GP you are still able to create a user the way you normally do but with the changes to Microsoft Dynamics GP 2013 R2, there are now two tabs on the User Setup Window.

image 1 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 1 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

The first tab, SQL Server Account, is what you are currently used to. This will create the SQL login for the user to be able to login through the Microsoft Dynamics GP Desktop Client. On the Windows Account tab, you are presented with only one field, Windows Account.

image 2 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 2 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Once you hit the lookup window, you can enter the Windows account name.

image 3 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 3 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Note: You may expect the binoculars icon to open an Active Directory search like the one below, but this is not the case. Once you hit the icon, it will verify that what was typed in is a valid account, sort of like the “Check Names” button does in other applications.

image 4 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 4 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

To find the account you want, type in the account name and hit tab or the binoculars icon. Don’t worry, if you have multiple accounts with similar names, a dropdown of the possible values is displayed. Select the name you want and click OK.

image 5 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 5 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Once the account is selected, the Windows Account field will show the user’s name. This information is actually pulled Active Directory and corresponds to the Display Name listed in Active Directory.

image 6 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 6 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

I don’t like this. I want to know what the Windows account is in “DOMAIN\USERNAME” format (technically called the down-level logon name) to make sure I have the right one mapped. I decided to take a look at the User Master table (SY01400) on the SQL server to see if I could find it there. To my surprise, I was only able to find the GUID of the Windows Account under the ADObjectGuid field.

image 7 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 7 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

This is very strange and even less helpful than a display name if you’re trying to verify that the Windows account associated to the SQL login is correct. To get past this problem I created a SQL script that will query active directory to resolve the GUID to the account format I want. In order to do this, you first need to create a linked server that will be used to query Active Directory. As you can see below, “ADSI” is the name that I gave the linked server.

image 8 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 8 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Next, you need  to specify what account credentials will be used during authentication when querying Active Directory. You have two choices. You can either use the current credentials that were used to log in to SQL Server Management Studio (if you logged in with Windows Authentication), or you can specify the user name and password. I have provided both scripts, but you only need one.

image 9 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 9 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Next, you run the following SQL script to display the GP login name and the corresponding domain account for that login.

image 10 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 10 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Here’s what the results look like. Now that’s exactly what I was looking for!

image 11 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 11 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

If you want to remove the linked server for security reasons, run the following script.

image 12 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

image 12 - How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account

Although the Microsoft Dynamics GP Web Client has the ability to map GP user to a Windows account, I think there are at least two features that are missing: an Active Directory lookup window when selecting the user, and the down-level logon name to be displayed on the Windows Account tab of the User Setup window. For now, I have my SQL script, which also gives me all of the accounts in one query result, so I’m not complaining.

 

For more information about the new features of Microsoft Dynamics GP 2013 R2, contact a partner like The Resource Group.

by The Resource Group

2 Responses to “Microsoft Dynamics GP Tip: How to Resolve the Active Directory GUID of a GP Web Client Enabled User Account”

  1. james says:

    Hi I would love to get a copy of your code above as this we have hit this exact issue.

  2. Santiago Lopez says:

    I have a problem with Web Client and i hope that you can help me, in my AD i have for example two users

    [email protected] down-level logon name DOMAIN\bill_123
    [email protected] down-level logon name netbios DOMAIN\bill_456

    none of these users can connect to the web client, so, i try to edit one user.

    [email protected] down-level logon name DOMAIN\bill

    this user connects successfully

    So, user logon name and down-level logon must be the same?, this is mandatory? there any way to change this?