{"id":1802,"date":"2018-03-12T11:14:13","date_gmt":"2018-03-12T11:14:13","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1802"},"modified":"2025-06-04T11:23:51","modified_gmt":"2025-06-04T11:23:51","slug":"user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/","title":{"rendered":"User-defined options to migrate Customer masters into Sage 100 ERP"},"content":{"rendered":"<p>GUMU&#x2122; for is a Sage certified Migration solution. Greytrix is a pioneer in providing Migration services at its Sage Migration Center and catering end-user business requirements. We at Greytrix are focused to help the client in successfully implementing the new Sage 100 ERP system through our various successful migration and integration solutions.<\/p>\n<p>In this blog, we would discuss the User-defined options to convert Customer masters into Sage 100 ERP. We convert masters by using below-mentioned method from Sage 50 US (Peachtree), QuickBooks. In this blog, we have taken the example of Sage 50 ERP.<\/p>\n<p><em><strong>\u00a0New Stuff:<\/strong><\/em>\u00a0<a href=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/02\/23\/user-defined-options-to-migrate-item-masters-into-sage-300-erp\/\">User-defined options to migrate Item masters into Sage 300 ERP \u00a0<\/a><\/p>\n<p>In continuation of our previous blog here, we would discuss another method for Customer Number Generation referred as \u2018User defined Mapping\u2019. While performing migration process, we receive different requirement from clients to assign the specific numbering to Customer masters into in Sage 100 Company.<\/p>\n<p>So in order to incorporate the custom numbering for Customers, we do send the template Customer number mapping sheet to our client before proceeding with the migration process. The format of the sheet is as below which contains the columns \u2013 Sage 50 Customer Number, Sage 50 Customer Name, Sage 100 ERP Customer Number and Sage 100 ERP Customer Name. We expect the filled sheet from client wherein he needs to fill their desired Customer masters code and their names as they want to get converted into Sage 100 ERP against the existing Sage 50 Customer details.<\/p>\n<p><img decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg\" alt=\"Customer masters code and their names as they want to get converted into Sage 100 ERP against the existing Sage 50 Customer details.\" width=\"773\" height=\"64\" \/><\/p>\n<p>Once we receive the filled sheet from the client, we process them accordingly into migration and client\u2019s desired Customer number gets assigned\/created into Sage 100 and same gets assigned to their respective transactions.<\/p>\n<p>In this way, Sage 50 Customer masters are migrated to target Sage 100 ERP company database.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u00a0a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> helps in Sage ERP and CRM upgrades to the latest version and migration for <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/migrate-qb-sage-erp-to-sage-intacct\">Sage Intacct from Sage 300, Sage 100, Sage 50 and QuickBooks<\/a>; for Sage 100, Sage 300 (Sage Accpac), Sage Enterprise Management (Sage X3) from <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-pro-sage-300-migration\">Sage Pro<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-50-us-sage-300-migration\">Sage 50 US<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-50-ca-sage-300-migration\">Sage 50 CA<\/a>, <a href=\"https:\/\/www.greytrix.com\/resources\/sage-erp-crm-migration.pdf\">Sage 50 Usage Business Works, Sage Business Vision<\/a> and <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>; for Sage CRM from <a href=\"https:\/\/www.greytrix.com\/resources\/sage-erp-crm-migration.pdf\">Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer<\/a><\/p>\n<p>For more information on Sage ERP \u2013 CRM migration solutions, please contact us at\u00a0<a href=\"mailto:erpmig@greytrix.com\">erpmig@greytrix.com<\/a>.\u00a0We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GUMU&#x2122; for is a Sage certified Migration solution. Greytrix is a pioneer in providing Migration services at its Sage Migration Center and catering end-user business requirements. We at Greytrix are focused to help the client in successfully implementing the new Sage 100 ERP system through our various successful migration and integration solutions. In this blog,\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\">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":[115],"tags":[239,380,406],"class_list":["post-1802","post","type-post","status-publish","format-standard","hentry","category-mas","tag-ar-customer","tag-sage-100","tag-sage-50"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>User-Defined Options to Migrate Customer Masters in Sage 100<\/title>\n<meta name=\"description\" content=\"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.\" \/>\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\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"User-Defined Options to Migrate Customer Masters in Sage 100\" \/>\n<meta property=\"og:description\" content=\"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-12T11:14:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T11:23:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\",\"name\":\"User-Defined Options to Migrate Customer Masters in Sage 100\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg\",\"datePublished\":\"2018-03-12T11:14:13+00:00\",\"dateModified\":\"2025-06-04T11:23:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User-defined options to migrate Customer masters into Sage 100 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"User-Defined Options to Migrate Customer Masters in Sage 100","description":"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.","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\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/","og_locale":"en_US","og_type":"article","og_title":"User-Defined Options to Migrate Customer Masters in Sage 100","og_description":"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2018-03-12T11:14:13+00:00","article_modified_time":"2025-06-04T11:23:51+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/","name":"User-Defined Options to Migrate Customer Masters in Sage 100","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg","datePublished":"2018-03-12T11:14:13+00:00","dateModified":"2025-06-04T11:23:51+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Learn how to migrate customer masters into Sage 100 ERP using user-defined options for accurate data import and efficient customer management processes.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/A-4.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/12\/user-defined-options-to-migrate-customer-masters-into-sage-100-erp1802\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"User-defined options to migrate Customer masters into Sage 100 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=1802"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1802\/revisions"}],"predecessor-version":[{"id":6381,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1802\/revisions\/6381"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}