{"id":2587,"date":"2013-02-15T11:29:12","date_gmt":"2013-02-15T11:29:12","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2587"},"modified":"2025-07-18T06:03:36","modified_gmt":"2025-07-18T06:03:36","slug":"statement-designer-error-in-financial-report-of-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/","title":{"rendered":"Statement Designer Error in Financial Report of Sage 300 ERP"},"content":{"rendered":"<p>In statement designer when Users click on start button, sometimes they may face or may come across an Error with description as <strong>\u2018Problem in Starting Financial Reporter Addin\u2019.<\/strong><\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-2588\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png\" alt=\"\" width=\"606\" height=\"454\" \/><\/a><\/p>\n<p>To avoid this error follow below mentioned steps;<br \/>\n<strong>1.<\/strong>\u00a0<strong>In Excel:<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>a)<\/strong>\u00a0Go to main control button at top left corner of an Excel sheet, choose Excel options &gt;&gt; Add-ins &gt;&gt; Manage &gt;&gt; Excel Add-ins then click on Go button.<br \/>\n<strong>b)<\/strong>\u00a0When Add-in window pops up; check &#8220;<strong>Analysis Toolpack<\/strong>&#8221; and &#8220;<strong>Analysis Toolpack-VBA<\/strong>&#8221; option and click on OK.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/2.-Add-Ins.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter  wp-image-2589\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/2.-Add-Ins.png\" alt=\"\" width=\"416\" height=\"458\" \/><\/a><\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>c)<\/strong>\u00a0If these options are installed properly, dialog box should disappear, otherwise it will either error out or ask for Office Installation CD.<\/p>\n<p style=\"text-align: left\"><strong>2.<\/strong>\u00a0<strong>Make sure the general macro feature is working in Excel: <\/strong>In Trust Center, go to Macro Settings click on radio button &#8220;<strong>Enable all macros<\/strong>&#8221; and check the \u201c<strong>Trust access to the VBA project object model<\/strong>\u201d option.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/3.-Trust-Center.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter  wp-image-2590\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/3.-Trust-Center.png\" alt=\"\" width=\"715\" height=\"433\" \/><\/a><\/p>\n<p style=\"text-align: left\"><strong>3.<\/strong>\u00a0<strong>Temporarily disable all excel Add-ins: <\/strong>Navigate to Files &gt;&gt; Options &gt;&gt; Trust Center &gt;&gt; Trust Center Settings &gt;&gt; Add-ins. Check the \u201c<strong>Disable all Applications Add-ins<\/strong>\u201d and Close Excel.<\/p>\n<p style=\"text-align: left;padding-left: 30px\">Run Financial Reporter (FR). Restore option to enable add-ins (whether FR works or not). If FR worked when add-ins were disabled, re-run FR after add-ins are enabled.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/4.-Trust-Center.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-2591\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/4.-Trust-Center.png\" alt=\"\" width=\"698\" height=\"353\" \/><\/a><\/p>\n<p><strong>Note:\u00a0 If solution is not attained even after all these steps, re-install Microsoft excel.<\/strong><\/p>\n<p style=\"text-align: left\"><span style=\"line-height: 1.6em\">Hence, by making above necessary settings, users can resolve the error and run Financial Reporter Add-in for Sage 300 ERP or any other Add-ins in excel.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In statement designer when Users click on start button, sometimes they may face or may come across an Error with description as \u2018Problem in Starting Financial Reporter Addin\u2019. To avoid this error follow below mentioned steps; 1.\u00a0In Excel: a)\u00a0Go to main control button at top left corner of an Excel sheet, choose Excel options &gt;&gt;\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-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":[84,85,978,1018,2032,2746],"class_list":["post-2587","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac-error","tag-accpac-excel-error","tag-financial-report-error","tag-fr-error","tag-problem-in-starting-financial-reporter-addin","tag-statement-designer-error"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Statement Designer Error in Financial Report of 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\/02\/15\/statement-designer-error-in-financial-report-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=\"Statement Designer Error in Financial Report of Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"In statement designer when Users click on start button, sometimes they may face or may come across an Error with description as \u2018Problem in Starting Financial Reporter Addin\u2019. To avoid this error follow below mentioned steps; 1.\u00a0In Excel: a)\u00a0Go to main control button at top left corner of an Excel sheet, choose Excel options &gt;&gt;\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-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-15T11:29:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T06:03:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.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=\"2 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\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/\",\"name\":\"Statement Designer Error in Financial Report of Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png\",\"datePublished\":\"2013-02-15T11:29:12+00:00\",\"dateModified\":\"2025-07-18T06:03:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statement Designer Error in Financial Report 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":"Statement Designer Error in Financial Report of 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\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Statement Designer Error in Financial Report of Sage 300 ERP","og_description":"In statement designer when Users click on start button, sometimes they may face or may come across an Error with description as \u2018Problem in Starting Financial Reporter Addin\u2019. To avoid this error follow below mentioned steps; 1.\u00a0In Excel: a)\u00a0Go to main control button at top left corner of an Excel sheet, choose Excel options &gt;&gt;\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-02-15T11:29:12+00:00","article_modified_time":"2025-07-18T06:03:36+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/","name":"Statement Designer Error in Financial Report of Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png","datePublished":"2013-02-15T11:29:12+00:00","dateModified":"2025-07-18T06:03:36+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/02\/1.-Error.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/15\/statement-designer-error-in-financial-report-of-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Statement Designer Error in Financial Report 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\/2587","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=2587"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2587\/revisions"}],"predecessor-version":[{"id":35478,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2587\/revisions\/35478"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}