Ora_Techie
asked on
How to find Licensing Information for Microsoft Dynamics GP 9.0
Dear Gurus,
We have Microsoft Dynamics GP (Version 9.00.0114) used by HR department for keeping record of employees. We have 1000 employees license; while trying to create a new employee, we are getting the following error:
You have reached your maximum number of registered employees. You can not add new employees into the system.
And when i see Help > About Microsoft Dynamics, it show me following:
Session Information
Current Total Registered
........................
.......................
Employees 1000 1000
My question is: From where (table, file) it is checking total number of employees created so far (i am pretty much sure we don't have 1000 employees)?
Thanks and regards,
Muhammad Riaz
We have Microsoft Dynamics GP (Version 9.00.0114) used by HR department for keeping record of employees. We have 1000 employees license; while trying to create a new employee, we are getting the following error:
You have reached your maximum number of registered employees. You can not add new employees into the system.
And when i see Help > About Microsoft Dynamics, it show me following:
Session Information
Current Total Registered
........................
.......................
Employees 1000 1000
My question is: From where (table, file) it is checking total number of employees created so far (i am pretty much sure we don't have 1000 employees)?
Thanks and regards,
Muhammad Riaz
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
@@opster
Thanks for your help.
What is the purpose of table UPR41600? When i query this, i get :
CMPANYID Count1 DEX_ROW_ID
1 665 1
2 333 2
Can it create any problem if i delete records from this table (as you suggested)?
Thanks for your help.
What is the purpose of table UPR41600? When i query this, i get :
CMPANYID Count1 DEX_ROW_ID
1 665 1
2 333 2
Can it create any problem if i delete records from this table (as you suggested)?
Basically each company is given an Company ID number. Here you have Company 1 and Company 2, each company has an employee count of 665 and 333 respectively. The sum of these two is 998 employees. If you are licensed for 1000 employees than you are very close to your limit.
The table will be re populated next time you login to GP if you follow the instructions I posted. Those instructions are based on a MS KB Article. Simply make a backup of the entire Dynamics DB prior to attempting the fix if you are worried.
ASKER
@@opster
Thanks a lot for your great help. I followed the steps you listed and it is working perfectly now. The company with company id 1 was test company (and was not configured properly as you guessed) and system was counting the employees for that company as well.
Now license window showing 665 employees and we are able to enter new employees.
Best regards,
Muhammad Riaz
Thanks a lot for your great help. I followed the steps you listed and it is working perfectly now. The company with company id 1 was test company (and was not configured properly as you guessed) and system was counting the employees for that company as well.
Now license window showing 665 employees and we are able to enter new employees.
Best regards,
Muhammad Riaz
If you do, unless setup correctly as a test company in GP, employees from this database are also counted in the employee count.
Let me know.