{"id":1832,"date":"2018-03-14T07:09:04","date_gmt":"2018-03-14T07:09:04","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1832"},"modified":"2025-06-04T11:06:19","modified_gmt":"2025-06-04T11:06:19","slug":"user-defined-options-to-migrate-item-masters-into-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/","title":{"rendered":"User-defined options to migrate Item masters into Sage 100 ERP"},"content":{"rendered":"

GUMU™ 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

In this blog, we would discuss the User-defined options to convert Item masters into Sage 100 ERP. We convert masters by using below-mentioned methods from Sage 50 US (Peachtree), QuickBooks. In this blog, we have taken the example of Sage 50 ERP.<\/p>\n

\u00a0New Stuff:\u00a0<\/strong><\/em>Available options to migrate Item into Sage 100 ERP<\/a><\/p>\n

In continuation of our previous blog here, we would discuss another method for Item Number Generation referred as \u2018User defined Mapping\u2019. While performing migration process, we receive different requirement from clients to assign the specific numbering to Item masters into in Sage 100 Company.<\/p>\n

So in order to incorporate the custom numbering for Items, we do send the template Item 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 Item Number, Sage 50 Item Name, Sage 100 ERP Item Number and Sage 100 ERP Item Name. We expect the filled sheet from client wherein he needs to fill their desired Item masters code and their names as they want to get converted into Sage 100 ERP against the existing Sage 50 Item details.<\/p>\n

\"define<\/p>\n

Note:<\/strong> As per the Sage 100 standard functionality it would allow entering only up to 15 characters for Item code.<\/p>\n

Once we receive the filled sheet from the client, we process them accordingly into migration and client\u2019s desired Item number gets assigned\/created into Sage 100 and same gets assigned to their respective transactions.<\/p>\n

In this way, Sage 50 Item masters are migrated to target Sage 100 ERP company database.<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/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

Greytrix<\/a> helps in Sage ERP and CRM upgrades to the latest version and migration for 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 Sage Pro<\/a>, Sage 50 US<\/a>, Sage 50 CA<\/a>, Sage 50 Usage Business Works, Sage Business Vision<\/a> and QuickBooks<\/a>; for Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer<\/a><\/p>\n

For more information on Sage ERP \u2013 CRM migration solutions, please contact us at\u00a0erpmig@greytrix.com<\/a>.\u00a0We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

GUMU™ 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 Read More »<\/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":[187],"tags":[],"class_list":["post-1832","post","type-post","status-publish","format-standard","hentry","category-sage-mas-90200-erp"],"yoast_head":"\nUser-Defined Options to Migrate Item Masters in Sage 100 ERP<\/title>\n<meta name=\"description\" content=\"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.\" \/>\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\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/\" \/>\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 Item Masters in Sage 100 ERP\" \/>\n<meta property=\"og:description\" content=\"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-14T07:09:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T11:06:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png\" \/>\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\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/\",\"name\":\"User-Defined Options to Migrate Item Masters in Sage 100 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png\",\"datePublished\":\"2018-03-14T07:09:04+00:00\",\"dateModified\":\"2025-06-04T11:06:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#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 Item 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 Item Masters in Sage 100 ERP","description":"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.","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\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"User-Defined Options to Migrate Item Masters in Sage 100 ERP","og_description":"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2018-03-14T07:09:04+00:00","article_modified_time":"2025-06-04T11:06:19+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png","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\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/","name":"User-Defined Options to Migrate Item Masters in Sage 100 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png","datePublished":"2018-03-14T07:09:04+00:00","dateModified":"2025-06-04T11:06:19+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Learn how to migrate item masters into Sage 100 ERP using user-defined options for accurate data transfer and efficient inventory management during system migration.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/03\/item-user-define.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/03\/14\/user-defined-options-to-migrate-item-masters-into-sage-100-erp\/#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 Item 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\/1832","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=1832"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1832\/revisions"}],"predecessor-version":[{"id":2989,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1832\/revisions\/2989"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}