Restoring a Copy of Your Live Dynamics GP 2013 Database to a TEST Environment by George Rios

When restoring a copy of your live Dynamics GP 2013 database to a TEST environment, you will need to update the SY00100 table to reflect the proper Company ID (CMPANYID) before you can successfully log in.

To find out the proper value to populate within the SY00100.CMPANYID field, run the following script:

SELECT * FROM DYNAMICS.dbo.SY01500

Locate the CMPANYID that corresponds to the TEST company database and make a note of the CMPANYID found within the SY01500 table. Run the following script against the TEST company database (replace TEST with your SQL database name):

SELECT * FROM TEST.dbo.SY00100

Run an update script in order to correct the CMPANYID within the SY00100 table. The following is a sample of a script that could be modified to update your TEST database Company ID (please check with your database administrator or Dynamics GP Partner if you are unsure on how to populate the values below).

UPDATE TEST.dbo.SY00100 SET CMPANYID = ‘XX’ WHERE DEX_ROW_ID = ‘XX’

Immediately after the update is run against the TEST company database you should be able to log in.

George Rios is a Microsoft Dynamics® GP Certified Professional and senior consultant at Bond Consulting Services. He has over 13 years of work experience with accounting and accounting systems.