{"id":3845,"date":"2013-09-04T11:40:37","date_gmt":"2013-09-04T11:40:37","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3845"},"modified":"2025-09-22T09:34:22","modified_gmt":"2025-09-22T09:34:22","slug":"clear-sales-history-from-account-receivable-module-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/","title":{"rendered":"Clear Sales History from Account Receivable Module in Sage 300 ERP"},"content":{"rendered":"

Many a times, users come across a situation where they find the legacy data is no more useful for organization and keeping such large data becomes quite expensive task. Hence, in this blog, we would be discussing how to clear Sales history from Account Receivable.
\nOur Other Blogs :<\/strong><\/em><\/span>\u00a0Sage CRM<\/a>\u00a0|\u00a0Sage ERP X3<\/a>\u00a0|\u00a0Salesforce.com<\/a><\/strong>
\nSteps for clearing Sales history from AR Module are as follows:<\/p>\n

1.<\/strong> To clear obsolete data: navigate to A\/R Periodic Processing >> Clear History.<\/p>\n

\"1.<\/a>
\n2.<\/strong> Then, select Account Receivable >> A\/R periodic Processing >> Clear History. The below screen would appear.<\/p>\n

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

Follow below steps to clear records;<\/p>\n

a)<\/strong> Select the types of records you wish to clear
\nb)<\/strong> Specify the ranges for each type of record.
\nc)<\/strong> Type the dates or fiscal year and period for which you want to clear the data and click on Process.<\/p>\n

The New Stuff:<\/strong><\/span>\u00a0Data Integrity Check in Sage 300 ERP<\/a><\/em>
\nSay for an example, we want to clear Fully Paid Documents Through: \u00a0<\/b>Select the <\/b>Fully Paid Documents option in Clear History form; Through field would appears.<\/p>\n

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

1.<\/strong> Select the document you want to clear in \u201cFrom & To\u201d option.
\n2.<\/strong> Enter date from which you want to clear fully paid documents and click on Process.<\/p>\n

Accounts Receivable would clear invoices, credit notes, and debit notes that were fully paid on the Clear Transactions Through date if:<\/p>\n

a)<\/strong> The balance for each document is zero.
\nb)<\/strong> The AR receipt that applied on open documents and has cleared the bank account.
\nc)<\/strong> AR also removes all receipts and refunds associated with the fully paid documents.<\/p>\n

Hence, using this option Admin user would be able to reduce the Sage 300 database size and get rid of irrelevant data in ERP accounting system.
\nNote<\/strong> – This task is preferred to do be done by your Sage 300 Consultant\/Admin User of Sage 300. Please ensure to take proper backup of your Sage 300 company database before proceeding.<\/em>
\nAlso Read:<\/strong><\/p>\n

1.<\/strong>\u00a0Monthly Audit Methodology in Sage 300 ERP<\/a>
\n2.<\/strong>\u00a0New Features in Accounts Receivable Module of Sage 300 ERP 2012<\/a>
\n3.<\/strong>\u00a0Sales History Report in Sage 300 ERP<\/a>
\n4.<\/strong>\u00a0Closing Procedure Checklist for Sage 300 ERP<\/a>
\n5.<\/strong>\u00a0Stock Status Report in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Many a times, users come across a situation where they find the legacy data is no more useful for organization and keeping such large data becomes quite expensive task. Hence, in this blog, we would be discussing how to clear Sales history from Account Receivable. Our Other Blogs :\u00a0Sage CRM\u00a0|\u00a0Sage ERP X3\u00a0|\u00a0Salesforce.com Steps for clearing\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":[60,267,464,760,2357,2451],"class_list":["post-3845","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-account-receivable","tag-ar-transaction","tag-clear-history","tag-deletes-ar-transactions","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nClear Sales History in Sage 300 ERP's AR Module<\/title>\n<meta name=\"description\" content=\"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.\" \/>\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\/04\/clear-sales-history-from-account-receivable-module-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=\"Clear Sales History in Sage 300 ERP's AR Module\" \/>\n<meta property=\"og:description\" content=\"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-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=\"2013-09-04T11:40:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-22T09:34:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.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=\"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\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/\",\"name\":\"Clear Sales History in Sage 300 ERP's AR Module\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png\",\"datePublished\":\"2013-09-04T11:40:37+00:00\",\"dateModified\":\"2025-09-22T09:34:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Clear Sales History from Account Receivable Module 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":"Clear Sales History in Sage 300 ERP's AR Module","description":"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.","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\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Clear Sales History in Sage 300 ERP's AR Module","og_description":"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-09-04T11:40:37+00:00","article_modified_time":"2025-09-22T09:34:22+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png","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\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/","name":"Clear Sales History in Sage 300 ERP's AR Module","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png","datePublished":"2013-09-04T11:40:37+00:00","dateModified":"2025-09-22T09:34:22+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Reduce database size by clearing obsolete sales data in Sage 300 ERP's AR module. Delete fully paid invoices, credit notes, and debit notes.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.-Clear-History.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/04\/clear-sales-history-from-account-receivable-module-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Clear Sales History from Account Receivable Module 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\/3845","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=3845"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3845\/revisions"}],"predecessor-version":[{"id":36341,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3845\/revisions\/36341"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}