Great Plains Consultant: Microsoft Dynamics GP data conversion
Microsoft Great Plains ERP or new name Dynamics GP requires precise approach in implementation, user training, initial data migration and conversion, reporting, EDI and possible customization and interface modification. selection of consultants for Microsoft Dynamics GP is often crucial for successful implementation of the process. In this small publication we would like to review the data massage and conversion recommendations and scenarios:
1. Export data from your legacy ERP or accounting application. There is little chance, and this depends on your platform MRP legacy applications. Usually old ERP allows you to export data in tab delimited or comma delimited file format text. But cheap accounting packages for small businesses could be missing export tool, and if this is your case, you must export the data in reports. Reports can be massaged in Excel and then you have come to the next step – Great Plains Integration Manager data import
2. GP Integration Manager. IM can read text files and ODBC data sources. If you are a kind of neglect in the use of instant messaging and the thought that does not work if any – should read samples of advanced ODBC data sources. Advanced ODBC allows you to create advanced SQL Select, group and other aggregated. On MS Windows 2003 Server, as well as workstations Windows Vista or XP Microsoft Text Driver has known problems, and if you think that does not work – we recommend you call in order to help advanced to the ODBC driver configuration
3. Massage Techniques Excel data. Here normally the text of the export process original file and make the necessary corrections
4. Data conversion levels. Ideally you should import GL Chart of accounts, records teachers, including customers, suppliers, employees, then you import your work operations. In some cases, it is necessary to maintain limited number of open sales invoices, while awaiting collection or payments
5. Great Plains Historical Data Conversion. This is what I really do not recommend or at least try to avoid that process. GP conversion story is really difficult. In addition, probably going to get the problems of integrity while making control future connections in GP
About the Author
Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions for the customers in CA, IL, WI, NY, FL, IN, MI, TX, GA, NE, NM, AI, NC, SC, OR, WA, DC, DE, PA, VI, AZ, LA
SUPERTS103 – Super Track Stick Vehicle GPS Data Logger – Home Security Store
[phpzon]Gps Data, 35, Electronics[/phpzon]
