{"id":3839,"date":"2013-09-03T09:28:20","date_gmt":"2013-09-03T09:28:20","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3839"},"modified":"2025-09-22T09:31:57","modified_gmt":"2025-09-22T09:31:57","slug":"auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/","title":{"rendered":"Auto Generate Document Number in GL Clearing module for Sage 300 ERP"},"content":{"rendered":"

In our previous blog, we introduced \u201cGL Clearing module for Sage 300 ERP<\/a>\u201d<\/b>. Now, we will be discussing about how to generate Document Number<\/b> automatically with pre-define structure in Document Number Generation screen in GL clearing module.
\nThere are some mandatory fields like \u201cFiscal Year\u201d, \u201cPrefix\u201d and \u201cNext Number\u201d to generate document number. So, user has to set these values before generating document number.<\/p>\n

– MRP Report in Sage 300 ERP<\/a>\u00a0–<\/em>
\n – Pending Order Aging Report in Sage 300 ERP<\/a>\u00a0–<\/em><\/p>\n

\"Document<\/a><\/p>\n

Module automatically selects current fiscal year<\/b> from Session Date for generating document number. As a result, user has to set PREFIX<\/b> and Next number <\/b>in \u201cDocument Number Generation\u201d screen. <\/b>Once, entire configuration is done in the Document Number Generation screen, module generates number based on the configuration done.<\/b>
\nSay for an instance; current fiscal year is 2013<\/b>, user has entered prefix as DOC<\/b> and next number as 1<\/b>. Hence, when user does a GL Audit through GL clearing module DOC-2013-00000001 <\/b>will be generated.<\/p>\n

\"GL<\/a><\/p>\n

Now, user does not have to worry about the next document number, the module automatically generates the next document number during the next GL auditing through GL clearing module.
\nIn our next blog, we will discuss on the reporting part for GL clearing module.
\nAlso Read:<\/strong><\/p>\n

1.<\/strong>\u00a0Greytrix Extended Report Pack for Sage 300 ERP<\/a>
\n2.<\/strong>\u00a05 Steps to Intelligent Reporting using Sage 300 ERP<\/a>
\n3.<\/strong>\u00a0Stock Status Report in Sage 300 ERP<\/a>
\n4.<\/strong>\u00a0Auto Generate OE Confirmation Report in PDF format in Sage 300 ERP<\/a>
\n5.<\/strong>\u00a0Exclude Inactive Accounts option in GL Chart of Accounts Report of Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog, we introduced \u201cGL Clearing module for Sage 300 ERP\u201d. Now, we will be discussing about how to generate Document Number automatically with pre-define structure in Document Number Generation screen in GL clearing module. There are some mandatory fields like \u201cFiscal Year\u201d, \u201cPrefix\u201d and \u201cNext Number\u201d to generate document number. So, user\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":[2],"tags":[810,994,1056,1064,1727,2357,2451],"class_list":["post-3839","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-document-number-generation","tag-fiscal-year","tag-gl-audit","tag-gl-clearing","tag-next-number","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nAuto-Generate GL Document Numbers in Sage 300 ERP<\/title>\n<meta name=\"description\" content=\"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.\" \/>\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\/09\/03\/auto-generate-document-number-in-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=\"Auto-Generate GL Document Numbers in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-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-09-03T09:28:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-22T09:31:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.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\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/\",\"name\":\"Auto-Generate GL Document Numbers in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png\",\"datePublished\":\"2013-09-03T09:28:20+00:00\",\"dateModified\":\"2025-09-22T09:31:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-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\":\"Auto Generate Document Number in 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":"Auto-Generate GL Document Numbers in Sage 300 ERP","description":"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.","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\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Auto-Generate GL Document Numbers in Sage 300 ERP","og_description":"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-09-03T09:28:20+00:00","article_modified_time":"2025-09-22T09:31:57+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.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\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/","name":"Auto-Generate GL Document Numbers in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png","datePublished":"2013-09-03T09:28:20+00:00","dateModified":"2025-09-22T09:31:57+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Configure Sage 300 ERP's GL Clearing module to auto-generate document numbers with a custom prefix and sequential numbering for streamlined auditing.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-gl-clearing-module-for-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/Document-Number-Generation.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/03\/auto-generate-document-number-in-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":"Auto Generate Document Number in 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\/3839","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=3839"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3839\/revisions"}],"predecessor-version":[{"id":36340,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3839\/revisions\/36340"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}