Which backend table contains the "Number of Registered User Licenses" ? We have multiple companies and I'll like to write a SQL query to retrieve the numbers. Via the UI I can access from System Configuration - 2. Modules tab. Thanks.
Which backend table contains the "Number of Registered User Licenses" ? We have multiple companies and I'll like to write a SQL query to retrieve the numbers. Via the UI I can access from System Configuration - 2. Modules tab. Thanks.
Hi ALE77,
System Configuration uses the table ..MAS90\MAS_SYSTEM\SY_System.M4T, but not all information, such as “Number of Registered User Licenses”, is stored in this table. This value is based on your Sage 100 Product Keys. If you decide to add additional users, you will be given new Sage 100 Product Keys which will be generated based on the new user count.
If this answers your question, please mark the answer as Verified. Thank you so much!
Thank you!
*Community Hub is the new name for Sage City