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 add functions

    SI has a function for "GLActual" that nets the debits and credits. Is it possible to add 2 different functions to get the debit and credit separately? the data exists in the actuals currently included sub report.
  • convert single company GL reports to consolidated company reports

    Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports? Or, is there a way to set the company code and add the 8 companies as sub-reports?
  • Sage Intelligence report loses formatting when distributed

    After switching machines, my Sage Intelligence reports are not sending properly. I had been sending the reports to users utilizing the File - Share option in Excel on my old laptop. After switching, when I send through the File - Share option, all users…
  • 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…
  • report run time different between workstations

    Have a recurring issue where the report run time is considerably different from one workstation vs another. A report takes 11 mins on one and 40 on another. Looking for advice on what to look for between the 2 workstations. Sage 100c v2018 adv.
  • 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…
  • When will Sage Intelligence work with Excel 2019?

    When will Sage Intelligence work with Excel 2019? IT department upgraded everyone to Excel 2019 and now Sage Intelligence doesn't work.
  • Sage 300 Intelligence Reporting module :- Run-time error '13':Type Mismatch

    We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
  • 65K row limit

    I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?
  • Report Designer - Sage 300ERP version 2012 - Budgets query not pulling in Revised Budget (Budget Set 2)

    I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report. I can see the revised budget in the Budget Maintenance screen. I have reviewed the…