{"id":3715,"date":"2013-08-26T09:15:28","date_gmt":"2013-08-26T09:15:28","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3715"},"modified":"2025-09-22T09:17:54","modified_gmt":"2025-09-22T09:17:54","slug":"gl-clearing-module-for-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/","title":{"rendered":"GL Clearing Module for Sage 300 ERP"},"content":{"rendered":"<p>General Ledger (GL) module is heart of any finance package such as ERP system. Hence, to give an upper hand to user while using GL, we have developed a custom module named <b>GL Clearing Module for Sage 300 ERP, <\/b>which will help users to carry out internal reconciliation of GL Accounts i.e. to match Debit and Credit side of Transactions in GL.<br \/>\nSay for an instance, when user creates a PO Receipt Transaction, it will debit Inventory and Credit Payable Clearing Account. Thereafter, PO Invoice will debit Payable Clearing and Credit Payable Account.<br \/>\nHence, after Day end Processing these transaction are reflected in GL. User can view debit, credit balance for a particular account and map the same as desired using our GL Clearing module.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-3716\" alt=\"GL Clearing\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\" width=\"509\" height=\"405\" \/><\/a><\/p>\n<p><em><span style=\"color: #993300\"><strong>The New Stuff:<\/strong><\/span>\u00a0<a title=\"Greytrix Extended Report Pack for Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/26\/greytrix-extended-report-pack-for-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Greytrix Extended Report Pack for Sage 300 ERP<\/a><\/em><br \/>\nOnce user select a GL Account No, he\/she will be able to view GL Details\u00a0 (Batch\/Entry No, Line no,Transaction Date, PO Transaction Document No., Debit\/Credit Amount in both source and Functional Currency)<br \/>\nUser can select individual detail line manually for mapping. There is also a provision of mass clearing by importing an excel file in a specific format, which will select multiple detail line at once for mapping.<br \/>\nSystem will allow not allow Users to save any entry that is out of balance; it will only save document when credit and debit are matching.<br \/>\nUsers can also print GL Clearing Report to view Reconcilled transaction\/Non-Reconcilled transaction\/Both for specific GL Account.<br \/>\nBefore periodic closure of a GL Account, Accounting staff must ensure that entries in the general ledger need to be correct and are in balance. Thus, GL Clearing Module comes handy for user and become really useful when user needs to store mapping of GL Accounts transaction.<br \/>\n<strong>Also Read:<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>1.<\/strong>\u00a0<a title=\"Replace Optional Fields in GL Accounts of Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/replace-optional-fields-in-gl-accounts-of-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Replace Optional Fields in GL Accounts of Sage 300 ERP<\/a><br \/>\n<strong>2.<\/strong>\u00a0<a title=\"Exclude Inactive Accounts option in GL Chart of Accounts Report of Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/exclude-inactive-accounts-option-in-gl-chart-of-accounts-report-of-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Exclude Inactive Accounts option in GL Chart of Accounts Report of Sage 300 ERP<\/a><br \/>\n<strong>3.<\/strong>\u00a0<a title=\"Financial Reporter made reporting tranquil in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Financial Reporter made reporting tranquil in Sage 300 ERP<\/a><br \/>\n<strong>4.<\/strong>\u00a0<a title=\"GL Account Code Change in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/02\/gl-account-code-change-in-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">GL Account Code Change in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>General Ledger (GL) module is heart of any finance package such as ERP system. Hence, to give an upper hand to user while using GL, we have developed a custom module named GL Clearing Module for Sage 300 ERP, which will help users to carry out internal reconciliation of GL Accounts i.e. to match Debit\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\">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":[2],"tags":[1051,1064,1094,1737,2189,2357,2451],"class_list":["post-3715","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-gl-account","tag-gl-clearing","tag-gl-reconcillation","tag-non-reconcilled-transactions","tag-reconcilled-transactions","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GL Clearing Module for Sage 300 ERP | Greytrix<\/title>\n<meta name=\"description\" content=\"Streamline GL account reconciliation in Sage 300 ERP with Greytrix&#039;s GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.\" \/>\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\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GL Clearing Module for Sage 300 ERP | Greytrix\" \/>\n<meta property=\"og:description\" content=\"Streamline GL account reconciliation in Sage 300 ERP with Greytrix&#039;s GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-26T09:15:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-22T09:17:54+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\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\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\",\"name\":\"GL Clearing Module for Sage 300 ERP | Greytrix\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\",\"datePublished\":\"2013-08-26T09:15:28+00:00\",\"dateModified\":\"2025-09-22T09:17:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Streamline GL account reconciliation in Sage 300 ERP with Greytrix's GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GL Clearing Module for Sage 300 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GL Clearing Module for Sage 300 ERP | Greytrix","description":"Streamline GL account reconciliation in Sage 300 ERP with Greytrix's GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.","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\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"GL Clearing Module for Sage 300 ERP | Greytrix","og_description":"Streamline GL account reconciliation in Sage 300 ERP with Greytrix's GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-08-26T09:15:28+00:00","article_modified_time":"2025-09-22T09:17:54+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/","name":"GL Clearing Module for Sage 300 ERP | Greytrix","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png","datePublished":"2013-08-26T09:15:28+00:00","dateModified":"2025-09-22T09:17:54+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Streamline GL account reconciliation in Sage 300 ERP with Greytrix's GL Clearing Module. Map debit\/credit entries, import via Excel, and generate reports.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/GL-Clearing.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/26\/gl-clearing-module-for-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"GL Clearing Module for Sage 300 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=3715"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3715\/revisions"}],"predecessor-version":[{"id":36335,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3715\/revisions\/36335"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}