--- title: How to enable FR Drilldown in ACCPAC Financial Reporter description: Learn how to enable drill-down function using Sage Accpac Financial Statement Designer when creating your financial reports. image: https://www.equationtech.us/hs-fs/file-14054012-png/images/fr-1-thmb-resized-600.png --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # How to enable FR Drilldown in ACCPAC Financial Reporter ![technology blog](https://www.equationtech.us/hs-fs/file-14054012-png/images/fr-1-thmb-resized-600.png) **twitter **linkedin **facebook Using  ACCPAC financial statement designer, we can easily enable the FR Drilldown function in ACCPAC . This function allows a user to right-click their mouse on a specified field on the financial statement in Excel and drill into the original transactions within ACCPAC. 1)  Login in to ACCPAC , go to GL Financial Reporter, “Statement Designer”, and start the program. ![Accpac General Ledger Statement Designer](https://www.equationtech.us/hs-fs/file-14054012-png/images/fr-1-thmb-resized-600.png) 2) This will open an Excel workbook, use the canned ACCPAC financial statement  **quickinc1.xls** located in my applications directory, which will be something similar to C:\Program Files\Sage Software\Sage Accpac\GL56A\ENG.  Depending on which version of ACCPAC you are running it may be GL55A\ENG, GL54A\ENG, etc. 3) Notice the highlighted formula below in cell G15: ![Financial Statement Formula](https://www.equationtech.us/hs-fs/file-14054029-png/images/fr-2-thmb-resized-600.png) The formula is  **=FRAMTA(“NETYTD”) **, which is pulling YTD net changes for that column. We want to enable drilldown for this column of data. 4) Change each of the control formulas in cells G15, G24, and G32 to enable drilldown. The new formula used will be  **=FRTRNA(“NETYTD”)** . Adding FRTRNA as the formula type will enable drill down in your ACCPAC financial statements. ![Enable Financial Reporter drilldown in Sage Accpac](https://www.equationtech.us/hs-fs/file-14054060-png/images/fr-3-thmb-resized-600.png) 5) Rerun the financial statement using FR VIEW ![Sage Accpac FR View](https://www.equationtech.us/hs-fs/file-14054092-png/images/fr-4-thmb-resized-600.png) You will notice in the output that there are now red arrows in each of my data cells: ![Accpac Financial Reporter Drilldown Functionality](https://www.equationtech.us/hs-fs/file-14054193-png/images/fr-5-thmb-resized-600.png) These signify that drill down functionality is available for that cell. 6) Right mouse-click one of those cells, and choose “FR Drilldown”, you will get a window that shows all transactions that make up that number for the period. ![Accpac FR Drilldown](https://www.equationtech.us/hs-fs/file-14054219-png/images/fr-6-thmb-resized-600.png) You can take this another step further as well, if you highlight one of the rows in this window and double-click it you can drill directly into the original GL batch entry: ![FR Drilldown to GL Batch Entry](https://www.equationtech.us/hs-fs/file-14054249-png/images/fr-7-thmb-resized-600.png) 7) A few items to note: - This will work on any of your custom financial statements, not just the canned ACCPAC statements. - Drill down only works with net change data, not balances. - Depending on the amount of data you have in the database and the format of your financial statement, enabling FR drilldown can degrade processing time when running your financial statement. - Drilldown will only work with financial statements opened and ran through FR Statement Designer. We hope this tech-tip is helpful to you and if you have any other questions, comments and/or feedbacks regarding Sage Accpac's Financial Reporter feature or function we would love to hear from you. ### Related Articles ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ##### [How to Simplify Payroll and Job Costing with Sage 300](https://www.equationtech.us/sage-accpac-blog/how-to-simplify-payroll-and-job-costing-with-sage-300) Getting payroll to play nice with your job costing system is like fitting a square peg into a round... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "EQ Tech" }, "dateModified" : "Fri, Oct 29, 2010", "datePublished" : "Fri, Oct 29, 2010", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "How to enable FR Drilldown in ACCPAC Financial Reporter", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "//cdn2.hubspot.net/hub/41683/file-14054012-png/images/fr-1-thmb-resized-600.png", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/bid/49610/How-to-enable-FR-Drilldown-in-ACCPAC-Financial-Reporter", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```