{"id":3157,"date":"2013-05-28T06:51:52","date_gmt":"2013-05-28T06:51:52","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3157"},"modified":"2025-07-23T05:31:20","modified_gmt":"2025-07-23T05:31:20","slug":"customer-transaction-and-aged-trial-balance-report-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/","title":{"rendered":"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP"},"content":{"rendered":"

In our previous blog, we discussed about \u201cAccount Receivable Transaction Reports in Sage 300 ERP<\/a><\/strong>\u201d, which shows basic transaction wise data from AR Module. Now, we will discuss AR Transactions Reports that shows Customer wise data like Customer wise Debit\/Credit Total, Opening\/Closing Balance for a particular period or Date Range.<\/p>\n

1. Customer Transactions: <\/strong>This report keeps track on current status of Customers Account. It also lists all customer transactions that were posted during the current period and in the period for which you keep transaction history. Thus to print this report navigate to <\/span>Account Receivable >> A\/R Transactions Reports >> Customer Transactions<\/strong><\/p>\n

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

Report UI provides different types of report with grouping and sorting options. After printing report, the format of report will be as follows:<\/p>\n

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

Also Read:<\/strong><\/span>\u00a0Email Standard Order Entry Invoice Report in PDF or RTF Format<\/a><\/em><\/p>\n

2.\u00a0Aged Trial Balance: <\/strong>Aged Trial Balance report list accounts receivable with outstanding balance by age buckets (30\\60\\90 days etc.). This report provide different options like printing report in detailed form, listing all outstanding documents for each customer, or summary form, printing one line for each customer number, including the current balance and the balance in each aging period. \u00a0Hence, to print this report navigate to Account Receivable >> A\/R Transactions Reports >> Aged Trial Balance<\/strong><\/p>\n

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

After printing this report, the format of report will be as follows:<\/p>\n

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

This report shows customer outstanding transaction for current period up to four aging periods. It also allows user to print report by using document date or posting date.<\/p>\n

Hence, allows user to see total outstanding transaction for each document for that customer by printing it detail wise or summary wise to view only outstanding balance. Thus, Sage 300 ERP provides a number of useful reports for Account Receivable putting critical information at fingertips.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog, we discussed about \u201cAccount Receivable Transaction Reports in Sage 300 ERP\u201d, which shows basic transaction wise data from AR Module. Now, we will discuss AR Transactions Reports that shows Customer wise data like Customer wise Debit\/Credit Total, Opening\/Closing Balance for a particular period or Date Range. 1. Customer Transactions: This report\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":[264,669,2234,2357,2451,2902],"class_list":["post-3157","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-ar-reports","tag-customer-transaction-reports","tag-reports","tag-sage-300-erp","tag-sage-accpac-erp","tag-trial-balance-reports"],"yoast_head":"\nCustomer Transaction and Aged Trial Balance Report in Sage 300 ERP<\/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\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-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=\"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"In our previous blog, we discussed about \u201cAccount Receivable Transaction Reports in Sage 300 ERP\u201d, which shows basic transaction wise data from AR Module. Now, we will discuss AR Transactions Reports that shows Customer wise data like Customer wise Debit\/Credit Total, Opening\/Closing Balance for a particular period or Date Range. 1. Customer Transactions: This report\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-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-05-28T06:51:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-23T05:31:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.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\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/\",\"name\":\"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png\",\"datePublished\":\"2013-05-28T06:51:52+00:00\",\"dateModified\":\"2025-07-23T05:31:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Customer Transaction and Aged Trial Balance Report 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":"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP","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\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP","og_description":"In our previous blog, we discussed about \u201cAccount Receivable Transaction Reports in Sage 300 ERP\u201d, which shows basic transaction wise data from AR Module. Now, we will discuss AR Transactions Reports that shows Customer wise data like Customer wise Debit\/Credit Total, Opening\/Closing Balance for a particular period or Date Range. 1. Customer Transactions: This report\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-05-28T06:51:52+00:00","article_modified_time":"2025-07-23T05:31:20+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.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\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/","name":"Customer Transaction and Aged Trial Balance Report in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png","datePublished":"2013-05-28T06:51:52+00:00","dateModified":"2025-07-23T05:31:20+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/05\/1.-AR-Customer-Transactions-Report.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/28\/customer-transaction-and-aged-trial-balance-report-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Customer Transaction and Aged Trial Balance Report 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\/3157","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=3157"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3157\/revisions"}],"predecessor-version":[{"id":32037,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3157\/revisions\/32037"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}