{"id":2763,"date":"2013-03-08T08:50:34","date_gmt":"2013-03-08T08:50:34","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2763"},"modified":"2025-07-18T06:19:19","modified_gmt":"2025-07-18T06:19:19","slug":"financial-reporter-made-reporting-tranquil-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/","title":{"rendered":"Financial Reporter made reporting tranquil in Sage 300 ERP"},"content":{"rendered":"<p>Preparing reports directly without any software assistance is generally not an easy task, especially in the absence of an in-house IT support team. Software vendors might not be readily available or external developers might be a costly and unreliable affair to maintain and control.<br \/>\n<span style=\"line-height: 1.6em\">For this sort of uncertainty, Sage 300 ERP (formerly known as Sage Accpac ERP) comes with an innovative solution to deal with this by introducing \u201cFinancial Reporter Add-on\u201d, which enables users to create their own reports without any help from vendors or developers.<\/span><br \/>\n<span style=\"line-height: 1.6em\">Financial Report is one of the powerful tools in Sage 300 ERP. With the help of Financial Reporter users can generate various type of MIS Report based on General Ledger data.<\/span><br \/>\n<strong>Financial Reporter is based on following concept;<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>1.<\/strong> Financial Report is a spreadsheet containing functions that read data directly from general ledger of Sage 300 ERP.<br \/>\n<strong>2.<\/strong> Financial Report creates statements based on specification and options, user choose when they want to print or view final statements.<br \/>\n<strong>3.<\/strong> Once the report is printed, user can use any other spreadsheet function to further process the data.<br \/>\n<strong>4.<\/strong> While creating a financial report in Financial Statement Designer, user can enter\u00a0formula\u00a0that allow them to drilldown to associated transactions in the resulting report.<\/p>\n<p><strong>Following exercise explains the \u2018Drill-Down\u2019 feature of Financial Report of Sage 300 ERP in detail;<\/strong><\/p>\n<p style=\"padding-left: 30px\">FR\u00a0Drill down\u00a0works only with formulas that contain the following transaction functions:<\/p>\n<p style=\"padding-left: 60px\"><strong>a)<\/strong> FRTRN (used for Transaction Data)<br \/>\n<strong>b)<\/strong> FRTRNA (a variant of FRTRN with different convention for handling of Dr. and Cr. values)<br \/>\n<strong>c)<\/strong> FRTRNCR (used for denoting Credit part of transactions data)<br \/>\n<strong>d)<\/strong> FRTRNDR (used for denoting Debit part of transactions data)<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-2764\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png\" alt=\"\" width=\"615\" height=\"400\" \/><\/a><\/p>\n<p>In the G\/L Financial Statement Designer screen, \u201c<strong>\u00a0Drill down\u00a0information<\/strong>\u201d option has been provided to Print G\/L Financial Statements form and to view Financial Report, so that users can include\u00a0drill down\u00a0information in generated output.\u00a0This feature is available to user, while saving the output in Excel file format or while sending the output to E-mail in Print Financial Statements. Navigate to Sage 300 &gt;&gt; General Ledger &gt;&gt; Financial Reporter &gt;&gt;Print Financial Statements, to Print.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/2.-GL-Financial-Statement-Designer.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter  wp-image-2765\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/2.-GL-Financial-Statement-Designer.png\" alt=\"\" width=\"535\" height=\"472\" \/><\/a><\/p>\n<p>Then in Report, to\u00a0drill down from transaction in Journal Entry, right click on cell and click the FR\u00a0Drill down\u00a0button. This would open the underlying transaction.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/3.-FR-report.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter  wp-image-2766\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/3.-FR-report.png\" alt=\"\" width=\"627\" height=\"449\" \/><\/a><\/p>\n<p>It would in turn takes users to list of transactions forming that value, which can be further drilled down at the level of individual entries.<br \/>\n<span style=\"line-height: 1.6em\">In this way, users can easily identify all the entries, which form up a value on your Profit and Loss or MIS reports.<\/span><br \/>\n<strong>Related Posts:<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>1.<\/strong>\u00a0<a title=\"Financial Reporter in General Ledger Module of Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Financial Reporter in General Ledger Module of Sage 300 ERP<\/a><br \/>\n<strong>2.<\/strong>\u00a0<a title=\"Statement Designer Error in Financial Report of Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Statement Designer Error in Financial Report of Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Preparing reports directly without any software assistance is generally not an easy task, especially in the absence of an in-house IT support team. Software vendors might not be readily available or external developers might be a costly and unreliable affair to maintain and control. For this sort of uncertainty, Sage 300 ERP (formerly known as\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\">Read More &raquo;<\/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":[817,979,981,1040,2234,2357,2451,2891],"class_list":["post-2763","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-drill-down","tag-financial-reporter","tag-financial-statement","tag-general-ledger","tag-reports","tag-sage-300-erp","tag-sage-accpac-erp","tag-transactions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Financial Reporter made reporting tranquil in Sage 300 ERP - 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\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-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=\"Financial Reporter made reporting tranquil in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Preparing reports directly without any software assistance is generally not an easy task, especially in the absence of an in-house IT support team. Software vendors might not be readily available or external developers might be a costly and unreliable affair to maintain and control. For this sort of uncertainty, Sage 300 ERP (formerly known as\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-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-03-08T08:50:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T06:19:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.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\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\",\"name\":\"Financial Reporter made reporting tranquil in Sage 300 ERP - 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\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png\",\"datePublished\":\"2013-03-08T08:50:34+00:00\",\"dateModified\":\"2025-07-18T06:19:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial Reporter made reporting tranquil 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":"Financial Reporter made reporting tranquil in Sage 300 ERP - 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\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Financial Reporter made reporting tranquil in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Preparing reports directly without any software assistance is generally not an easy task, especially in the absence of an in-house IT support team. Software vendors might not be readily available or external developers might be a costly and unreliable affair to maintain and control. For this sort of uncertainty, Sage 300 ERP (formerly known as\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-03-08T08:50:34+00:00","article_modified_time":"2025-07-18T06:19:19+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.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\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/","name":"Financial Reporter made reporting tranquil in Sage 300 ERP - 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\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png","datePublished":"2013-03-08T08:50:34+00:00","dateModified":"2025-07-18T06:19:19+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/03\/1.-FR-paste-Function.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Financial Reporter made reporting tranquil 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\/2763","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=2763"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2763\/revisions"}],"predecessor-version":[{"id":36237,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2763\/revisions\/36237"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}