--- title: Improved Sage ERP Accpac reporting features and no charge to use it! description: What's New in InfoExplorer 2011. More new features at no-cost. Find out how. --- [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. # Improved Sage ERP Accpac reporting features and no charge to use it! **twitter **linkedin **facebook Based on demand from customers and partners, Orchid Systems have released numerous feature enhancements for Info Explorer which includes the **ability to filter on totals. **The details on updates to Info Explorer can be found on the “What is new in Info Explorer”. Here is a summary of some new features and functions that have been released: - Apply row and column filters based on calculated fields in the cube ![Apply row and column filters based on calculated fields in InfoExplorer cube](https://www.equationtech.us/hs-fs/file-14058253-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer1-resized-600.png) - **6 New Info Explorer 2011 Cubes** Accounts Payable **AP Purchases by GL Account** AP Open Payables – aged by Due Date Accounts Receivable **AR Receivables by GL Account** AR Open Receivables **AR Sales by AR Item** General Ledger GL Summary Actual vs Budget Analysis GL Detail Analysis – single year **GL Consolidation across 2 companies** Order Entry OE Sales Summary by Customer, Item, Sales Person **OE Back Order Analysis** Project and Job Costing PJC Cost and Revenue Analysis PJC Transaction Analysis Norming Fixed Assets **Fixed Assets Analysis** - Create user definable formulas in the cube ![Create user definable formulas in InfoExplorer cube](https://www.equationtech.us/hs-fs/file-14058269-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer2.png)     - Define parameters for your query ![Define parameters for InfoExplorer](https://www.equationtech.us/hs-fs/file-14058287-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer3-resized-600.png)   - Define security for your cube by:   - Set your cube to "auto refresh", i.e. it will automatically refresh on opening the cube file ![Set your InfoExplorer cube to "auto refresh"](https://www.equationtech.us/hs-fs/file-14058326-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer6-resized-600.png)   - ODBC driver access - to access other databases other than MS-SQL, Pervasive-SQL, Oracle or DB2 ![InfoExplorer ODBC driver access](https://www.equationtech.us/hs-fs/file-14058318-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer5.png)   ## How To Change What You See In InfoExplorer Using InfoExplorer, users are able to perform the following: - Create new views of your data. Click on the different views to see data organised in a different way. In the example below, AP Outstanding Transactions, Outstanding by Vendor Group, Outstanding with Aging, AP Outstanding by Vendor are views on the AP query, and AR Outstanding Transactions is the view on the AR Query. - Create new charts of your data. Click on the chart to see the data represented graphically. In the example below Outstanding Aging Chart and Outstanding by Vendor group are two charts on the AP Query. - Create new dashboards to view multiple views and charts on the same screen. In the example below there is one Dashboard shown at the top of the list of queries/views/charts - Drag and drop the rows and columns to see data organised in a different way. In the example below you could swap the customer and customer goup dimensions, to see a list of customers by DateDueYear. - Filter the underlying dimension data to see a filtered subset of your data. In the AR Query below you could filter out all credit notes. - Filter the rows and columns based on calculated facts to see a filtered subset of your data. In the AR Query below you could show only those customers where their total amount due was greater than $1,000 - Create new facts to analyse based on calculated data. In the AR Query below you could rank your customers by amount due. - Create parameters for your queries to restrict the data retrieved into the cube. In the AR Query below you could restrict the customers by Sales Rep. - Open a second (and third, and fourth etc) cube to display multiple cubes on multiple tabs. Highlighted in purple below - Create a new query within an existing cube, and save views on the new query. Highlighted in yellow below ![Open & Create a new query in InfoExplorer](https://www.equationtech.us/hs-fs/file-14058306-png/images/s--equation-marketing-2010_hubspot-blog_entries-03-16-2012_infoexplorer4-resized-600.png) Demonstration cubes are now available to Info Explorer Lite users **(Don’t forget that any Sage Accpac customer on Version 5.4 and higher can use Info Explorer Lite with the demo cubes for FREE!).  **Equation can help you install Info Explorer Lite. [![Click me](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/330c7a47-fe7f-4d15-870c-af3ebf8196e3.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/330c7a47-fe7f-4d15-870c-af3ebf8196e3) ### 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, Mar 16, 2012", "datePublished" : "Fri, Mar 16, 2012", "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" : "Improved Sage ERP Accpac reporting features and no charge to use it!", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/bid/82845/more-improved-reporting-features-for-sage-erp-accpac-and-no-charge-to-use-it", "@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." } } ```