{"id":6920,"date":"2014-03-18T07:33:52","date_gmt":"2014-03-18T07:33:52","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=6920"},"modified":"2022-08-24T06:22:40","modified_gmt":"2022-08-24T06:22:40","slug":"general-ledger-gl-accounts-distribution-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/","title":{"rendered":"General Ledger (GL) Accounts Distribution in Sage 300 ERP"},"content":{"rendered":"

General Ledger is a core of any accounting software where the organization\u2019s revenue, expenses, assets, liabilities, etc. are recorded and maintained. In Sage 300 ERP, all financial transaction from all modules is reflected in GL.
\nBut, are you aware on what basis the G\/L Accounts get affected when transactions from Account Receivable (AR), Account Payable (AP), Inventory Control (IC), etc. are posted and GL batch gets generated?
\nGreytriX3<\/span> :<\/strong><\/em>\u00a0\u00a0Best Practices for Integrating Third Party Apps with Sage ERP X3<\/a>
\nThis blog will help you to understand the process of how a GL Account is picked up from a sub ledger transaction in Sage 300 ERP.
\nLet\u2019s take an example for Account Payable module.
\nCreate an invoice entry for Vendor 1200, while making invoice user can select any GL account as per requirement.<\/p>\n

\u2022 GL Account: 6380<\/strong>
\n\u2022 Document Number: INV-0001 <\/strong>
\n\u2022 Account Set: USA<\/strong><\/p>\n

\"AP-Invoice-Entry\"<\/a><\/p>\n

\u2022 Post this invoice batch, you will get the following message as GL transaction is created<\/p>\n

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

\u2022 Check its effect in GL batch list
\n\u2022 Go to General Ledger >> GL Transactions >> Batch List<\/p>\n

o Open this batch entry<\/p>\n

\u2022 If you will refer the below screen shot there are three GL line created:<\/p>\n

\"GL-Accounts-Distribution2\"<\/a><\/p>\n

\"GL-Journal-Entry\"<\/a><\/p>\n

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

In similar way, for other modules GL Accounts are distributed.<\/p>\n","protected":false},"excerpt":{"rendered":"

General Ledger is a core of any accounting software where the organization\u2019s revenue, expenses, assets, liabilities, etc. are recorded and maintained. In Sage 300 ERP, all financial transaction from all modules is reflected in GL. But, are you aware on what basis the G\/L Accounts get affected when transactions from Account Receivable (AR), Account Payable\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":[57,1040,2357],"class_list":["post-6920","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-account-payable","tag-general-ledger","tag-sage-300-erp"],"yoast_head":"\nGeneral Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \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\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"General Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"General Ledger is a core of any accounting software where the organization\u2019s revenue, expenses, assets, liabilities, etc. are recorded and maintained. In Sage 300 ERP, all financial transaction from all modules is reflected in GL. But, are you aware on what basis the G\/L Accounts get affected when transactions from Account Receivable (AR), Account Payable\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-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=\"2014-03-18T07:33:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-24T06:22:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.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=\"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\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/\",\"name\":\"General Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png\",\"datePublished\":\"2014-03-18T07:33:52+00:00\",\"dateModified\":\"2022-08-24T06:22:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"General Ledger (GL) Accounts Distribution in 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":"General Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \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\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"General Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"General Ledger is a core of any accounting software where the organization\u2019s revenue, expenses, assets, liabilities, etc. are recorded and maintained. In Sage 300 ERP, all financial transaction from all modules is reflected in GL. But, are you aware on what basis the G\/L Accounts get affected when transactions from Account Receivable (AR), Account Payable\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-03-18T07:33:52+00:00","article_modified_time":"2022-08-24T06:22:40+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/","name":"General Ledger (GL) Accounts Distribution in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png","datePublished":"2014-03-18T07:33:52+00:00","dateModified":"2022-08-24T06:22:40+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/03\/AP-Invoice-Entry1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/18\/general-ledger-gl-accounts-distribution-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"General Ledger (GL) Accounts Distribution in 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\/6920","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=6920"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6920\/revisions"}],"predecessor-version":[{"id":31714,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6920\/revisions\/31714"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=6920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=6920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=6920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}