|
Microsoft Dynamics GP 10.0 Data Conversion Techniques Alba Spectrum
Alba Spectrum Group. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains, current version is 10.0 as of September 2007 in certain situations requires legacy system data conversion, migration and initial massage to be convertible. Data migration might be annoying routine, especially when you have to dig out tons of tab delimited texts, however it may define GP implementation success. In this small article we will review typical data conversion scenarios and migration tools. We have to inform you upfront, that MS SQL Server 2005 DB platforms gives you significant advantage in data migration, it opens you the door for SQL scripting: SQL stored procedures and functions, however direct DB feeding might be challenging, if you are not really familiar with GP tables and records distribution
1. No migration. The best and the most successful data conversion is when you dont do it at all. Seriously, first consider this scenario: you print out reports from your legacy accounting ERP application, the one which you are abandoning in favor of GP. If you have small number of GL accounts, customers, vendors, employees enter all these master records in GP by hand and then enter and post one GL transactions which will set GL beginning balances. Then keep going with GP and have your legacy MRP available for inquiry only
2. Master records migration. If you have thousands of GL accounts, customers, vendors, consider purchasing GP integration manager module. IM is end-user tool and data migration could be done in-house by your IT and accounting people. IM could get records from text files as well as from ODBC compliant data sources the most typical scenario is when you migrate master records from text files
3. IM advanced migration. If you can not export nicely structured tab or comma delimited records into the text file and instead you have to try migration from text reports, this is also OK, but you will have to tune IM migration and slightly program it: before document VBA script, for example will allow you to cancel line migration, if it has no info (carriage return, spaces only, or comments line something like these could be weeded out)
4. MS Excel. This tool is unbelievably popular in data conversions, especially considering its functions with combination with Excel series functionality. It is common scenario, when you export GP table into text, then import it into Excel and do data repair there when you are done you save Excel data in tab delimited text and import it back to GP
5. Historical data conversion. If you think about migrating everything from old accounting application, we have to discourage you, especially when you are not professional Great Plains developer or technical consultant. Historical data is created in GP through so-called batch posting process, which is very sensitive to your modules settings, transaction types and, considering the fact that Microsoft Great Plains is not an entry level ERP accounting package chances are high that you will encounter business logic validation problems and historical records will not be reliable and readable
Andrew Karasev, Alba Spectrum Group. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving MS Dynamics GP customers locally in Houston: Richmond, Rosenberg, Dallas, Katy, Sugar Land, Galveston; Chicago: Naperville, Aurora, Morris, Glen Ellyn, Winchester, Oak Park, Lyons, Alsip, Lemont, Seneca, Ottawa, Joliet, Plainfield, Romeoville, Barrington, Crystal Lake, Rockford, DeKalb, Wheaton, Lisle, Downers Grove, Batavia, St. Charles, Norway. Dex customizations USA/Canada nationwide support is available via remote support/connection: California, Minnesota, Florida, New York, Virginia, Oregon, Arizona, Pennsylvania, Vermont, Rhode Island, New Mexico
|
Company: Alba Spectrum Group
| Related press releases |
Microsoft Dynamics GP 10.0 Installation & Implementation scenarios Alba Spectr... [2007-08-29 06:32:26]
Alba Spectrum Group, http://www.albaspectrum.com http://www.clfsolutions.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Alba Spectrum Group helps US and Canada businesses in GP integratio...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Microsoft Dynamics GP 10.0 Implementation in Chicagoland Alba Spectrum [2007-09-03 03:29:31]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are business owner or IT director, you are probably in charge of ERP selection, licenses...
|
|
Old Great Plains Dynamics versions support, recovery and upgrade Alba Spectrum [2007-08-29 05:31:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 10630-961-5918
In best case scenario you as Microsoft Dynamics GP customer who is following the recommended ve...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Dynamics GP 10.0 Implementation services in Chicago Alba Spectrum [2007-08-18 02:43:04]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Great Plains, as it was formerly known, became part of Microsoft Dynamics family of ERP products...
|
|
Microsoft Dynamics GP 10.0 opening the door Alba Spectrum [2007-08-17 04:56:34]
Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com
Microsoft Great Plains version 10.0 is released and at this time, August 2007, upgrade activit...
|
|
Microsoft Dynamics GP 10.0 Nationwide Remote Support Alba Spectrum [2007-08-31 06:22:02]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP version 10.0 was released in Summer 2007 and now there is the season of G...
|
|
Microsoft Great Plains Implementation Service in Chicagoland Alba Spectrum [2007-09-06 06:13:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP software sales, business processes mapping and modules selection, data mi...
|
|
|
|
| Selkie Rescue Data Recovery |
 Computer crash nightmare? Get the best file migration and data recovery software for under $100. Selkie Rescue Data Recovery is do-it-yourself fast data recovery for your PC or laptop. Simple secure software for recovering all your files. |
|
| PaintCOST Estimator for Excel |
 Painting and Wallcovering Estimator for Excel. Designed for painting contractors, decorators, builders, remodelers, and do-it-yourself individuals. Contains cost data and intelligent takeoff area calculator. Automatically creates price quotation. |
|
| Aloaha PDF Saver |
 The Aloaha PDF Saver allows you to fill in PDF Forms and save them to disk.
A OCX Version inclusive sample source code of the PDF Saver is also included.
You can also retrieve the Form Data as an XML File to archive it in your database. |
|
| uCertify MCSE (70-270) practice test |
 Pass MCSE exam 70-270 in first attempt. 455 questions with detailed explanation and 138 study notes. 70-270 - Windows XP Professional study notes, articles and mock test. 99% pass rate, 100% money back guarantee. Based on latest Microsoft certificat |
|
| HS XMODEM C Source Library |
 HS XMODEM is a software library in C (supplied with full source code) that provides a programmer with the off-the-shelf support for XMODEM protocol data transfer capability. Support for both sender and receiver are provided. |
|
| Aglare AVI MP4 3GP iPod MPEG Converter |
 Aglare AVI MP4 3GP iPod MPEG WMV MOV DVD Converter is powerful, versatile video conversion software which convert video file between all popular video formats including AVI, MP4, WMV, VCD, DVD, VOB, 3GP, iPod, iPhone, Zune, MOV, etc. |
|
| HS Crypto C Source Library |
| HS Crypto is a software library in C (supplied with full source code) which offers a programmer an API to several data encryption / decryption algorithms. Table translation, XOR, MD5 |
|
|
Latest press releases
