|
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 |
Alba Spectrum, Dynamics GP Technology Partner Announces its Participation in Con... [2009-03-03 18:09:34]
Chicago, IL – March 3, 2009 – Alba Spectrum announced today its participation in Convergence 2009, the premier Microsoft Dynamics event that brings together customers, partners, Microsoft team mem...
|
|
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...
|
|
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...
|
|
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...
|
|
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 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 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 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...
|
|
|
|
| Wondershare Pocket DVD Suite |
 Wondershare Pocket DVD Suite provides a perfect solution to the conversion from DVD to Pocket PC and from video to Pocket PC. It can convert DVD and almost all video formats for playback on Pocket PC. |
|
| OneAEM |
 If you want to quickly and efficiently index catalogue, search and store audio with an minimum of hassle then you need OneAEM. Includes Hotkey text annotation and synchronization, conversion to any audio format and specialized playback features. |
|
| 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. |
|
| Asoftech Photo Recovery |
 Asoftech Photo Recovery is an easy to use data recovery software available to restore your photos, music and videos from local PC and removable devices. No matter multimedia files have been deleted accidently, or memory card has been formatted. |
|
| DBEXform |
 Make database application development and use as easy as using word processor or spreadsheet with DBEXform. It builds application logic in background and frees developer to just on building interfaces. Support for Microsoft Sql and Access databases. |
|
| PSPad editor |
 PSPad editor is a programmers editor with support for multiple syntax highlighting profiles. It comes with a hex editor, CP conversion, text differences, templates, macros, spellcheck option, auto-completion, Code Explorer and much more. |
|
| Password Commander |
 Password Commander manages and generates secure passwords, sticks them to web pages and programs with ONE click and clicks the "Log in" button for you. The program keeps personal data encrypted, runs from USB-flash and protects data from keyloggers. |
|
|
Latest press releases
