{"id":9376,"date":"2014-12-31T09:31:41","date_gmt":"2014-12-31T09:31:41","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=9376"},"modified":"2023-10-04T06:58:37","modified_gmt":"2023-10-04T06:58:37","slug":"configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/","title":{"rendered":"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version"},"content":{"rendered":"

Our GUMU for Sage CRM \u2013 Sage 100 ERP integration supports and can work with both Sage 100 ERP versions ProvideX<\/strong> and SQL<\/strong>.\u00a0 Configuration of GUMU is almost similar in both the cases with just one minor change.
\nIn this blog post, we will discuss steps which need to be followed for making GUMU Sage CRM \u2013 Sage100 ERP integration work with SQL version of Sage 100 ERP.
\nNew Stuff<\/strong><\/span>: Creating Sage 100 ERP Primary contact from sage CRM<\/a>
\nBelow is the list of changes:
\n1.\u00a0\u00a0 Changes at Sage CRM side<\/strong><\/span>: Basic configuration from Sage CRM side will be similar for both ProvideX Sage 100 and SQL Sage 100 which is already mentioned in our previous blog<\/a>. The only difference in Sage 100 SQL version is,\u00a0 we need to provide values for below fields in configuration screen:
\na.\u00a0 SQL Server name:<\/strong>\u00a0 SQL Server instance name where the Sage 100 ERP database resides.
\nb.\u00a0 SQL Company Instance Name<\/strong>: Sage 100 SQL Database name for the Sage 100 ERP company code which needs to be integrated.
\nc.In case, if Sage 100 ERP is of providex version, we can keep the above 2 fields as blank.
\n\"Image01\"<\/a><\/p>\n

2.\u00a0\u00a0 Changes at Sage 100 ERP Side<\/strong><\/span>:\u00a0 For Sage 100 ERP side configuration, we will have to follow the steps as mentioned in Steps to install GUMU Sage 100 module <\/a>blog post.
\nThe only step which is different for Sage 100 SQL backend is instead of updating GT_Options.M4T<\/strong> from data file display<\/strong>, we need to update it using SQL query in Sage 100 SQL database.\u00a0 Please follow below steps for the same:
\na.\u00a0\u00a0 Login to SQL.
\nb.\u00a0\u00a0 In query window, run below SQL command
\nUpdate GT_Options set NewSystem = ‘N’
\n\"Image02\"<\/a>
\n<\/em>
\nRest all the steps will be exactly the same as mentioned in the blog link<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Our GUMU for Sage CRM \u2013 Sage 100 ERP integration supports and can work with both Sage 100 ERP versions ProvideX and SQL.\u00a0 Configuration of GUMU is almost similar in both the cases with just one minor change. In this blog post, we will discuss steps which need to be followed for making GUMU Sage\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":[73,192,332],"tags":[740,1238,1286,1435,1972,2338],"class_list":["post-9376","post","type-post","status-publish","format-standard","hentry","category-configuration","category-integration-sage-crm","category-sage-crm","tag-configuration","tag-gumu","tag-gumumas","tag-integration","tag-sage-100-sql","tag-sql-version"],"yoast_head":"\nConfiguring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components<\/title>\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\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Our GUMU for Sage CRM \u2013 Sage 100 ERP integration supports and can work with both Sage 100 ERP versions ProvideX and SQL.\u00a0 Configuration of GUMU is almost similar in both the cases with just one minor change. In this blog post, we will discuss steps which need to be followed for making GUMU Sage\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-31T09:31:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-04T06:58:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/\",\"name\":\"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png\",\"datePublished\":\"2014-12-31T09:31:41+00:00\",\"dateModified\":\"2023-10-04T06:58:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components","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\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/","og_locale":"en_US","og_type":"article","og_title":"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Our GUMU for Sage CRM \u2013 Sage 100 ERP integration supports and can work with both Sage 100 ERP versions ProvideX and SQL.\u00a0 Configuration of GUMU is almost similar in both the cases with just one minor change. In this blog post, we will discuss steps which need to be followed for making GUMU Sage\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-12-31T09:31:41+00:00","article_modified_time":"2023-10-04T06:58:37+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/","name":"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png","datePublished":"2014-12-31T09:31:41+00:00","dateModified":"2023-10-04T06:58:37+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/Image013.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/31\/configuring-gumu-sage-100-erp-integration-with-sage-100-erp-sql-version\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Configuring GUMU Sage 100 ERP integration with Sage 100 ERP SQL version"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=9376"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9376\/revisions"}],"predecessor-version":[{"id":27797,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9376\/revisions\/27797"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=9376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=9376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=9376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}