Browse By Tags

  • Sage Intelligence and O365 Cloud

    Does anyone know if Sage is planning on supporting Sage Intelligence with O365 Cloud? I have several clients having issues with not being able to use SI with O365 Cloud and needing to install Excel locally. Thanks!

  • Sage Intelligence duplicating data single table

    On Sage 100 Advanced 2021 sp5. I created a container with only the AR_InvoiceHistoryHeader file. added 4 fields. set the filters to a single date and only Source Journal "SO" the invoices are all duplicated. I tried the same thing on a different…

  • Is Excel 2019 Perpetual License Supported with Sage Intelligence (Sage 100 v2020)

    We would like to install Excel 2019 perpetual license so Sage Intelligence can be run, however, the Sage Compatibility Matrix lists Excel 2010, 2013, 2016 or o365 Desktop as compatible with Sage Intelligence for Sage 100 version 2020 (6.2). Excel 2019…

  • 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…

  • Excel is not populating all of the data.

    I have an Intelligence report generating and excel document. There are several sheets. One sheet in particular stops populating part of the records at line 3000. The other sheets populate just fine past the 3000 line. This sheet has 8 columns of data…

  • Sage Intelligence with Excel 2019

    Sage Intelligence has been tested at high level and found that it works with Excel 2019. However, issues may arise from consistent Microsoft updates. In those cases we will determine cause and method for resolving. In one example, a Microsoft update…

  • Sage Intelligence Data Limit Reached in Excel

    I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
  • The Top Ten Excel Tips and Tricks of 2017

    The Top Ten Excel Tips and Tricks of 2017

    These Microsoft® Excel® tips and tricks are the best of the best. They’re the top performing tips of 2017, and have raked up the highest number of views. In fact, with a combined viewership of over 220 000, these tips deserve their own television channel…
  • Can Excel be considered a complete BI solution?

    Can Excel be considered a complete BI solution?

    While trawling through the old files on my organization’s server recently, I stumbled across a 2008 report in which Forrester Wave for Enterprise Business Intelligence Platforms assessed 12 BI vendors/tools. While the report was incredibly interesting…

  • Sage Intelligence and Excel tips and tricks

    If you're a Sage Intelligence user and would like to keep up to date on handy ways to use the product for your business reporting, then why not subscribe to our SI Tips and Tricks and Excel Tips and Tricks mailers? By subscribing to the SI mailer you…

  • Sage Intelligence and Excel tips and tricks

    If you're a Sage Intelligence user and would like to keep up to date on handy ways to use the product for your business reporting, then why not subscribe to our SI Tips and Tricks and Excel Tips and Tricks mailers? By subscribing to the SI mailer you…

  • Sage Intelligence and Excel tips and tricks

    If you're a Sage Intelligence user and would like to keep up to date on handy ways to use the product for your business reporting, then why not subscribe to our SI Tips and Tricks and Excel Tips and Tricks mailers? By subscribing to the SI mailer you…
  • Microsoft Excel: The good, the bad, and the advantage of added BI capability

    Microsoft Excel: The good, the bad, and the advantage of added BI capability

    Microsoft Excel is the universal language of business and accountants, and most decision makers in small to mid-sized businesses use the king of spreadsheets in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still…

  • Error 462 while attempting to run Sage Intelligence Reports (in Sage 100c 2016)

    I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…

  • When I distribute the reports I cannot select the charts, only the worksheets - how do I share the entire workbook?

    Sage Intelligence 2014 My workbook contains charts, yet when I select the distribution instructions, I can only select the data sheets and not the charts. How can I distribute the charts in the workbook?

  • Most people only use +/-5 percent of Excel

    I've seen some people really struggle with Excel, but minus 5 percent is a pretty harsh grade.

  • RE: Sage MAS 500 - Desktop Enterprise Edition

    Hi Julie. If you're going to be using Sage Intelligence for your reporting then here are some links you can look at: www.sageintelligence.com www.sageintelligence.com/sage-intelligence-tips-tricks www.youtube.com/.../SageIntelligence www.sageintelligencecommunity…

  • Still looking for an FRx replacement? Register for session BUS-563 at Sage Summit

    FRx reports can be efficiently converted to Sage 100 ERP Intelligence Reporting using the powerful functionality of the Sage Intelligence Report Designer. Sage Intelligence Product Specialist, Sandra Smith, will show you how to simply export existing…

  • How do you produce effective, multi-currency financial statements?

    How do you produce effective, multi-currency financial statements?

*Community Hub is the new name for Sage City