Recommended: System Errors? Click here to Fix your PC »
It is natural process of growth and at some point you will need to walk away fromold mini ERP to something suitable for mid-size and even large business accountingpackage. You maybe very concerned about how to really do this, however you are notthe first one and you are not the last one facing this dilemma. LetÂ's review theoptions and steps Old system will be for inquiry only. Yes, you do not want to delete the old ERP,keep it, but all new transactions and master records will come to new ERP  Microsoft Dynamics GP in our described case Beginning Balances Approach. Naturally you as IT professional, DBA or businessowner seek the cheapest and at the same time reliable way to switch to new MRPapplication. After extensive homework you will probably come to the followingconclusion  I donÂ't want expensive data conversion: historical transactions,customers and vendors history files, payroll checks and transactions history. Iwill only do entering beginning balances for the period where I switch from my oldERP to Microsoft Great Plains Master records migration. Even if you are entering beginning balances only  youwill still want to convert and be able to use your customers, vendors, employees, GLaccounts  these are referred as master records in Microsoft Great Plains. In thiscase you can try two strategies  first is Microsoft Dynamics GP Integration Managerand the second one (if you are short of funds) is SQL scripting. If you bringmaster records via SQL scripting  you will need to run check links routine in GP Historical Data Conversion. We recommend you to resist and try to avoid thisoption as much and as long as possible. The reasons are simple  you will be in thesmall rank of customers who decided to do full data migration and you should expectthat not every VAR knows and has experience to do this plus even if somebody didthis historical full conversion  not necessarily that it went smooth and customerdidnÂ't have problems with the following system use.. If you think that there is noway, but history conversion  try to deploy Integration Manager and posttransactions into history instead of direct SQL scripting to bring data over to GP. Extracting data from your old ERP. Typically entry level accounting packages haveproprietary database platform or utilize inexpensive DB, such as Ctree or PervasiveSQL. Try first data export through reporting  this should be definitely possibleif you are sticking to beginning balances entry approach
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.comhe lp@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GPUSA and Canada nationwide: Toronto, Montreal, Vancouver, Calgary, Windsor, New York,San Francisco, Los Angeles, Miami, Orlando, Pittsburg, Toledo, Indianapolis,Detroit, Philadelphia, Boston, Washington, Seattle, San Diego, Phoenix, Austin. Local service is available in Chicago and Houston metros: Rosenberg, Katy, Richmond,Dallas, Galveston, Sugar Land, Naperville, Wheaton, Plainfield, Aurora, Wheaton,Downers Grove, Lisle, Oakbrook, Morris, Marseilles, Joliet, Montgomery, Oswego,DeKalb. With reasonable travel we serve Springfield, Bloomington, Normal, Peoria,LaSalle, Ottawa, Dixon
