The Licenses Remaining field shows an incorrect value in Personal Data Keeper

Method 1: Purchase additional licenses

Starting with Microsoft Dynamics GP 10.0 Service Pack 2 (SP2), the number of licenses in PDK is driven by the number of unique Employee IDs in Payroll. This value is not associated with company IDs. If there is a user who has the same Employee ID in two companies, PDK uses only one license for that user.

For example, you have the five following users set up in PDK.

Dylan Miller - Fabrikam (Employee ID: DYLAN)
Dylan Miller - Microsoft (Employee ID: DYLAN)

Molly Clark - Microsoft (Employee ID: MOLLY)

Jim Corbin - Fabrikam (Employee ID: JIM)
Jim Corbin - Microsoft (Employee ID: JIM)

Because there are only three unique Employee IDs among all the companies, PDK uses only three licenses for the three employees.

Prior to Microsoft Dynamics GP 10.0 SP2, the number of licenses in PDK was driven by the number of unique User IDs in PDK. This value is not associated with company IDs. If there is a user who has the same User ID in two companies, PDK uses only one license for that user.

For example, you have the five following users set up in PDK.

Dylan Miller - Fabrikam (Employee ID: DYLAN)
Dylan Miller - Microsoft (Employee ID: DYLAN)

Molly Clark - Microsoft (Employee ID: MOLLY)

Jim Corbin - Fabrikam (Employee ID: JIM)
Jim Corbin - Microsoft (Employee ID: JIMC)

In this case, there are four unique Employee IDs among all the companies. But because there are only three unique User IDs (Dylan Miller, Molly Clark, and Jim Corbin), PDK still uses only three licenses for the three employees.

If you have to purchase additional licenses to add PDK users, contact your local partner, or contact Microsoft Dynamics Sales Operations. To order licenses through Sales Operations, either use secure fax at (701) 281-7797, or visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

PartnersCustomers

Method 2: Verify the registration keys

To verify that the registration keys that are entered are correct, follow these steps:

1. In PDK, click to System on the Setup menu.
2. Enter your PDK system password when you are prompted.
   
3. Click Registration.
4. Verify that the correct Site Name value and PDK Registration Keys value are entered.
   
5. Click OK.

Method 3: Log in as the sa user

When you log in to PDK as the sa user, the number of employees who are marked as Inactive in Payroll are restored to the amount that is displayed in the Licenses Remaining field. This lets you create more active PDK users. If you log into PDK as a regular PDK user, those inactive employees are not restored to the license count.

For an accurate count of how many users can currently be created in PDK, log in to PDK by using the sa user and password.

Method 4: Delete the sa user from the license count

The sa user uses one of the PDK licenses if it is in the PDK40001 table as a user. You can find the sa user in the PDK User ID lookup. However, you cannot select it.

To regain this license for a different user, the sa user record must be removed from the license count. You can remove the sa user by running a SQL delete statement. To do this, follow these steps:

1. Open the Microsoft SQL Query Tool.
2. Select the DYNAMICS database.
3. Enter the following delete statement:
   
   
   DELETE PDK40001 WHERE USERID = 'sa'

After you run this statement to delete the sa user, you can add another user in PDK.

Method 5: Repair the registration table

If the Licenses Remaining field is blank, your registration table may be damaged. If this is the case, follow these steps to resolve this problem:

1. Note your PDK registration keys.
2. Have all users exit PDK.
3. Log in to Microsoft Dynamics GP as the sa user.
4. On the Microsoft Dynamics GP menu, point to Maintenance, and then click SQL.
5. In the Database list, click DYNAMICS.
6. In the Product list, click Project Accounting.
7. Click PDK Registration Master.
   
8. Click to select the Drop Table, Create Table, Drop Auto Procedure, and Create Auto Procedure check boxes.
9. Click Process.
10. In PDK, click to System on the Setup menu.
11. Enter your PDK system password when you are prompted.
12. Click Registration.
13. Enter the correct Site Name value and PDK Registration Keys value.
14. Click OK.