Great,Plains,Consultant,Data,M computer Great Plains Consultant: Data Migration and Conversion
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
In this publication we would like to share with you some common data integration and conversion techniques1. Dynamics GP Integration Manager. IM should be reviewed first, prior to considering other data integration and migration options and tools. Assuming that you are implementing new GP version, such as Great Plains 10.0 (current at this time, September 2008), you should know technical side of new connectors available eConnect technology. eConnect revolutionizes IM, as it breaks through performance hurdle and provides several hundred documents per minute, depending on the document type. If you have your conversion data in ODBC compliant database, we recommend you to consider advanced ODBC query in IM. Advanced ODBC allows you to do union, group by, having, sum, max and other standard SQL queries (obviously ODBC places some restrictions, but they are typically not critical and not a show stoppers)2. IM and Text Files. If your legacy data export is not really flexible and what you get is old fashion text report, do not give up, if you design Advanced ODBC query over Text Driver, you can weed out blank lines, headers, comments and other rows, non participating in integration3. Data Conversion Strategies. If you think that you can import everything, you probably should review conversion scenarios and their cost and vulnerability to flaws and errors. When you switch over from your old legacy MRP to new accounting application, you should consider smooth transition, where you leave your legacy system for data inquiry for several years, while new system crosses reasonable data collection time frame to virtually shut down the old ERP4. Master Records Migration. Try to evaluate first so-called master records conversion: GL accounts, customers, vendors, employees and addresses. Then you simply enter GL beginning balances and switch over daily data entry to your newly implemented Dynamics GP Great Plains. This approach is the best, the most reliable and the most cost efficient and errors proof5. GP historical data conversion. This conversion is something that we would like to discourage you to do. It is possible, however it is not easy and you should review the feasibility from the stand point of the budget, the efficiency and the end result. You may get final results, however you will spend high budget with modest performance
Great,Plains,Consultant,Data,M