InterDyn Artis
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
  • Events
    • All Upcoming Events
    • Conferences
    • Training / CPE
    • Vision
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Choose InterDyn Artis
    • Contact Us
    • Our Team

The Data Conversion Conundrum

9/15/2017

0 Comments

 
Posted by George Delp
​
Explaining how to handle data conversion to anyone implementing a new Enterprise Resource Planning (ERP) software is probably the most difficult concept to explain.  Most people want all of their data from their existing system ready to go in there new system on day one.  While this is a wonderful idea, the actual act of doing that is easier said than done. 

Data conversion

The Problem

The problem with data conversion lies with historical transactions.  Converting master records and open balances is easy in comparison.  The reason for the difference is that historical transactions, such as paid vendor invoices, involve a lot more than updating just one table.  In fact, such a transaction is actually a series of transactions.

In the case of the vendor invoice, there is possibly a preceding purchase order, an inventory receipt, vendor invoice entry and vendor invoice payment.  Typically, the only way to recreate this type of history is to rerun the transactions in the new system.  This is not a trivial task and winds up taking a lot of time and money.  These transactions typically update multiple tables and the only way to ensure data integrity in the new system is to rerun the transactions.  Creating an import tool that “gets it right updating every table” is usually not practical.
​

So, What to Do?

There are several options. 
​
But first let’s talk about the basics.  Regarding data conversion, everyone should at a minimum:
  • Convert master records, such as GL accounts, vendors, customers inventory items and whatever else might be appropriate for your situation.
  • Convert open balances and true them up right before go live.

This is typically done by exporting the data from your current system into a spreadsheet compatible format and then importing it into the new system.  Data cleansing should be performed at this time.  This involves deleting no longer used vendors, customers and items, combing duplicates and also possibly redesigning the chart of accounts.  If the number of items is low, say less than 100, it is often easier to just hand key the information.  This can also serve as a great training exercise.

After that you need to decide how to how handle your historical transaction detail.  Options include:
  • Just ignore it.  Most people don’t go for this.
  • Keep you legacy system around for historical look up purposes.  Most of the time when we put people onto a new ERP system, the prior system is some kind of perpetual software license so it isn’t going anywhere.  This is by far the most common and cost effective approach.
  • Export you data into a simple database or complex spreadsheet so you can look things up.  If you are switching from a SaaS system sometimes this is the only option since the SaaS system will go away once you stop paying for it.  Although, as of late I have seen people keep their old SaaS systems for a period of time by lowering the user count to one or two users.
    ​

Start Planning Your New ERP Implementation

​Changing ERP systems is a big deal and how you handle your data transfer is critical.  You have to balance the cost/benefit of any business project.  Hopefully the above listed ideas give you some ideas on how to achieve the right cost to benefit and will help you on your way to planning your new ERP implementation.
Enterprise Resource Planning

Partner with InterDyn Artis

If you are interested in implementing a new ERP solution, InterDyn Artis can help! With nearly 30 years of proven experience, we have helped hundreds of organizations implement solutions that provide a positive return on investment. 
About InterDyn Artis
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    InterDyn Artis

    Your one stop shop for Microsoft Dynamics.

    Categories

    All
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

    RSS Feed

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
​User Conferences
Training / CPE
Vision
Webinars & Workshops
Resources
Blog
Forum
Referral Program
​​YouTube Channel
Company
About Us
Careers
Contact Us
8100 Tower Point Drive
​Charlotte, NC 28227

(704) 846-6750
info@interdynartis.com

Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

InterDyn Artis