{"id":26,"date":"2011-06-30T10:11:00","date_gmt":"2011-06-30T10:11:00","guid":{"rendered":"http:\/\/greytrix.com\/Blogs\/sageaccpacerp\/?p=26"},"modified":"2024-02-16T12:41:49","modified_gmt":"2024-02-16T12:41:49","slug":"sage-accpac-erp-control-account-feature-comes-to-rescue","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/","title":{"rendered":"Sage Accpac ERP Control Account Feature comes to rescue"},"content":{"rendered":"

We were looking for something\/feature in Accpac which will restrict the users from using the Accounts which are meant for the AR Receipt entries when AP Invoice entry is entered. For the admin It becomes difficult to keep a hold on this, to avoid the users repeating this mistakes.<\/p>\n

Sage Accpac ERP Control Account Feature comes to rescue – As far as Accpac is concerned we can definitely restrict the users from carrying this mistake using control Account feature inbuilt in GL module of Accpac. Let us proceed with an explanation on the same.<\/p>\n

Consider, we have a GL account which is being used for our bank account and this account should be affected only by payment transaction [by customer and vendor] but not the Invoice transactions of either of the modules. In such case we will follow this procedure:<\/p>\n

\"\"<\/a>1) Open the GL Account screen and select the GL Account which has been set as bank Account. On the detail tab we will check the option Control Account, the new tab as Subledger gets added on the screen as shown in below screenshot.<\/p>\n

2) Go to Subledger tab and choose the subledgers that will use this account as a control. Here we are adding AR and AP payment source codes as subledgers as shown in below screenshot.<\/p>\n

Now let\u2019s check it by doing a normal GL Entry from GL Module on this account. Go to GL Transactions>>GL Entry and select source code as GL-JE and add select the Account 1020 for Transaction entry. As we select this account for entry ,a popup screen appears as shown in below screenshot. It will restrict us to make GL entry by another source code which has not been set as subledger on in GL Account screen.<\/p>\n

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

Now it will accept GL transactions only created by AR Receipt and AP payment Transactions as set against the account sub ledger. If we want to allow account to get affected by other transactions also then we need to add Source codes of those respective transactions into subledger of GL Account. The transactions created by only those subledgers may be posted to the account. General Ledger checks the ledger by looking at the first two characters of the source code included with each subledger transaction. \"\"<\/a><\/p>\n

These first two characters must match the subledger codes. For example, all transactions created by Accounts Payable use source codes that begin with AP.<\/p>\n

This reminds me of a saying.. Big things come in small packages.<\/p>\n","protected":false},"excerpt":{"rendered":"

We were looking for something\/feature in Accpac which will restrict the users from using the Accounts which are meant for the AR Receipt entries when AP Invoice entry is entered. For the admin It becomes difficult to keep a hold on this, to avoid the users repeating this mistakes. Sage Accpac ERP Control Account Feature\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":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"\nSage Acpac ERP Control Account Feature comes to the rescue.<\/title>\n<meta name=\"description\" content=\"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.\" \/>\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\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage Acpac ERP Control Account Feature comes to the rescue.\" \/>\n<meta property=\"og:description\" content=\"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-06-30T10:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-16T12:41:49+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.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=\"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\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/\",\"name\":\"Sage Acpac ERP Control Account Feature comes to the rescue.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG\",\"datePublished\":\"2011-06-30T10:11:00+00:00\",\"dateModified\":\"2024-02-16T12:41:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage\",\"url\":\"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG\",\"contentUrl\":\"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage Accpac ERP Control Account Feature comes to rescue\"}]},{\"@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":"Sage Acpac ERP Control Account Feature comes to the rescue.","description":"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.","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\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/","og_locale":"en_US","og_type":"article","og_title":"Sage Acpac ERP Control Account Feature comes to the rescue.","og_description":"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2011-06-30T10:11:00+00:00","article_modified_time":"2024-02-16T12:41:49+00:00","og_image":[{"url":"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG","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\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/","name":"Sage Acpac ERP Control Account Feature comes to the rescue.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG","datePublished":"2011-06-30T10:11:00+00:00","dateModified":"2024-02-16T12:41:49+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Accpac will prevent users from using Accounts designated for AR Receipt entries when an AP Invoice entry is entered.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#primaryimage","url":"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG","contentUrl":"http:\/\/2.bp.blogspot.com\/-lAsd0q44eoc\/TgxOIYMS5uI\/AAAAAAAABfc\/5kPd3xWtLB4\/s1600\/2.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/30\/sage-accpac-erp-control-account-feature-comes-to-rescue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Sage Accpac ERP Control Account Feature comes to rescue"}]},{"@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\/26","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=26"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":33657,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/26\/revisions\/33657"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}