{"id":10675,"date":"2015-04-28T05:08:25","date_gmt":"2015-04-28T05:08:25","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=10675"},"modified":"2022-03-04T00:43:44","modified_gmt":"2022-03-04T00:43:44","slug":"financial-reporter-functions-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/","title":{"rendered":"Financial Reporter Functions in Sage 300 ERP"},"content":{"rendered":"<p style=\"text-align: justify\">General Ledger in Sage 300 ERP includes Financial Reporter &#8211; a powerful tool that uses Microsoft Excel to read, manipulate, format and print general ledger data. The Financial Reporter helps retrieve data from General Ledger including transaction and the optional field information. &nbsp;Financial statements use special functions to extract data from the company database.<\/p>\n<p style=\"text-align: justify\"><strong style=\"color: #993300\"><em>The New Stuff:&nbsp;<\/em><\/strong><a title=\"Expense Separately Functionality for Tax in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/expense-separately-functionality-for-tax-in-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\"><em>Expense Separately Functionality for Tax in Sage 300 ERP<\/em><\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-10676 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png\" alt=\"Vendor\" width=\"624\" height=\"400\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>FR Function<\/strong>: This function can retrieve G\/L Option, company, and fiscal calendar data; runtime parameter values; and statement print options.<\/p>\n<p style=\"text-align: justify\"><strong>FRACCT Function<\/strong>: This function retrieves data from G\/L account records, including account optional fields. It cannot retrieve data from transaction optional fields.<\/p>\n<p style=\"text-align: justify\"><strong>FRAMT Function<\/strong>: This function retrieves actual, budget, and quantity balances and net amounts from General Ledger accounts for a specified period.<\/p>\n<p style=\"text-align: justify\"><strong>FRAMTA Function<\/strong>: This function is similar to FRAMT Function. It has the same arguments as FRAMT, and returns the same data. The difference is that the sign of the return value is dependent on the account type for FRAMT, but not for FRAMTA. FRAMTA returns all debit balances as positive numbers, and all credit balances as negative numbers, making it easy to sum a range of accounts without regard for the account type.<\/p>\n<p style=\"text-align: justify\"><strong>FRCREDIT Function<\/strong>: This function returns values for only those accounts that have credit amounts (balances or net changes) &#8211; regardless of whether the account is a debit or a credit account.<\/p>\n<p style=\"text-align: justify\"><strong>FRDEBIT Function:<\/strong> This function returns values for only those accounts that have debit amounts (balances or net changes) &#8211; regardless of whether the account is a debit or a credit account.<\/p>\n<p style=\"text-align: justify\"><strong>FRFISCAL Function<\/strong>: This function returns a date (as a string) from the fiscal calendar in Common Services.<\/p>\n<p style=\"text-align: justify\"><strong>FRPOST Function:<\/strong> This function retrieves account and transaction detail information from posted G\/L transactions. It can also retrieve transaction optional fields and account optional field data for the account specified in the transaction record.<\/p>\n<p style=\"text-align: justify\"><strong>FRSDESC Function:<\/strong> This function returns the account segment name from the General Ledger segment codes table, given a segment number and code.<\/p>\n<p style=\"text-align: justify\"><strong>FRTRN Function:<\/strong> This function retrieves net amounts and net quantities from posted transactions for a specified period. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.<\/p>\n<p style=\"text-align: justify\"><strong>FRTRNA Function:<\/strong> This function retrieves net amounts and net quantities from posted transactions for the period that you specify. It retrieves the actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.<\/p>\n<p style=\"text-align: justify\"><strong>FRTRNCR Function:<\/strong> This function retrieves net totals (credit amounts only) from transactions. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.<\/p>\n<p style=\"text-align: justify\"><strong>FRTRNDR Function:<\/strong> This function retrieves net totals (debit amounts only) from transactions. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.<\/p>\n<p><strong style=\"color: #000000\">Also Read:<\/strong><br \/>\n1.&nbsp;<a title=\"Financial Reporter Commands in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/13\/financial-reporter-commands-in-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Financial Reporter Commands in Sage 300 ERP<\/a><br \/>\n2.&nbsp;<a title=\"Paste Command in Financial Reporter of Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/06\/12\/paste-command-in-financial-reporter-of-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Paste Command in Financial Reporter of Sage 300 ERP<\/a><br \/>\n3.&nbsp;<a title=\"Financial Reporter made reporting tranquil in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/08\/financial-reporter-made-reporting-tranquil-in-sage-300-erp\/\" target=\"_blank\" rel=\"noopener\">Financial Reporter made reporting tranquil in Sage 300 ERP<\/a><br \/>\n4.<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 \/>\n5.&nbsp;<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>General Ledger in Sage 300 ERP includes Financial Reporter &#8211; a powerful tool that uses Microsoft Excel to read, manipulate, format and print general ledger data. The Financial Reporter helps retrieve data from General Ledger including transaction and the optional field information. &nbsp;Financial statements use special functions to extract data from the company database. The\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/\">Read More &raquo;<\/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":[79,979,1016,1019,2311,2357],"class_list":["post-10675","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac","tag-financial-reporter","tag-fr","tag-fr-functions","tag-sage","tag-sage-300-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Financial Reporter Functions 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\/2015\/04\/28\/financial-reporter-functions-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 Functions in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"General Ledger in Sage 300 ERP includes Financial Reporter &#8211; a powerful tool that uses Microsoft Excel to read, manipulate, format and print general ledger data. The Financial Reporter helps retrieve data from General Ledger including transaction and the optional field information. &nbsp;Financial statements use special functions to extract data from the company database. The\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-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=\"2015-04-28T05:08:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-04T00:43:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.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\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/\",\"name\":\"Financial Reporter Functions 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\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png\",\"datePublished\":\"2015-04-28T05:08:25+00:00\",\"dateModified\":\"2022-03-04T00:43:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-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 Functions 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 Functions 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\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Financial Reporter Functions in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"General Ledger in Sage 300 ERP includes Financial Reporter &#8211; a powerful tool that uses Microsoft Excel to read, manipulate, format and print general ledger data. The Financial Reporter helps retrieve data from General Ledger including transaction and the optional field information. &nbsp;Financial statements use special functions to extract data from the company database. The\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-04-28T05:08:25+00:00","article_modified_time":"2022-03-04T00:43:44+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.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\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/","name":"Financial Reporter Functions 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\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png","datePublished":"2015-04-28T05:08:25+00:00","dateModified":"2022-03-04T00:43:44+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/Vendor3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/28\/financial-reporter-functions-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 Functions 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\/10675","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=10675"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10675\/revisions"}],"predecessor-version":[{"id":30897,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10675\/revisions\/30897"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=10675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=10675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=10675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}