{"id":8187,"date":"2014-07-30T04:17:30","date_gmt":"2014-07-30T04:17:30","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=8187"},"modified":"2019-12-26T05:35:39","modified_gmt":"2019-12-26T05:35:39","slug":"migrate-item-masters-from-quickbooks-to-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/","title":{"rendered":"Migrate Item Masters from QuickBooks to Sage 300 ERP"},"content":{"rendered":"<p><span style=\"color: black\">We provide data Migration Services from QuickBooks to Sage 300 ERP (formerly known as Sage&nbsp;Accpac) at our Sage Migration Center.<\/span><br \/>\nThis blog is in continuation to our GUMU&#x2122; ERP Migration services. In our previous blog we discussed about&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/30\/migrate-sales-order-from-sage-50-us-to-sage-300-erp\/\">Migration of Banks from QuickBooks to Sage 300 ERP<\/a>. In this blog we will discuss about how QuickBooks Item Masters gets migrated to Sage 300 ERP (Formerly known as Accpac) using GUMU.<br \/>\n<span style=\"color: black\">Our GUMU&#x2122; migration&nbsp;utility is compatible&nbsp;to&nbsp;convert all Master and Open transactions along with Sales, Purchase and GL historical data from&nbsp;QuickBooks to&nbsp;Sage&nbsp;300&nbsp;ERP.<\/span><br \/>\nLet\u2019s have a look on QuickBooks items:<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-8188 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\" alt=\"1\" width=\"701\" height=\"527\" border=\"2\"><br \/>\n<\/a>You can edit Unit of Measure by clicking on Edit. The following window will be displayed:<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/22.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-8189 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/22.jpg\" alt=\"2\" width=\"467\" height=\"446\"><br \/>\n<\/a>After data migration from QuickBooks, the field value of QuickBooks Items gets converted with following mapping:<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/32.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-8190 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/32.jpg\" alt=\"3\" width=\"454\" height=\"187\"><br \/>\n<\/a>Here are the converted Item Master fields from QuickBooks to sage 300. Kindly refer the below screenshot where the Item has been converted as per the mapping mentioned in above table.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8191 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/4.jpg\" alt=\"4\" width=\"743\" height=\"561\"><br \/>\n<\/a>If you want to check units are migrated properly you can click on Units option. It can be edited.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8192 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/5.jpg\" alt=\"5\" width=\"744\" height=\"560\"><br \/>\n<\/a>In this way, QuickBooks Item Masters are migrated into target Sage 300 ERP company database. For more information on ERP data migration, drop us a mail at&nbsp;<a href=\"mailto:erpmig@greytrix.com\">erpmig@greytrix.com<br \/>\n<\/a><br \/>\n<span style=\"color: #800000\"><strong>Also Read:<\/strong><\/span><br \/>\n1)&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/28\/migrate-sales-person-from-sage-50-cad-to-sage-300-erp\/\">Migrate Sales Person from Sage 50 (CAD) to Sage 300 ERP<\/a><br \/>\n2)&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/25\/migrate-gl-accounts-from-sage-50-cad-to-sage-300-erp\/\">Migrate GL Accounts from Sage 50 CAD to Sage 300 ERP<\/a><br \/>\n3)&nbsp;<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/24\/migrate-gl-accounts-from-sage-50-us-to-sage-300-erp\/\">Migrate GL Accounts from Sage 50 US to Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We provide data Migration Services from QuickBooks to Sage 300 ERP (formerly known as Sage&nbsp;Accpac) at our Sage Migration Center. This blog is in continuation to our GUMU&#x2122; ERP Migration services. In our previous blog we discussed about&nbsp;Migration of Banks from QuickBooks to Sage 300 ERP. In this blog we will discuss about how QuickBooks\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-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":[1405,2148,2324],"class_list":["post-8187","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-item-master","tag-quickbook","tag-sage-300"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migrate Item Masters from QuickBooks to Sage 300 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\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate Item Masters from QuickBooks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"We provide data Migration Services from QuickBooks to Sage 300 ERP (formerly known as Sage&nbsp;Accpac) at our Sage Migration Center. This blog is in continuation to our GUMU&#x2122; ERP Migration services. In our previous blog we discussed about&nbsp;Migration of Banks from QuickBooks to Sage 300 ERP. In this blog we will discuss about how QuickBooks\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-30T04:17:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-26T05:35:39+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/\",\"name\":\"Migrate Item Masters from QuickBooks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\",\"datePublished\":\"2014-07-30T04:17:30+00:00\",\"dateModified\":\"2019-12-26T05:35:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate Item Masters from QuickBooks to Sage 300 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":"Migrate Item Masters from QuickBooks to Sage 300 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\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Migrate Item Masters from QuickBooks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"We provide data Migration Services from QuickBooks to Sage 300 ERP (formerly known as Sage&nbsp;Accpac) at our Sage Migration Center. This blog is in continuation to our GUMU&#x2122; ERP Migration services. In our previous blog we discussed about&nbsp;Migration of Banks from QuickBooks to Sage 300 ERP. In this blog we will discuss about how QuickBooks\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-07-30T04:17:30+00:00","article_modified_time":"2019-12-26T05:35:39+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/","name":"Migrate Item Masters from QuickBooks to Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg","datePublished":"2014-07-30T04:17:30+00:00","dateModified":"2019-12-26T05:35:39+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/13.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/30\/migrate-item-masters-from-quickbooks-to-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Migrate Item Masters from QuickBooks to Sage 300 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\/8187","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=8187"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8187\/revisions"}],"predecessor-version":[{"id":27400,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8187\/revisions\/27400"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=8187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=8187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=8187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}