{"id":5548,"date":"2013-12-21T12:06:37","date_gmt":"2013-12-21T12:06:37","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=5548"},"modified":"2013-12-21T12:06:37","modified_gmt":"2013-12-21T12:06:37","slug":"merging-multiple-erp-company-databases-into-one-sage-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/","title":{"rendered":"Merging multiple ERP company databases into one Sage ERP"},"content":{"rendered":"<p>In this blog, we are going to discuss about the merging multiple companies into one Sage ERP Company. In our earlier blog, we discussed about need of the data migration. You can read this blog <a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/16\/merge-your-multiple-company-databases-into-one-sage-erp\/\">here<\/a>.<br \/>\nData merging &amp; migration is a serious task because each application data is uniquely defined, structured and identified within the source and target Sage ERP. To complete the data merging and migration, one has to look at various points \u2013<\/p>\n<ul>\n<li><span style=\"font-size: 14px;line-height: 1.6em\">List of legacy company databases to merge\u00a0<\/span><\/li>\n<li><span style=\"font-size: 14px;line-height: 1.6em\">List of Modules \/ application to be migrated and merged\u00a0<\/span><\/li>\n<li><span style=\"font-size: 14px;line-height: 1.6em\">Type of Transactions such as Invoices, Payments, Return, etc.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><em><span style=\"color: #993300\"><strong>ALSO READ:<\/strong><\/span><\/em>\u00a0 <a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/09\/17\/gumu-migration-overview-a-sage-certified-migration-solution-by-greytrix\/\">GUMU \u2013 A Sage Certified migration solution by Greytrix<\/a><\/p>\n<p>While merging data, there are various strategies that are adopted. One has to follow a best approach \/ process in order to merge the data. Before merging we assign a number to each source legacy company. We do this so that we can avoid any document number conflict.\u00a0In the data migration, various steps are involved. The most important and common ones are listed below \u2013<\/p>\n<ol>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Assigning a Number to each database:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> We will do this in order to ensure that the data does not get merged or we get any duplicate record related error. We make use of this in 3rd step. \u00a0<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Merging Multiple Masters into One:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> In this, we merge master\u2019s data using the mapping file. This also helps us in removing the master\u2019s data ambiguities during the conversion.\u00a0<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Transaction Merging :<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> For this, we re-number the transaction document numbers before importing them into target Sage ERP. We prefix, each document number with the database code (that we have assigned in the first step). This re-numbering helps in identifying the transaction after the target conversion is over.<\/span><\/li>\n<\/ol>\n<p>E.g. If we have 4 companies to merge named ABC, DEF, GHI and XYZ, then during the merging process, we assign a number i.e. 01-ABC, 02-DEF, 03-GHI and 04-XYZ. So when we merge the transaction from these companies into one Target Company, we prefix\/suffix (as per user choice) each company code to each transaction document number.<br \/>\nAt the end, when the migration gets completed, we check the following details to ensure the consistency.<\/p>\n<ul>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Accounting:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> COA count, Trial Balance, Balance Sheet, Profit and Loss Statement, etc.<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Sales:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> Aging Report and customer counts<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Purchase:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> Aging and vendor count<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Item:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> Stock Value and item count<\/span><\/li>\n<li><strong style=\"font-size: 14px;line-height: 1.6em\">Bank:<\/strong><span style=\"font-size: 14px;line-height: 1.6em\"> Opening balances and bank count<\/span><\/li>\n<\/ul>\n<p>In this way we can merge the multiple source companies into one target Sage ERP company database.<br \/>\nFor more information on the data migration, drop us a mail at erpmig@greytrix.com.<br \/>\n<strong>Related Posts:<\/strong><br \/>\n<strong>1.<\/strong>\u00a0<a title=\"What do you want to migrate to Sage ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/18\/what-do-you-want-to-migrate-to-sage-erp\/\" target=\"_blank\">What do you want to migrate to Sage ERP<\/a><br \/>\n<strong>2.<\/strong>\u00a0<a title=\"Data migration from your accounting system to Sage ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/18\/data-migration-from-your-accounting-system-to-sage-erp\/\" target=\"_blank\">Data migration from your accounting system to Sage ERP<\/a><br \/>\n<strong>3.<\/strong>\u00a0<a title=\"Migration of Purchase Payment from QuickBooks to Sage 300\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/21\/migration-of-purchase-payment-from-quickbooks-to-sage-300\/\" target=\"_blank\">Migration of Purchase Payment from QuickBooks to Sage 300<\/a><br \/>\n<strong>4.<\/strong>\u00a0<a title=\"Migration of Banks from QuickBooks to Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\" target=\"_blank\">Migration of Banks from QuickBooks to Sage 300 ERP<\/a><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we are going to discuss about the merging multiple companies into one Sage ERP Company. In our earlier blog, we discussed about need of the data migration. You can read this blog here. Data merging &amp; migration is a serious task because each application data is uniquely defined, structured and identified within\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5548","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In this blog, we are going to discuss about the merging multiple companies into one Sage ERP Company. In our earlier blog, we discussed about need of the data migration. You can read this blog here. Data merging &amp; migration is a serious task because each application data is uniquely defined, structured and identified within\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-21T12:06:37+00:00\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\",\"name\":\"Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"datePublished\":\"2013-12-21T12:06:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merging multiple ERP company databases into one Sage ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/","og_locale":"en_US","og_type":"article","og_title":"Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In this blog, we are going to discuss about the merging multiple companies into one Sage ERP Company. In our earlier blog, we discussed about need of the data migration. You can read this blog here. Data merging &amp; migration is a serious task because each application data is uniquely defined, structured and identified within\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-12-21T12:06:37+00:00","author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/","name":"Merging multiple ERP company databases into one Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"datePublished":"2013-12-21T12:06:37+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/21\/merging-multiple-erp-company-databases-into-one-sage-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Merging multiple ERP company databases into one Sage ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/5548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=5548"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/5548\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=5548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=5548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=5548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}