{"id":1646,"date":"2018-01-02T10:47:36","date_gmt":"2018-01-02T10:47:36","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1646"},"modified":"2025-06-05T10:56:19","modified_gmt":"2025-06-05T10:56:19","slug":"number-of-ways-to-migrate-ar-customer-into-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/","title":{"rendered":"Available option to migrate AR customer into Sage 100 ERP"},"content":{"rendered":"

Our GUMU™ Migration Utility converts data from various legacy system to Sage ERP Systems such as Sage 100 (Sage MAS 90\/200), Sage 300 (Sage Accpac ERP) and gives users a smoother data conversion experience.<\/p>\n

In our migration services we migrate GL masters and historical transactions, bank masters and opening balance, tax masters, AR masters and open receivables along with Transaction History, AP masters and open payables along with transaction history.<\/p>\n

In this blog, we will discuss the number of ways to migrate the AR Customer<\/strong> from various source ERP to Target Sage 100 ERP. The source ERP can be Sage 50 US or QuickBooks,<\/p>\n

The ways of migrating AR Customer into Sage 100 ERP are following below:<\/strong><\/p>\n

    \n
  1. Auto-number<\/li>\n
  2. Same as source ERP<\/li>\n<\/ol>\n

    Generating AR Customer by Auto Number:<\/strong><\/p>\n

      \n
    1. Generating by numeric auto number<\/strong>: A numeric customer code will be generated automatically using the starting number and increment by any number that client define.
      \nExample<\/strong>: Numeric AR customer code can be generated using starting number 1000 and increment by 10. i.e. 1000, 1010, 1020\u2026 etc.<\/li>\n
    2. Generate Auto Number by Name of initials<\/strong>: Customer codes are generated using the first three initials of its name and next three characters will be number.
      \nExample<\/strong>: Code for \u2018Coastal Electric Company\u2019 will be CEC001.<\/li>\n
    3. Generate Auto number by Name: <\/strong>Customer codes are generated using the first three letter of its name and next three characters will be number.
      \nExample<\/strong>: Code for \u2018Coastal Electric Company\u2019 will be COA001.<\/li>\n<\/ol>\n

      Here we will discuss in detail how we migrate AR customer same as source ERP<\/strong>:<\/p>\n

      In Sage 300 the maximum length of customer code is \u201812\u2019. So the first 12 character of AR Customer convert in Sage 300 ERP. If longer customer code exists then it will be truncated to 12 characters. If the result in duplicate customer code then results will append by 1,2.<\/p>\n

      Example: <\/strong>Code for \u2018Coastal Electric Company\u2019 and \u2018Coastal Electronics\u2019 will Coastal El-1, Coastal El-2.<\/p>\n

      About Us<\/strong><\/span>
      \nGreytrix<\/a>\u00a0is 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>\u00a0helps in migrating to Sage 100, Sage 300 and Sage ERP X3 from\u00a0Sage Pro<\/a>,\u00a0Sage 50 US<\/a>,\u00a0Sage 50 CA<\/a>, Sage Business Works, Sage Business Vision,\u00a0<\/u>QuickBooks<\/a>\u00a0<\/u>and MS Dynamics Great Plains.<\/p>\n

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

      Our GUMU™ Migration Utility converts data from various legacy system to Sage ERP Systems such as Sage 100 (Sage MAS 90\/200), Sage 300 (Sage Accpac ERP) and gives users a smoother data conversion experience. In our migration services we migrate GL masters and historical transactions, bank masters and opening balance, tax masters, AR masters and\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":[13],"tags":[],"class_list":["post-1646","post","type-post","status-publish","format-standard","hentry","category-ar-option"],"yoast_head":"\nWays to Migrate AR Customer Data into Sage 100 ERP<\/title>\n<meta name=\"description\" content=\"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.\" \/>\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\/01\/02\/number-of-ways-to-migrate-ar-customer-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=\"Ways to Migrate AR Customer Data into Sage 100 ERP\" \/>\n<meta property=\"og:description\" content=\"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-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-01-02T10:47:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-05T10:56:19+00:00\" \/>\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=\"2 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\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/\",\"name\":\"Ways to Migrate AR Customer Data into Sage 100 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"datePublished\":\"2018-01-02T10:47:36+00:00\",\"dateModified\":\"2025-06-05T10:56:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-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 option to migrate AR customer 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":"Ways to Migrate AR Customer Data into Sage 100 ERP","description":"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.","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\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"Ways to Migrate AR Customer Data into Sage 100 ERP","og_description":"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2018-01-02T10:47:36+00:00","article_modified_time":"2025-06-05T10:56:19+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/","name":"Ways to Migrate AR Customer Data into Sage 100 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"datePublished":"2018-01-02T10:47:36+00:00","dateModified":"2025-06-05T10:56:19+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Explore different methods to migrate AR customer data into Sage 100 ERP. Ensure smooth and accurate migration with the best approach for your business needs.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-into-sage-100-erp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2018\/01\/02\/number-of-ways-to-migrate-ar-customer-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 option to migrate AR customer 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\/1646","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=1646"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1646\/revisions"}],"predecessor-version":[{"id":3031,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1646\/revisions\/3031"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}