{"id":2769,"date":"2018-05-21T06:47:51","date_gmt":"2018-05-21T06:47:51","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=2769"},"modified":"2025-06-04T10:45:18","modified_gmt":"2025-06-04T10:45:18","slug":"merging-of-vendor-masters-into-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/","title":{"rendered":"Merging of vendor masters into Sage 100 ERP"},"content":{"rendered":"

GUMU™ for Sage 50 US (Peachtree) to Sage 300 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

In this blog, we would discuss the merging of Vendor 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 US ERP.<\/p>\n

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

In, a continuation of our previous blog, here we would discuss merging of multiple vendors into a single vendor. Generally, this gets needed if the user in source ERP system created multiple vendor masters records for the same vendor. So in such case, if they want to maintain the single vendor record for duplicate masters then they can opt for the merging process during vendor number mapping.<\/p>\n

In our migration process, we do incorporate this requirement through User defined mapping process. Let\u2019s elaborate this in a detail with an example – we have 2 vendors with different codes but with similar or different names and users want to merge these vendors into a single Vendor master record with \u2018AMEX\u2019.<\/p>\n

For this requirement, we do send the template vendor 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 Vendor Number, Sage 50 Vendor Name, Sage 100 ERP Vendor Code and Sage 100 ERP Vendor Name. We expect the filled sheet from client wherein he needs to fill their desired vendor masters code and their names as they want to convert into Sage 100 ERP against the existing Sage 50 Vendor details. The vendors which they want to merge into target ERP system should have mentioned the same \u2018Sage 100 Vendor number\u2019 into mapping sheet as shown below.<\/p>\n

\"vendor<\/p>\n

Once we receive the filled sheet from the client, we process them accordingly into migration and client\u2019s desired vendor number gets merged into Sage 100 and their transactions also get migrated against single vendor into target Sage 100 ERP.<\/p>\n

In this way, Sage 50 Vendor masters get merged and migrated into target Sage 100 ERP company database.
\n
\nAbout Us<\/strong>
\nGreytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide 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>\u00a0has some unique solutions of\u00a0Sage 100 integration with Sage CRM<\/a>,\u00a0and Salesforce.com\u00a0<\/a> along with Sage 100 Migration from Sage 50 US, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more details on Sage 100 Services, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

GUMU™ for Sage 50 US (Peachtree) to Sage 300 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":[122,175],"tags":[],"class_list":["post-2769","post","type-post","status-publish","format-standard","hentry","category-mas-90200","category-sage-100"],"yoast_head":"\nMerging Vendor Masters into Sage 100 ERP<\/title>\n<meta name=\"description\" content=\"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.\" \/>\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\/05\/21\/merging-of-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=\"Merging Vendor Masters into Sage 100 ERP\" \/>\n<meta property=\"og:description\" content=\"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-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-05-21T06:47:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T10:45:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.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\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/\",\"name\":\"Merging Vendor Masters into Sage 100 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg\",\"datePublished\":\"2018-05-21T06:47:51+00:00\",\"dateModified\":\"2025-06-04T10:45:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-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\":\"Merging of 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":"Merging Vendor Masters into Sage 100 ERP","description":"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.","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\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"Merging Vendor Masters into Sage 100 ERP","og_description":"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2018-05-21T06:47:51+00:00","article_modified_time":"2025-06-04T10:45:18+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.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\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/","name":"Merging Vendor Masters into Sage 100 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg","datePublished":"2018-05-21T06:47:51+00:00","dateModified":"2025-06-04T10:45:18+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Learn how to merge vendor masters into Sage 100 ERP efficiently to streamline vendor data, reduce duplicates, and improve your business\u2019s financial management.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-vendor-masters-into-sage-100-erp\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2018\/05\/Sage-100-Vendor-mapping-3.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/05\/21\/merging-of-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":"Merging of 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\/2769","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=2769"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/2769\/revisions"}],"predecessor-version":[{"id":3001,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/2769\/revisions\/3001"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=2769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=2769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=2769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}