All About Accounting Software

Dynamics GP Data Migration from Your Legacy Accounting Application

Dynamics GP Data Migration from Your Legacy Accounting Application

Dynamics GP Data Migration from Your Legacy Accounting Application


Free Online Articles Directory




Why Submit Articles?
Top Authors
Top Articles
FAQ
AB Answers

Publish Article

0 && $ .browser.msie ) {
var ie_version = parseInt($ .browser.version);
if(ie_version Hello Guest
Login


Login via


Register
Hello
My Home
Sign Out

Email

Password


Remember me?
Lost Password?

Home Page > Computers > Software > Dynamics GP Data Migration from Your Legacy Accounting Application

Dynamics GP Data Migration from Your Legacy Accounting Application

Edit Article |

Posted: Nov 07, 2010 |Comments: 0
|



]]>

When you are implementing new Corporate ERP application, the question of the data conversion and migration is often on the top of the list.  Sometimes your Information Technology department folks may tell you, if Dynamics GP is MS SQL Server based application, they should be able to convert all the data from your legacy ERP into Great Plains tables via SQL insert statements.  You should be aware that modern Corporate ERP systems, such as Dynamics GP, AX, SAP Business One have high level of abstraction and among the three mentioned, only Dynamics GP allows you direct data inserting, while Axapta and Business One do not allow you alter data on the table records level (you may try and see what will happen…).  Let’s now concentrate on Great Plains Dynamics GP.  For initial data conversion we recommend you to consider Integration Manager.  If you plan only initial one-time data conversion, you may consider IM Conversions license, or if you plan ongoing integration (especially in ecommerce daily shopping carts, Point Of Sale transactions import, or even in simple custom EDI, where you would like to integrate Electronic Data Interchange files without purchasing expensive EDI integration capable products) – consider IM full license (or you may choose Financials or Distributions only).  In some cases, when you are walking away from legacy accounting and implementing GP, there might be migration tool, especially when you are on GP track (such as if you are on Great Plains Accounting for DOS, you may upgrade it all the way through Dynamics GP 2010; or if you are on Great Plains Dynamics on Pervasive SQL 2000/Btrieve or Ctree – no need for data conversion – upgrade route will lead you to the current Dynamics GP version 2010 or previous version 10.0; there is also Rapid Migration Tool, which should help you to migrate from QuickBooks or Peachtree to Dynamics GP).  Let’s now review data migration and conversion steps and recommendations:

1. Decision on the Conversion Scope.  Some customers may say – why don’t we just migrate “everything”?  or “everything possible”?  The answer may be in the cost.  Theoretically you may migrate all the data from your legacy accounting, but it might be impractical, especially when you have huge amount of historical data and you do not expect to use it (some queries might be needed, maybe if you expect future company audit, but other than that…).  We recommend you to consider keeping your legacy Corporate ERP application on the stand alone computer for possible queries and begin from the new page with your new ERP system, Microsoft Dynamics GP.  Consider moving just master records: Chart of Accounts (you may decide to re-haul its structure and clean it up a little bit), Customers, Vendors, Employees, Addresses and beginning balances in General Ledger.  This approach should allow you to minimize data conversion budget and be ready to start using your new Accounting in the matter of several weeks.  If you would like to see GL reports, where you compare current year versus last year (typically P&L or Balance Sheet in FRx or Microsoft Management Reporter) – then you may decide to convert GL transactions for the last year (the easiest way is to combine all the transactions for the fiscal period, often it is calendar month, into one and post them into the open previous year).  Conversion is relatively straight forward to be designed in Integration Manager.  If you think that this conversion method doesn’t work for you and you really need historical transactions to be converted in such modules as Sales Order Processing, Purchase Order Processing, Inventory Control, Payroll, let’s try to review that in the next paragraph

2. Historical Data Conversion.  It might be required, try to answer the following questions.  Do I really need to base my Pricing for specific customer on historical orders?  How far would I like to go to the history – one, two, five years, prior to resetting the customer price list to my current standard pricing?  Do I want to negotiate the price with my supplier, based on my historical purchase orders.  If my customer have self-service on my B2B ecommerce portal, what is the historical time span for them to see?  If you have the answer, where you indicate that one or several of these questions have answer “Yes” – you may need historical data migration.  Let’s review how historical data could be migrated

3. Integration Manager in Historical Data Conversion.  It is not really difficult to integrate Sales, Purchasing, Inventory, Payroll transactions in IM.  The challenge is typically related to the volume of historical data, that is the subject to migration.  If you have several millions of Sales transactions in the past ten years – you may expect several hours or even days to move them into GP, as IM validated business logic for each one and you may expect the migration process to be repeated several time, until you are satisfied with the results.  Another recommendation in historical data conversion – please, consider unchecking Posting Through and To General Ledger, as the most likely GL beginning balances or even historical years are handled directly in GL historical data conversion

4. Some facts about Integration Manager for programmers.  The easiest way to setup integration is to base it on text file (tab, comma or special character delimited).  However IM is not limited to text files only.  Source Query could be based on simple or even so-called Advanced ODBC, where you can pull data from such Microsoft Databases as MS SQL Server, Access, Excel, Word, plus from non-Microsoft DB platforms, such as MySQL/Linux, FoxPro, Pervasive SQL, Ctree, Oracle, DBII to name a few.  Advanced ODBC also could help you with manipulating text file (Microsoft Text File ODBC Driver) – you can use such constructions as Union, Group By, Having, etc.  In Integration Manager you can also tune integration logic via Events triggered VBA scripts: Before Document, Before Document Commits…

5. Technical Side of Integration Manager.  Dynamics GP is kind of in transition to deploy as much SQL Stored Procedures as possible (and expose itself to such technologies as .Net, XML, Web Services, C#).  IM is not an exception, with Dynamics GP 10.0 we see strong influence of eConnect SDK (the background technology for eConnect are encrypted SQL Server Stored Procedures).  With the introduction of the version 10.0 and especially with 2010/11.0 eConnect is recommended alternative to traditional Integration Manager Queries, based on OLE Server (old-good-days Great Plains consultants know – when you are launching IM all the Windows should be closed and GP application goes into background mode, enabling GP as OLE Server).  eConnect is based on SQL Stored Procedures, and it doesn’t require you to have Great Plains user workstation running (and consuming one concurrent user license).  Plus eConnect connectors for Integration Manager are naturally faster (OLE Server is very high level abstraction and it fill in all the fields and then submits the form for processing as you would do it in user interface, where eConnect simply call encrypted SQL stored procedure)

6. Ongoing Integration.  Let’s review this routine for such popular case as ecommerce shopping cart integration into SOP Invoice.  Integration Manager could be triggered to launch SOP integration on demand, or it could be scheduled to be called every ten minutes (quasi real time integration).  We do believe that quasi real time integration is feasible option for most of the ecommerce retailers and wholesalers.  In the case, when you really have to see the ecommerce shopping cart originated transaction in the matter of seconds, you may decide to program it in eConnect libraries for Microsoft Visual Studio.Net

7. To request further support, please call us 1-866-528-0577, help@albaspectrum.com We need to discuss your cards in order to recommend you the best solutions, which is not contingent to our preferences.  We serve you USA/Canada nationwide via remote support (web sessions and phone/Skype conferences).  Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston area of the state of Texas

Retrieved from “http://www.articlesbase.com/software-articles/dynamics-gp-data-migration-from-your-legacy-accounting-application-3623612.html

(ArticlesBase SC #3623612)

Liked this article? Click here to publish it on your website or blog, it’s free and easy!

Andrew Karasev -
About the Author:

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego

]]>

Questions and Answers

Ask our experts your Software related questions here…200 Characters left

Which category of iphone applications among GPS tracking, business and lifestyle apps you find most value defining?

Rate this Article

1
2
3
4
5

vote(s)
0 vote(s)

Feedback
RSS
Print
Email
Re-Publish

Source:  http://www.articlesbase.com/software-articles/dynamics-gp-data-migration-from-your-legacy-accounting-application-3623612.html

Article Tags:
microsoft dynamics gp

Related Videos

Related Articles

Latest Software Articles
More from Andrew Karasev


Microsoft Expressions Web – How Dynamic Pages Display Data from Databases

Learn about Dynamic Pages, Agents, and how dynamic pages display data from database (04:53)


How to Set up Dynamic Validation in Excel

Greg wants to set up dynamic validation, but he has a wrinkle….Once someone chooses from the first data set, he needs to append the word My before that answer to get to the name of the second data set. Episode 1130 shows you how.

(02:21)


MrExcel’s Learn Excel #937 – Dynamic Validation

I’ve talked about making the list for your data validation automatically grow with the list. In the past, I’ve used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! (02:20)


How to Add a Dynamic XY Series in Excel

Craig added an arrow to a line chart. Every time the data changes, the arrow needs to be repositioned. Episode 1092 shows how to add a dynamic XY series to redraw the arrow. (06:27)


Microsoft Expression Web – Using Dynamic Web Templates

Learn how to use Dynamic Web Templates in Microsoft Expression Web (07:30)

Microsoft Dynamics Gp Software Development Factory

We are writing this small publication for the mid-size and large businesses, deploying Microsoft Dynamics GP (formerly known as Great Plains Dynamics, and its predecessor Great Plains Accounting for DOS, Windows and Mac) as their Corporate ERP application. Dynamics GP could be considered as flexible Accounting, ERP, MRP II platform, ready for simple or advanced customizations, modifications, integrations, reporting, EDI interfaces

By:
Andrew Karasevl

Computers>
Softwarel
Feb 02, 2010

Microsoft Dynamics GP 7.5, 9.0 version update notes

As recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level

By:
Andrew Karasevl

Computers>
Softwarel
Dec 27, 2009
lViews: 115

Microsoft Dynamics GP Tech Support Covering All the Version

Microsoft Dynamics GP versions 2010/11.0, 10.0 and 9.0 are covered by Microsoft Business Solutions technical support team. This is current as of September 2010, however tech support for version 9.0 will expire in earlier 2011, so plan upgrade activity accordingly

By:
Andrew Karasevl

Computers>
Softwarel
Sep 06, 2010

ECommerce Integration Add-Ons for Microsoft Dynamics GP

If you are on the way to evaluate Microsoft Dynamics GP ecommerce integration options, and in your case you already have custom programmed (often in-house) ecommerce web application in production and you do not like the idea to redeploy ecommerce on new platform (and write off investment in legacy ecommerce program) – we respect your approach and would like to recommend you this small publication.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 22, 2010

Microsoft Dynamics GP Applying Service Packs Technology

If your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.

By:
Andrew Karasevl

Computers>
Softwarel
Dec 30, 2009

Microsoft Dynamics GP Deployment and User Training Notes

If your organization plans to deploy Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise and its predecessor Great Plains Accounting for DOS, Windows and Mac, we would like to offer you this small introduction level publication.

By:
Andrew Karasevl

Computers>
Softwarel
Dec 24, 2009

Development for Microsoft Dynamics GP, formerly known as Great Plains: Dexterity, eConnect, eCommerce programming

Microsoft Dynamics Corporate ERP and CRM family of products includes Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (formerly known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be part of Corporate ERP, but technically it is just CRM).

By:
Andrew Karasevl

Computers>
Programmingl
Dec 16, 2009

Microsoft Dynamics Gp Partner Selection Recommendations

If your organization is in process of reviewing and selecting new Corporate ERP application and you are including Microsoft Business Solutions Dynamics GP, we would like to offer you this small article with advises, based on our consulting practice, successful and failed Corporate ERP implementation cases (based on Microsoft Dynamics GP, Great Plains Dynamics, Great Plains Accounting and also SAP Business One, Microsoft CRM, and others).

By:
Andrew Karasevl

Computers>
Softwarel
Feb 01, 2010

JPEG Images- Convert Them into PDF Documents

There are numerous topics concerning the benefits that one can get if Portable Document Format is used and if you think you have enough information on that then it would be better to jump to the next topic where you can gather more information on the benefits that you can get by converting JPEG images into this particular format. More often than not, people convert their documents from word to pdf but going from JPEG to this format; let us first understand what the former is all about.

By:
jennyhamperl

Computers>
Softwarel
Jan 21, 2011

A Good Way of Making Money

To make your stock investment run smoothly is to make certain that your stock management is done in a systematic and efficient manner.

By:
Chris Foxl

Computers>
Softwarel
Jan 21, 2011

Jpeg to Word Converter – Convert Jpeg to Word in Order to Bring Necessary Changes in the Image

Optical Character Recognition (OCR) software has made it much easier to bring changes in the image. It was much harder previously to alter anything in a jpeg image. Optical Character Recognition software converts jpeg to word so that it would become easier to do the required amendments.

By:
Ankit Nagpall

Computers>
Softwarel
Jan 21, 2011

Convert Jpeg to Word Easily by Using Optical Character Recognition (OCR) Software

If you want to bring changes in the images, you would be required to change the format of your file. Jpeg to word converter, which is the form of OCR software, is one of the powerful tools, which can do this job effectively.

By:
Ankit Nagpall

Computers>
Softwarel
Jan 21, 2011

Trojan Virus Remover Software

Better understanding the need for some of the protection available for your computer is the first step in actually being able to protect it from threats that exist on the internet. For instance, this particular article will focus on the necessity of a Trojan virus remover. Get the best Trojan virus remover software here…

By:
Donald Chambersl

Computers>
Softwarel
Jan 21, 2011

What Cause a Computer to Be Slow and How to Fix?

Frustration abounds when a computer begins to run at a slower speed. Many of the programs that one depends on does not function in the correct manner. Learn what causes a computer to be slow and how to fix it here…

By:
Austin Porterl

Computers>
Softwarel
Jan 21, 2011

Information Security Management – A Balancing Act

Information security management is imperative to protect your organisation’s data. Read this guide to find out why it’s important you don’t neglect it.

By:
Michaell

Computers>
Softwarel
Jan 21, 2011

How to Import 720p/1080i/1080p AVCHD to iMovie ’11, ’09, ’08?

Follow the simple guide to convert and import AVCHD camcorder videos, import 1080p,1080p24,1080-line 50p/60p,1080i,720p to iMovie without much quality loss.

By:
softmastersl

Computers>
Softwarel
Jan 21, 2011

Warehouse Technology and Dynamics GP

Barcoding is probably one of the keywords, when you are thinking about operations automation on the warehouse floor. There might be also other popular technologies, often similar by their idea, for example RFID tags and readers.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 20, 2011

Dynamics GP Development: Trends and Technologies

Mid-market Corporate ERP applications, such as Microsoft Dynamics GP, often also referred by its historical name Great Plains, should have reasonable openness to custom programming projects.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 19, 2011

Dynamics GP Technical Support Practical Advices

All the versions of Great Plains Dynamics, GPA for DOS, Windows and Mac, Dynamics GP are supportable, no question about it. However the support might not be available directly from the Microsoft Business Solutions, successor of Great Plains Software.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 18, 2011

Upgrading Dynamics GP or former Great Plains

Version update for your Corporate ERP system is relatively simple project, when you are one the previous version, or maybe skipped one.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 18, 2011

Dynamics GP Reporting: FRx, Crystal, SSRS, Practical Advices from the field Consultant

For the introduction paragraph, I’d like to mention that all the tools are doing their job, the dilemma however is to select the right tool to do the job.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 17, 2011

Dynamics GP Integration Alternatives to Ecommerce Module, Doing the Job in Integration Manager

When you are implementing ecommerce extension for your Corporate ERP application, probably the first idea is to have it integrated in real time, where ecommerce shopping cart (Magento, ASP.Net Storefront, etc.)

By:
Andrew Karasevl

Computers>
Softwarel
Jan 17, 2011

Dynamics GP Customization Tools Selection Practical Advices

Great Plains custom programming might be done in a variety of ways, including Dexterity, eConnect, Modifier with VBA, Extender, Microsoft Visual Studio Tools, directly in SQL scripts

By:
Andrew Karasevl

Computers>
Softwarel
Jan 17, 2011

Dynamics GP Integration Manager in Data Imports

There is an option for new GP customer to purchase IM module for initial data conversion only. We’ll try to describe you data migration scenarios and how Integration Manager does the job.

By:
Andrew Karasevl

Computers>
Softwarel
Jan 17, 2011

Add new Comment

Your Name: *

Your Email:

Comment Body: *

 

Verification code:*

* Required fields

Submit

Your Articles Here
It’s Free and easy

Sign Up Today

Author Navigation

My Home
Publish Article
View/Edit Articles
View/Edit Q&A
Edit your Account
Manage Authors
Statistics Page
Personal RSS Builder

My Home
Edit your Account
Update Profile
View/Edit Q&A
Publish Article
Author Box


Andrew Karasev has 985 articles online

Contact Author

Subscribe to RSS

Print article

Send to friend

Re-Publish article

Articles Categories
All Categories

Advertising
Arts & Entertainment
Automotive
Beauty
Business
Careers
Computers
Education
Finance
Food and Beverage
Health
Hobbies
Home and Family
Home Improvement
Internet
Law
Marketing
News and Society
Relationships
Self Improvement
Shopping
Spirituality
Sports and Fitness
Technology
Travel
Writing

Computers

Computer Forensics
Computer Games
Data Recovery
Databases
E-Learning
File Types
Hardware
Information Technology
Intra-net
Laptops
Networks
Operating Systems
Programming
Security
Software

]]>

Need Help?
Contact Us
FAQ
Submit Articles
Editorial Guidelines
Blog

Site Links
Recent Articles
Top Authors
Top Articles
Find Articles
Site Map
Mobile Version

Webmasters
RSS Builder
RSS
Link to Us

Business Info
Advertising

Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2011 Free Articles by ArticlesBase.com, All rights reserved.

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego


Article from articlesbase.com


No comments