{"id":8154,"date":"2014-07-28T06:05:38","date_gmt":"2014-07-28T06:05:38","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=8154"},"modified":"2019-06-03T11:50:20","modified_gmt":"2019-06-03T11:50:20","slug":"how-to-audit-a-payable-clearing-account","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/","title":{"rendered":"How to Audit a Payable Clearing Account"},"content":{"rendered":"

Sage 300 ERP supports the concept of Payable clearing account which has credit effect at the time of PO receipt and has Debit effect at the time of PO invoice.<\/p>\n

Below mentioned table will give you clear idea.\"image1\"<\/a><\/p>\n

If we go with the financial effect mentioned in the above table it implies that our Payable clearing account should always have zero balances provided all the PO receipts has been invoiced.<\/p>\n

News Stuff: <\/em><\/strong>Hide Cost at GRN Level<\/a><\/p>\n

But, sometimes it may happen that payable clearing account possesses some balance. The reason may be either PO invoice is pending for particular receipts or the user has passed GL-JE using this account etc.<\/p>\n

Sage 300 ERP facilitates a very useful report named as \u201cPayable Clearing Audit List\u201d which helps us to perform audit activity for an account.<\/p>\n

Let us see how this report works. Below mentioned is the UI of the report which you will find when you navigate through Purchase order>>>P\/O Analytical Reports>>>Payables Clearing Audit List<\/p>\n

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

\n

We can extract this report account set wise and period wise.<\/p>\n

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

\n

The output of the report displays the list of receipts and Invoices with vendor number, vendor Name, Debit and credit effect to the account, Document date and Document number.<\/p>\n

This data is enough for carrying out audit activity for the account.<\/p>\n

For e.g. if you see the document number IN175116 debit amount is 78.48 and document number RCP00000032 credit amount is 78.48 \u00a0\u00a0both the documents have\u00a0 the same vendor one document is receipt and another is Invoice which implies this transaction is complete, mark it as done and move forward.\"image1\"<\/a> By following this practice you can track open receipts against which Invoice is not done. Once you have the list of receipts against which invoice is not been raised, go ahead and raise the invoice by which your payable clearing account will become zero.<\/p>\n

If still the account shows the balance then you will have to perform other practice to track the balance source like, you can use GL transaction listing report which will list down all the list of transaction which have been carried out using this account.<\/p>\n

You can also use GL transaction History screen to verify whether any transaction other than source ledger AP, IC and PO is been done using this account. Please refer below screen shot.<\/p>\n

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

\n

You can further drilldown to the individual transactions for a particular period by selecting and double-clicking on the individual line it will take you to the actual entry.<\/p>\n

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

Reverse the entry and do it from the respective sub ledger.<\/p>\n

To restrict users \u00a0from doing such type of entries you can follow another best way which is to mark this account as control account which ensures that only transaction from source ledger PO, AP and IC will only be posted to this account otherwise an error batch will get generated in GL batch list.<\/p>\n

To mark an account as control account you can go through our related blog which will guide you for marking an account as control account.<\/p>\n

GL Control Account Feature in Sage 300 ERP<\/strong><\/a><\/p>\n

In this way we can perform an audit for Payable clearing account which will indeed help us to maintain Ledger-Sub ledger<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n

Greytrix<\/a> offers unique GUMU™ integrated solutions of\u00a0Sage 300 with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a> along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a> and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services \u00a0to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix<\/a>, Document Attachment<\/a>, Document Numbering<\/a>, Auto-Bank Reconciliation<\/a>, Purchase Approval System<\/a>, Three way PO matching<\/a>, Bill of Lading<\/a> and VAT for Middle East<\/a>.<\/p>\n

For more details on Sage 300 and 300c Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Sage 300 ERP supports the concept of Payable clearing account which has credit effect at the time of PO receipt and has Debit effect at the time of PO invoice. Below mentioned table will give you clear idea. If we go with the financial effect mentioned in the above table it implies that our Payable\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":[538,1105,1465,1870,1871,2357,2445],"class_list":["post-8154","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-control-account-in-sage","tag-gl-transaction-history","tag-ledger-sub-ledger","tag-payable-clearing","tag-payable-clearing-audit-list-report","tag-sage-300-erp","tag-sage-accpac"],"yoast_head":"\nHow to Audit a Payable Clearing Account - 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\/07\/28\/how-to-audit-a-payable-clearing-account\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Audit a Payable Clearing Account - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 ERP supports the concept of Payable clearing account which has credit effect at the time of PO receipt and has Debit effect at the time of PO invoice. Below mentioned table will give you clear idea. If we go with the financial effect mentioned in the above table it implies that our Payable\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-28T06:05:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-03T11:50:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.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=\"4 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\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/\",\"name\":\"How to Audit a Payable Clearing Account - 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\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png\",\"datePublished\":\"2014-07-28T06:05:38+00:00\",\"dateModified\":\"2019-06-03T11:50:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Audit a Payable Clearing Account\"}]},{\"@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 Audit a Payable Clearing Account - 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\/07\/28\/how-to-audit-a-payable-clearing-account\/","og_locale":"en_US","og_type":"article","og_title":"How to Audit a Payable Clearing Account - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 ERP supports the concept of Payable clearing account which has credit effect at the time of PO receipt and has Debit effect at the time of PO invoice. Below mentioned table will give you clear idea. If we go with the financial effect mentioned in the above table it implies that our Payable\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-07-28T06:05:38+00:00","article_modified_time":"2019-06-03T11:50:20+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/","name":"How to Audit a Payable Clearing Account - 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\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png","datePublished":"2014-07-28T06:05:38+00:00","dateModified":"2019-06-03T11:50:20+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/07\/image13.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/07\/28\/how-to-audit-a-payable-clearing-account\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to Audit a Payable Clearing Account"}]},{"@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\/8154","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=8154"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8154\/revisions"}],"predecessor-version":[{"id":26302,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/8154\/revisions\/26302"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=8154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=8154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=8154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}