{"id":2655,"date":"2013-02-22T12:35:24","date_gmt":"2013-02-22T12:35:24","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2655"},"modified":"2025-09-08T08:43:55","modified_gmt":"2025-09-08T08:43:55","slug":"financial-reporter-in-general-ledger-module-of-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/","title":{"rendered":"Financial Reporter in General Ledger Module of Sage 300 ERP"},"content":{"rendered":"

In Sage 300 ERP (formerly known as Sage Accpac ERP), Financial Reporter of General ledger module is very easy and strong reporting tool. To elaborate, Financial Report is a spreadsheet containing functions that read data directly from general ledger. Thus, in GL Statement designer user can create or edit a report specification for creating the financial statements.<\/p>\n

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

When user choose the Statement Designer icon from the Financial Reporter folder, Sage 300 ERP starts Microsoft Excel spreadsheet program with the Financial Reporter add-in. This add-in is available only when user start excels from the Statement Designer icon. Add-in adds the FR menu item to the Microsoft Excel menu bar. The FR menu includes the following Financial Reporter commands:<\/p>\n

1. FR View<\/strong>: Generates Financial Statements from Report Specifications
\n2.<\/strong>\u00a0FR Paste:<\/strong> Inserts Financial Reporter Functions, Account Numbers and Selection criteria
\n3.<\/strong>\u00a0FR Clear:<\/strong> Clears a previously generated financial statement
\n4.<\/strong>\u00a0FR Options:<\/strong> Carry forward the Opening Budget
\n5.<\/strong>\u00a0FR DrillDown:<\/strong> DrillDown to associated transactions after user generates a financial statement<\/p>\n

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

These FR Functions can be useful in designing a new FR. Each Financial Statement is defined in Report Specification. These specifications tell Financial Reporter what data is included in the statement, and how it must be formatted. Columns A, B, C and D are reserved for Control information. All other columns determine the appearance of the report and type of data, which will appear.<\/p>\n

Financial Reporter creates statement based on specification and options chosen. Whenever user wants to print or view financial statement, there are two ways to print financial reports;<\/p>\n

1.<\/strong>\u00a0Navigate to General Ledger >> Financial Reporter >> Print Financial Statements<\/strong> (Generally used for Running Financial Reports)<\/p>\n

2.<\/strong>\u00a0Navigate to General Ledger >> Financial Reporter >> Statement Designer<\/strong> (Generally used for Creating, Editing and Running Financial Reports)<\/p>\n

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

When User run FR from Print Financial Statement<\/strong> icon, it allows following print options:<\/p>\n

1.<\/strong>\u00a0Statement Name<\/strong> \u2013 Browse and select the FR file path<\/p>\n

2.<\/strong>\u00a0Report Type<\/strong> \u2013 Actual and Provisional
\n–<\/strong> Actual includes those amounts which have been permanently posted to General Ledger.
\n–<\/strong> Whereas, Provisional includes those amounts that have been provisionally posted to general ledger accounts, as well as permanently posted amounts.<\/p>\n

3.<\/strong>\u00a0Report As<\/strong> \u2013 Separate or Consolidated
\n–<\/strong> It allows printing single consolidated report or separate reports for different account number segments.<\/p>\n

4.<\/strong>\u00a0Include<\/strong> \u2013 Report Options or DrillDown Information
\n–<\/strong> Report Options includes the following options, Statement Name, Fiscal Year and Period, Account Sorting Order, Account Selection ranges, etc.
\n–<\/strong> DrillDown Information allows to drilldown the output to the transaction level.<\/p>\n

5. Print Destination<\/strong> \u2013 Printer\/Preview\/File or E-mail
\n–<\/strong> Printer \u2013 Prints to a physical printer
\n–<\/strong> Preview \u2013 Displays the report onscreen
\n–<\/strong> File \u2013 Saves the report as a file
\n–<\/strong> E-mail \u2013 Sends the report as an attachment in the E-mail<\/p>\n

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

When User run FR from Statement Designer<\/strong>, it opens an excel file. Here, he has to Select FR View from FR -> Add-ins and it would populate the Financial Statement Designer UI from where user can run FR.<\/p>\n

Advantage of using Statement Designer for running FR than Printing through Financial Statement is that; it allows changing the formulas at runtime through Statement Designer, whereas printing through Financial Statements prints only the output.<\/p>\n

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

As a result, Sage 300 ERP accurately manages income and expense details of business enterprises and prepares the general ledger, thus providing an alternative solution from the complicated and time-consuming paper-pen based financial tasks. It enables users to design the following financial reports:<\/p>\n

a.<\/strong>\u00a0Balance Sheet to view the current snapshot as well as long-term forecast of assets, liabilities and net changes
\nb.<\/strong>\u00a0Profit & Loss Statements that gives up-to date Profit & Loss statements for anytime period
\nc.<\/strong>\u00a0General Ledger to view GL accounts with updated financial transactions
\nd.<\/strong>\u00a0Trial Balance to view a comprehensive worksheet showing the balances in each account<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage 300 ERP (formerly known as Sage Accpac ERP), Financial Reporter of General ledger module is very easy and strong reporting tool. To elaborate, Financial Report is a spreadsheet containing functions that read data directly from general ledger. Thus, in GL Statement designer user can create or edit a report specification for creating the\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":[354,977,980,1016,1020,1021,2357,2451],"class_list":["post-2655","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-basics-of-financial-report","tag-financial-report","tag-financial-reports-in-sage","tag-fr","tag-fr-in-sage-accpac","tag-fr-introduction-in-sage-accpac","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nFinancial Reporter in Sage 300 ERP General Ledger<\/title>\n<meta name=\"description\" content=\"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.\" \/>\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\/02\/22\/financial-reporter-in-general-ledger-module-of-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 in Sage 300 ERP General Ledger\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-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-02-22T12:35:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-08T08:43:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.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\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/\",\"name\":\"Financial Reporter in Sage 300 ERP General Ledger\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png\",\"datePublished\":\"2013-02-22T12:35:24+00:00\",\"dateModified\":\"2025-09-08T08:43:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-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 in General Ledger Module of 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 in Sage 300 ERP General Ledger","description":"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.","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\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Financial Reporter in Sage 300 ERP General Ledger","og_description":"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-02-22T12:35:24+00:00","article_modified_time":"2025-09-08T08:43:55+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.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\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/","name":"Financial Reporter in Sage 300 ERP General Ledger","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png","datePublished":"2013-02-22T12:35:24+00:00","dateModified":"2025-09-08T08:43:55+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Learn how to use Sage 300 ERP\u2019s Financial Reporter to create, edit, and print financial statements directly from the General Ledger module.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-GL-Statement-Designer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/22\/financial-reporter-in-general-ledger-module-of-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 in General Ledger Module of 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\/2655","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=2655"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2655\/revisions"}],"predecessor-version":[{"id":32056,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2655\/revisions\/32056"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}