{"id":10820,"date":"2023-03-15T12:26:25","date_gmt":"2023-03-15T12:26:25","guid":{"rendered":"https:\/\/testv32.demowebsitelinks.com\/parallel\/?p=10820"},"modified":"2023-04-10T10:19:46","modified_gmt":"2023-04-10T10:19:46","slug":"tips-tricks-for-data-migration","status":"publish","type":"post","link":"https:\/\/testv32.demowebsitelinks.com\/parallel\/2023\/03\/15\/tips-tricks-for-data-migration\/","title":{"rendered":"Tips &#038; Tricks for Data Migration"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10820\" class=\"elementor elementor-10820\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-45ec77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45ec77\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6f7c2f05 top column-style-top\" data-id=\"6f7c2f05\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-42f3f7bf elementor-widget elementor-widget-text-editor\" data-id=\"42f3f7bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.11.5 - 14-03-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#818a91;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#818a91;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<div class=\"paragraph\">By Laura Jaffe<br \/>\u200b<br \/>Are you stuck on a legacy ERP?\u00a0\u00a0Unfortunately, companies often delay badly needed software upgrades because of concerns over data migration.\u00a0Sometimes personnel at a company have been through a previous bad ERP implementation.\u00a0Other times it\u2019s simply the fear of the unknown. \u00a0Either way, these fears are NOT unwarranted.\u00a0Data is at the heart of any ERP system and it\u2019s important to get this right!<\/div><div><div class=\"wsite-image wsite-image-border-none \"><a> <img decoding=\"async\" src=\"https:\/\/www.parallelsolutions4u.com\/uploads\/1\/5\/7\/3\/15732292\/data-migration-1_orig.png\" alt=\"Picture\" \/> <\/a><div>\u00a0<\/div><\/div><\/div><div class=\"paragraph\">Let\u2019s take a look at a few best practices, tips and tricks that we\u2019ve learned while migrating various legacy software solutions to\u00a0<strong><a href=\"https:\/\/www.parallelsolutions4u.com\/acumatica.html\"><span style=\"color: #5495d9;\">Acumatica Cloud ERP<\/span><\/a><\/strong>.\u00a0<br \/><br \/><strong><span style=\"font-size: large;\">Master Data vs Transactional Data<\/span><\/strong><br \/>The data in an ERP software system can be divided into two categories: Master Data and Transactional Data. \u00a0<br \/><br \/>A few examples of Master Data include the chart of accounts, customers, vendors, contacts, and items that you buy, sell or make.\u00a0For manufacturing companies, Master Data also typically includes the routing and bill of material to manufacture stock items.\u00a0In Acumatica, Master Data is called a Profile.<br \/><br \/>Some examples of Transactional Data are sales orders, purchase orders, invoices, payments, and general ledger entries.\u00a0\u00a0\u00a0<br \/><br \/><strong><span style=\"font-size: large;\">Best Practices for Loading Master Data<\/span><\/strong><br \/>Master Data is typically pretty straightforward to bring over.\u00a0Every implementation is unique, but these are some best practices to keep in mind:<br \/><br \/><ul><li style=\"list-style-type: none;\"><ul><li>If there are less than 100 records or the information is on paper or difficult to extract from the existing software it may be more efficient to enter the information directly into the new software through the user interface.\u00a0This is also good practice for users to learn the new system.<\/li><li>For more than 100 records you will typically populate an Excel template with the data to be imported.<\/li><li>If there are data fields that don\u2019t exist on the standard screens, we can help to create attributes or user-defined fields in Acumatica for those fields.<\/li><li>We use an Acumatica import scenario to import the master data, typically into your Test tenant.<\/li><li>Now is a great time to do some housecleaning.\u00a0If there are duplicates or obsolete records in the legacy system this is the perfect time to get that cleaned up!<\/li><li>At Go Live, we import current master data into your Live tenant.<\/li><\/ul><\/li><\/ul><br \/><strong><span style=\"font-size: large;\">Importing Documents and Images<\/span><\/strong><br \/>If you have documents or images to import then\u00a0PSAcuFile, which is an add-on offered by\u00a0Parallel Solutions, can help to automate.\u00a0 A typical example is insurance certificates for your vendors.\u00a0Rather than a user having to navigate to each record and attach documents manually, documents can be copied into a folder for automatic upload.\u00a0The files are linked to the appropriate master data record based on a file naming convention.\u00a0In the case of the insurance certificates each filename would begin with the vendor code.<br \/><br \/>PSAcufile can also be used to upload graphics files in various formats, for example to upload and attach images to stock items for use in a catalog in the Acumatica customer portal or with eCommerce integrations.<br \/><br \/><strong><span style=\"font-size: large;\">Challenges with Transactional Data<\/span><\/strong><br \/>Migrating transactional data to a new ERP system presents some special challenges. \u00a0When a transaction is created in an ERP it affects other modules such as the General Ledger. \u00a0Related master data such as customers, vendors and inventory items must exist if they are referenced on historical transactions.\u00a0There are other validations and relationships between transactional data that make it tricky to import, for example a payment may be applied to an invoice.<br \/>Every implementation is unique, but here are some best practices:<br \/><br \/><ul><li>Limit transactional data history.\u00a0For example, rather than loading many years of AR and AP history, we often recommend loading only Open AR and Open AP.\u00a0 To load documents without affecting the general ledger, Acumatica provides a migration mode.<\/li><li>We also typically load open sales orders, open purchase orders, and open production orders. With open production orders, it is important to create a WIP adjustment for any work in progress.<\/li><li>Load financial data in aggregate by month and GL account using either the Trial Balance screen or by using journal entries and an import scenario.<\/li><li>Load starting inventory balances transactions.\u00a0To load inventory without affecting the general ledger, Acumatica provides the Update GL check box which should be unchecked in Inventory Preferences. After the upload is complete be sure to go back and check this box.<\/li><\/ul><br \/><strong><span style=\"font-size: large;\">But what about all of the other Legacy Financial History?<\/span><\/strong><br \/>Companies can have years of history that employees need to access for various business purposes.\u00a0Two of the most common requirements we come across are sales and purchasing history.\u00a0\u00a0A convenient and efficient way to import this information makes use of the Acumatica xRP Framework to create custom tables.\u00a0These custom tables can be configured with exactly the desired information from the legacy system.<br \/><br \/>Some benefits of loading legacy financial history into side tables:<br \/><br \/><ul><li>It\u2019s easy to import the legacy data by using an import scenario.<\/li><li>This approach eliminates validations and concerns about relationships to other tables, for example an obsolete item can be referenced without the need to create the item in master data.\u00a0You can still link to standard Acumatica tables using Generic Inquiries, side panels and reports.\u00a0<\/li><li>The side tables are available within Acumatica, eliminating the need to maintain legacy software or hardware.<\/li><li>Acumatica generic inquiries, reports, side panels and dashboards can be easily built to display the historical transactions seamlessly.<\/li><li>Notes and files can be attached to the legacy records.<\/li><\/ul><br \/>Changing software can be disruptive, but Acumatica\u2019s flexible platform makes it easy to access the information you need from both worlds seamlessly.\u00a0\u00a0<br \/>\u200b<br \/><span style=\"color: #2a2a2a;\">For more tips and tricks be sure to check out our<\/span><span style=\"color: rgba(0, 0, 0, 0.9);\">\u00a0<\/span>blog.<br \/><br \/>#Acumatica\u00a0#ParallelSolutions\u00a0#LegacySoftware\u00a0#DataMigration<\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#8217;s standard dummy text ever.<\/p>\n","protected":false},"author":1,"featured_media":10822,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-10820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/posts\/10820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/comments?post=10820"}],"version-history":[{"count":5,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/posts\/10820\/revisions"}],"predecessor-version":[{"id":11269,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/posts\/10820\/revisions\/11269"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/media\/10822"}],"wp:attachment":[{"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/media?parent=10820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/categories?post=10820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/testv32.demowebsitelinks.com\/parallel\/wp-json\/wp\/v2\/tags?post=10820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}