• Sage Intelligence and Office 365

    We are using Sage 500 2018 (v7.9) and we recently upgraded from Office 2016 to Office 365. Now our Accounting department is receiving errors when using Sage Intelligence i.e. Sage.BI.ExcelFunctions1.1.x11 don't match. I have tried to Add the Report Designer…
  • Sage Intelligence Filter and Parameter combination - need help

    Need some eyes on a Sage Intelligence Transaction report filters and parameters. Please see attached file. Adding filters with parameters works for one set but not another. Can someone look to see if you have a suggestion as to why the filter/parameter…
  • Duplicate account numbers in consolidated report (Accounts S500 1-0)

    Changed a report to pick up 3 of our companies (A,P and C) (Created consolidated connector then exported and imported the report using the consolidated connection) The accounts union report (Accounts S500) is one of the many that are included in it…
  • Getting errors in my MAS Intelligence Report Designer reports.

    On several of our Report Designer reports we are now getting #VALUE! or Object reference not set to an instance of an object errors when just the other day they were fine. I believe it is an Excel issue this time since I ran and saved the same reports…
  • Income Statement - Current Quarter

    What is the best way to create an Income Statement that contains 2 columns, the first column is "Current Quarter" and the second column is YTD column? I am trying to figure out the best formula for the current quarter. Is there a way to input a range…
  • Sage Intelligence Row definition

    We are trying to use SI as a replacement for FRx. It does not appear to have the concept of Trees or Rows. Anyone had this issue and if so how did you get around it?
  • Sage Intelligence Sage500 Statistical data

    Can SI for Sage500 pull Statistical GL data, i.e. Qty? If so any hints on how?
  • Sage 500 ERP Intelligence Reporting Webcasts (Oct, Nov, & Dec.)

    Sage 500 ERP Intelligence Reporting gives you more time to analyze reports so you can make smart business decisions that will give your company a competitive edge. Get the most out of Intelligence Reporting by signing up for these free webcasts in October…
  • Using Microsoft Power BI with Sage Intelligence Reporting

    Hi all. Last year I provided two webcasts on how Microsoft Power BI can be used with Sage Intelligence to provide attractive and interactive visualizations of your data. I also covered some of the other benefits of making use of Power BI like sharing…
  • Drill Down Error - Invalid authorization specification

    I was following the instructions from this website: https://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2013/11/drill-values-view-deeper-level-data/ When trying to run the second drill down on the report, I get an error…
  • Free five-part video series on reporting: Gearing Up with Sally

    Learn about report creation and how to visualize your data better with this FREE, five-part video series. In Starting Out with Sally , you discovered how to make sense of the numbers behind your business, as Sally led you through practical ways to improve…
  • Sage 500 Intelligence Reporting: Report Utility

    Get immediate access to a library of additional reports As your business evolves and grows, so too do your reporting needs. We understand that it’s not always realistic to wait for the next Sage Intelligence update to get your hands on the reports that…