{"id":100,"date":"2009-10-07T09:44:00","date_gmt":"2009-10-07T09:44:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=100"},"modified":"2025-04-23T06:59:06","modified_gmt":"2025-04-23T06:59:06","slug":"gl-merge-utility","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/","title":{"rendered":"GL Merge Utility in Sage 100"},"content":{"rendered":"\n<p>Are you in a situation where you have duplicate activities &amp; transactions for different GL Accounts in your MAS 500 system? This is a very common occurrence while importing transactions (Purchase Orders, AP Invoices etc) through a web application or an integration link.<\/p>\n\n\n\n<p>Do you want to eliminate these duplicate activities &amp; transactions then, we at Greytrix have a utility called <b>\u2018GL Merge Utility\u2019<\/b> where user can combined different GL accounts into a single account. The arduous task of merging all these entries for one account can now be done in a instant by the \u2018GL Merge Utility\u2019. Please refer the below screenshot.<\/p>\n\n\n\n<p><img fetchpriority=\"high\" decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5389793325346415858\" title=\"GL Account Merge\" width=\"320\" height=\"214\" border=\"0\" class=\"alignnone\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 320px; height: 214px;\" src=\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG\" alt=\"GL Account Merge\"><br>From the above screen user can select the Target GL Account and then pick the multiple GL Accounts to be merged.<\/p>\n\n\n\n<p>Using the GL Merge utility the following features will be available:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Merges multiple GL Accounts into a single account.<\/li>\n\n\n\n<li>While merging process, the master data and history transactions will be merged so that no data is lost.<\/li>\n\n\n\n<li>By merging multiple GL accounts into a single destination account, you can eliminate duplicate activity or combine similar transactions into one account.<\/li>\n\n\n\n<li>After the merging process is completed then the \u2018GL Recalculate History\u2019 utility of a standard MAS 500 system will be executed to maintain the data effectiveness.<\/li>\n<\/ul>\n\n\n\n<p>If you feel you could be benefited from such a utility then feel free to contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>.<\/p>\n\n\n\n<p><strong>About Us<\/strong><br><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;is a 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\n\n\n<p>Greytrix&nbsp;has some unique solutions of&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a>&nbsp;along with&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services&nbsp;<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n\n\n\n<p>For more details on Sage 100 Services, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you in a situation where you have duplicate activities &amp; transactions for different GL Accounts in your MAS 500 system? This is a very common occurrence while importing transactions (Purchase Orders, AP Invoices etc) through a web application or an integration link. Do you want to eliminate these duplicate activities &amp; transactions then, we\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/\">Read More &raquo;<\/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":[81,130,219],"tags":[],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-general-ledger","category-merging","category-utility"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>In Sage 100, the GL Merge Utility<\/title>\n<meta name=\"description\" content=\"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.\" \/>\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\/2009\/10\/07\/gl-merge-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In Sage 100, the GL Merge Utility\" \/>\n<meta property=\"og:description\" content=\"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-10-07T09:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-23T06:59:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.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=\"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\/2009\/10\/07\/gl-merge-utility\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/\",\"name\":\"In Sage 100, the GL Merge Utility\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG\",\"datePublished\":\"2009-10-07T09:44:00+00:00\",\"dateModified\":\"2025-04-23T06:59:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage\",\"url\":\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG\",\"contentUrl\":\"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GL Merge Utility in Sage 100\"}]},{\"@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":"In Sage 100, the GL Merge Utility","description":"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.","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\/2009\/10\/07\/gl-merge-utility\/","og_locale":"en_US","og_type":"article","og_title":"In Sage 100, the GL Merge Utility","og_description":"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2009-10-07T09:44:00+00:00","article_modified_time":"2025-04-23T06:59:06+00:00","og_image":[{"url":"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG","type":"","width":"","height":""}],"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\/2009\/10\/07\/gl-merge-utility\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/","name":"In Sage 100, the GL Merge Utility","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage"},"thumbnailUrl":"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG","datePublished":"2009-10-07T09:44:00+00:00","dateModified":"2025-04-23T06:59:06+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Find out what happens when you have duplicate activities and transactions for distinct GL Accounts in your MAS 500 system.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#primaryimage","url":"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG","contentUrl":"https:\/\/3.bp.blogspot.com\/_A6_b0zkYeSY\/SsxkeRoLZPI\/AAAAAAAAAmU\/AMVx9fqqEI0\/s320\/Merge+GL+Accounts.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/10\/07\/gl-merge-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"GL Merge Utility in Sage 100"}]},{"@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\/100","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=100"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":6225,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/100\/revisions\/6225"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}