Dynamics GP Cloning the Company Computers Articles | April 6 Keith Yandle Jersey , 2011
Microsoft Dynamics GP deploys the architecture where each Company has its own SQL Server database.? If you already have one of the companies implemented and in production phase, there might be a guess to reuse that company settings, such as Chart of Accounts, modules setups in the new company that you need to be created.

It is possible to clone your existing company and we would like to give you some recommendations and steps.? We will review the steps for current version 201011.0 (and older versions on MS SQL Server Platform: 10.0, 9.0, 8.0 Roberto Luongo Jersey , 7.5, 7.0, 6.0) plus we will give you some idea about how to clone the company, where you are on older releases, including on Pervasive SQL 2000 (or its predecessor Btrieve), Ctree (versions 7.5 Sergei Bobrovsky Panthers Jersey , 7.0, 6.0, 5.5, 5.0, 4.0).? Some consideration will be given to Great Plains Accounting on DOS, Windows (versions 9.5 Evgenii Dadonov Panthers Jersey , 9.2) or Mac.? Let?s begin with new company installation procedure in GP Utilities:

1.?Creating the company database.? If you are MS SQL Server Certified DBA, please know that it is not generally a good idea to do all the work via 2008 Management Studio (or Enterprise Manager if you are on SQL 2000).? When you create new company, you have to register this company is several tables in Dynamics database (this is system database for that Corporate ERP application).? This is why the natural way to create new company is via Utilities

2.?Loading the new company from another company backup.? This work could be done in SQL Management Studio.? This is also recommended step to change the ownership of the DB (from SA or domain administrator account, which you likely used to DYNSA, use sp_changedbowner procedure)

3.?Clearing data.? We assume that you do not want your production company transactions, and master records (except probably chart of account) to be present in the new company.? The good way to accomplish this job is Maintenance -> Clear Data (clear all historical Vincent Trocheck Panthers Jersey , open and work tables, plus master tables ? except Financial Account Master; do not clear setup files where modules setups are stored)

4.?Changing Account Segment which stays for the company ID.? This is common practice to have one of the account segments (typically short one, containing just couple of symbols) to be different for each company across the entire installation.? Your accounting department may use it in FRx Reporting (Consolidated Balance Sheet, P&L and Statement of Cash Flow) or Microsoft Management Reporter.? To achieve this goal use Query management (former Query Analyzer) and change the segment in the following statement: update GL00100 set ACTNUMBR_N (where N stays for the segment you need to specify in real situation) = ?02? (where 02 is your second company ? also change it accordingly).? Next step is to rebuild Account Index Master table GL00105.? The easiest way is just to delete all the records there (delete GL00105) and then recreate it by initiating Check Links over account master table cluster (Maintenance -> Check Links)

5.?Additional considerations.? We also recommend you to delete and recreate Account Summary master file (recreation could be done in Utilities -> Financial -> Reconcile).? If your new company will have different fiscal year, you will need to remove historical years (outside of the scope, we already published the dedicated article Aleksander Barkov Panthers Jersey , see us on Google).? Also be sure that you have updated FRx reports, created SOP Invoice Form with new company logo, review if PM check form needs to be updated or not.? If you use Intercompany Transactions module, setup new company intercompany relations

6.?All the above should be valid for the version on Microsoft SQL Server (2008, 2005, 2000 Authentic Sergei Bobrovsky Jersey , 7.0)

7.?Great Plains on Pervasive SQL 2000Btrieve.? Here you have to do the same thing first ? create company in GP Utilities.? This process will create company subfolder in your Dynamics folder on the server (if you are not sure, please review Dex.ini file on the user workstation, where the path to Dynamics folder should be specified ? might be UNC Path or mapped drive).? When you are done with company folder creation in Utilities, open Dynamics folder in Windows Explorer, remove all the folders and files from company folder, copy all the folders from production company folder into newly created company folder.? At this point follow guidelines above and clean data (historical Authentic Evgenii Dadonov Jersey , open, work and majority of the master tables).? Updating existing Btrieve files is a bit tricky.? We usually recommend you to install Pervasive ODBC Driver (it could be found on CD#2 of your installation media, you should also create DDF file ? simply drag DDF.Set and drop it on Dynamics.exe file, Files, Fields, Index DDF files should be copied into your company folder to be recognized by ODBC DSN) and then connect to your tables via MS Access Linked table (via ODBC SDN connection).? If you are on Ctree ? ODBC driver is available on CD#2 as well Authentic Vincent Trocheck Jersey , use MS Access for data update

8.?Great Plains Accounting DOS, Windows or Mac versions (please note that we have only limited experience working with GPA on Mac, but it looks like it is Btrieve database, which if copied to PC should be accessible via ODBC).? Copy production company folder, which could be found under GPS folder on your Server (typically Windows NT or Novell, however large number of GPA customers migrated to Windows 2003 or 2008 Authentic Aleksander Barkov Jersey , including Small Business Server; be sure that you are deploying it on 32 bit Windows as Pervasive SQL 2000 Server was not compatible in time with Windows 64; GPA could be also deployed for auditing purposes on Windows 7 32 bit pn Pervasive SQL 2000) into new folder with the abbreviations of the new company.? Then change login GPA and change the company (here you simply select the new company fol The Mot. Cheap Nike Shoes China Wholesale Jordan Shoes China Wholesale Air Max 2018 Wholesale Vapormax China Wholesale Nike Shox Cheap Authentic Air Jordans Wholesale Nike Shoes China Cheap Air Max Wholesale Wholesale Air Max Discount Wholesale Kids Air Max