{"id":1749,"date":"2018-02-26T05:22:45","date_gmt":"2018-02-26T05:22:45","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1749"},"modified":"2025-06-05T09:49:11","modified_gmt":"2025-06-05T09:49:11","slug":"available-options-to-migrate-vendor-masters-into-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/","title":{"rendered":"Available options to migrate vendor masters into Sage 100 ERP"},"content":{"rendered":"\n

GUMU™ for Sage 50 US (Peachtree<\/em>) to Sage 100 ERP 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\n\n\n

In this blog we would discuss about the available options to convert Vendor masters into Sage 100 ERP. We convert masters by using below mentioned methods from Sage 50 US (Peachtree), Sage 50 CAD (Simply Accounting), QuickBooks. In this blog we have taken the example of Sage 50 US (Peachtree<\/em>).<\/p>\n\n\n\n

New Stuff:<\/strong><\/em><\/span> Number of ways to migrate AR Customer into Sage 300 ERP<\/a><\/p>\n\n\n\n

Now, we will discuss about migrating masters into Sage 100 ERP. Unlike Sage 50 US (Peachtree) every vendor defined in Sage Accpac ERP™ needs to have a vendor code. In migration process GUMU allows you to generate vendor codes for Vendors using three methods:<\/p>\n\n\n\n

    \n
  1. Auto Number:<\/strong> Numeric vendor numbers automatically gets generated using a user defined starting number and a user defined increment.
    Say for e.g. if you want to assign fist vendor code as 1000 and next code should get generated by 10 then it would look like as 1010, 1020 and so on.<\/li>\n\n\n\n
  2. Company Initials:<\/strong> Vendor numbers are generated using first three initials of company name and next three characters will be a number.
    For example code for \u201cBank of America\u201d will be BA001 and “Bank of Australia” will be BA002.<\/li>\n\n\n\n
  3. Company Name:<\/strong> Vendor numbers are generated using first N (N is user defined value) characters of company name. For example code for \u201cBank of America\u201d will be \u201cBAN001\u201d and “Bank of Australia” will be “BAN002” if user selected first 3 characters of company name to be used.<\/li>\n\n\n\n
  4. Peachtree Vendor ID:<\/strong> Vendor numbers are generated as it exist in Sage 50 US (Peachtree<\/em>) company data.<\/li>\n<\/ol>\n\n\n
    \n
    \"\"<\/a><\/figure><\/div>\n\n\n

    Note:<\/strong> As per the Sage 300 standard functionality it would allow to enter only up to 12 characters for vendor code.<\/p>\n\n\n\n

    In this way, Sage 50 US Vendor masters is migrated into target Sage 300 ERP company database. In our Next Blog we will discuss about another method of generating Vendor Number.<\/p>\n\n\n\n

    About Us<\/strong><\/span>
    Greytrix<\/a>  a 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\n\n\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\n\n\n

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

    GUMU™ for Sage 50 US (Peachtree) to Sage 100 ERP 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\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":[124],"tags":[286,300,342,356,387],"class_list":["post-1749","post","type-post","status-publish","format-standard","hentry","category-mas90","tag-erpmig","tag-gumu-2","tag-mas90","tag-migrate-vendor","tag-sage-100-erp"],"yoast_head":"\nMigrate Vendor Masters to Sage 100 ERP Easily<\/title>\n<meta name=\"description\" content=\"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.\" \/>\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\/02\/26\/available-options-to-migrate-vendor-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=\"Migrate Vendor Masters to Sage 100 ERP Easily\" \/>\n<meta property=\"og:description\" content=\"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-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-02-26T05:22:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-05T09:49:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.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\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/\",\"name\":\"Migrate Vendor Masters to Sage 100 ERP Easily\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg\",\"datePublished\":\"2018-02-26T05:22:45+00:00\",\"dateModified\":\"2025-06-05T09:49:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-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\":\"Available options to migrate vendor 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":"Migrate Vendor Masters to Sage 100 ERP Easily","description":"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.","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\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"Migrate Vendor Masters to Sage 100 ERP Easily","og_description":"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2018-02-26T05:22:45+00:00","article_modified_time":"2025-06-05T09:49:11+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.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\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/","name":"Migrate Vendor Masters to Sage 100 ERP Easily","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg","datePublished":"2018-02-26T05:22:45+00:00","dateModified":"2025-06-05T09:49:11+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Learn the best options to migrate vendor master data into Sage 100 ERP. Ensure a smooth, efficient, and accurate data migration with this helpful guide.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-masters-into-sage-100-erp\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/02\/Same-as-Sage-50-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/02\/26\/available-options-to-migrate-vendor-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":"Available options to migrate vendor 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\/1749","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=1749"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1749\/revisions"}],"predecessor-version":[{"id":6340,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1749\/revisions\/6340"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}