{"id":11920,"date":"2015-07-13T12:23:17","date_gmt":"2015-07-13T12:23:17","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=11920"},"modified":"2015-07-13T12:23:17","modified_gmt":"2015-07-13T12:23:17","slug":"how-to-fix-when-current-entry-is-out-of-balance-in-gl","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/","title":{"rendered":"How to fix when current entry is out of balance in GL"},"content":{"rendered":"

Sage 300 ERP provides various types of warning message to its users during transaction entries. In this blog we will discuss a warning message \u201cthe current entry is out of balance\u201d in GL Journal entries.
\nSometimes when a user makes entries in GL Journal entry directly and clicks on the add button, a warning message will pop up that says: The current entry is out of balance. In this blog, our motto is to make aware of the issue and how to track those entries for which the current entry is out of balance in general ledger.
\nThe following screen shot shows the GL journal entry screen:
\nNew stuff:<\/strong> <\/span>Sales Order Action Report in Sage 300 ERP<\/a>
\n\"GL<\/a>
\nIn the above screen shot we have taken a GL journal entry in which an Account set \u201c1000\u201d is inserted on GL detail line. Now when the \u201cAdd\u201d button is clicked the following screen shot appears:
\n\"warning<\/a>
\nThe General Ledger gets out of balance in two ways:
\n1. Total Debits do not match with Total Credits.
\n2. Another type of out of balance occurs when the totals per period from the summary file (GL8-used in printing the Trial Balance report and Financial Statements) does not equal the totals per period from the transaction file (GL5-used in printing the detail on the General Ledger Detail report). When this occurs, an \u201cOut of Balance\u201d line appears.
\nThe first way is Total debits do not match with Total credit; one can see this on a trial balance report. For example for the account set 1000 when we run the trial balance report the following report has been obtained, as shown in the following screen shot:
\n\"Trial<\/a>
\nHow to track the above out of balance:<\/span><\/strong>
\na) Run the Trial Balance Report for all accounts which are showing Beginning Balance, Activity and Ending balance.
\nb) If the Beginning Balance column does not equal zero in the Report Total, run the Trial balance report again and again for the different previous period. Continue this process until the Beginning Balance, Report total is zero.
\nFor example: for period 2018-09 we get total amount equal to credit and debit (that is report total) side as shown in the following screen shot.
\n\"Trial<\/a>
\nc) Now one needs to find out those entries for which the total debits for the entry does not equal the total credits. Chose the General Ledger detail by Source Report from sage desktop \u00a0–> General ledger –> GL reports –> Source ledger)
\nd) Print it for all journals (like A\/R clearing Journals, Bank reconciliation, Journal entry. etc), all batches (From 0 to 999999) and for the date range of the period (2018-10 in this case) that is out of balance.
\ne) Review the report to confirm each entry is a double sided entry and fix it.
\nSo we see how to verify and fix the issue out of balance message box in General ledger.
\nAlso read:<\/strong><\/span>
\n1. Stock Ledger Report<\/a>
\n2. ERROR: Load Library<\/a>
\n3. How to Pass GL Revaluation entry in Sage 300 ERP<\/a>
\n4. GL Voucher in Greytrix Extended Report for Sage 300 ERP<\/a>
\n5. Auto-Reverse General Ledger Entries in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Sage 300 ERP provides various types of warning message to its users during transaction entries. In this blog we will discuss a warning message \u201cthe current entry is out of balance\u201d in GL Journal entries. Sometimes when a user makes entries in GL Journal entry directly and clicks on the add button, a warning message\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[596,1050,1836,2357,3037],"class_list":["post-11920","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-credit-debit","tag-gl","tag-out-of-balance","tag-sage-300-erp","tag-warning-message"],"yoast_head":"\nHow to fix when current entry is out of balance in GL - 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\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to fix when current entry is out of balance in GL - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 ERP provides various types of warning message to its users during transaction entries. In this blog we will discuss a warning message \u201cthe current entry is out of balance\u201d in GL Journal entries. Sometimes when a user makes entries in GL Journal entry directly and clicks on the add button, a warning message\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-13T12:23:17+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg\" \/>\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=\"3 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\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/\",\"name\":\"How to fix when current entry is out of balance in GL - 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\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg\",\"datePublished\":\"2015-07-13T12:23:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to fix when current entry is out of balance in GL\"}]},{\"@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":"How to fix when current entry is out of balance in GL - 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\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/","og_locale":"en_US","og_type":"article","og_title":"How to fix when current entry is out of balance in GL - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 ERP provides various types of warning message to its users during transaction entries. In this blog we will discuss a warning message \u201cthe current entry is out of balance\u201d in GL Journal entries. Sometimes when a user makes entries in GL Journal entry directly and clicks on the add button, a warning message\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-07-13T12:23:17+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/","name":"How to fix when current entry is out of balance in GL - 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\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg","datePublished":"2015-07-13T12:23:17+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/07\/GL-Entry.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/07\/13\/how-to-fix-when-current-entry-is-out-of-balance-in-gl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to fix when current entry is out of balance in GL"}]},{"@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\/11920","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=11920"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/11920\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=11920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=11920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=11920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}