• GL Transaction Report

    I cannot get to the Sage Intelligence Reporting. When I click on Report Viewer, it asks for a network repository, and I select a folder but it just keeps asking for the network repository path. My question is 1) How do I get passed this, or 2) Is there…
  • 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…
  • BI Tools in Excel Keeps Disappearing

    I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…
  • Power BI and Sage Intelligence and looking to hire an expert

    Hi All, Our company has Sage 100 2015 and we are just now starting to use Sage Intelligence. I am pretty used to report writers so learning to write reports in SI is fairly easy. However, my difficulties have to do with the set up of Power BI…
  • Sage 100 ERP 2017 Advanced Business Intelligence Explorer

    We are currently using Microsoft Access to collect AR Invoice History detail data. We have data from 1999 & use Access to lookup prior invoice line information detail, which displays service performed. We search by a UDF_ServiceLocation field. If possible…
  • Sage Intelligence and Microsoft Excel Tips and Tricks

    Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…
  • Use a calculated report as base for multiple reports with additional filters

    I have a customer that updates up to 2500 invoices in a day. I have created a report that pulls all the necessary header and line detail information to produce several pivot reports. Is there a way to now use this report (so it does not have to be…
  • Previous Month - Rolling, to be used for automated report delivery

    Currently using Sage 100 2013 and Sage Intelligence 5.0. We have a need to pull previous month transactions from AR_InvoiceHistoryHeader. Would like to filter this data based on the ShipDate. We would also like these report so be distributed automatically…
  • Sage Intelligence Link Formula between Excel worksheets

    Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report? The purpose is to is to simplify update of accounts Say sheet1 we have a good report. In sheet2 column A, we want to link to accounts in sheet1. If…
  • 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…
  • Server Upgrade for MAS90 and MAS Intelligence

    We plan to upgrade the server for MAS90 before year end and move to the latest version of SAGE, would the MAS Intelligence reports carry over, or is there a new reporting package? The IT department has informed me that FRx will not be available on the…
  • Excel Output has #NAME? errors

    I can run Sage Intelligence reports under my Windows profile and they work fine. Other users get the #NAME? for all formulas in the output of Excel. Other users have the same permissions that I do. Would anyone have any ideas on what would cause this…
  • RE: Noob question on reporting options (formerly on FRx)

    There are some options for migrating some canned reports and some of the trees as I recall, but if they are really customized FRx reports then there's a lot of cleanup work that has to be done. They might have to evaluate each report on a case-by-case…
  • Noob question on reporting options (formerly on FRx)

    Since the update to Sage 100 2013, staff are asking for FRx migrated reports. How and if that's possible remain a mystery to me. I've installed and licensed our 1 user Intelligence reporting and referred them to learning the product. Is there anything…
  • Getting the Most from Sage Intelligence Reporting

    "When creating Executive Dashboards for financial reporting, how can I get the information I need from Sage Intelligence Reporting or BI queries" was a hot topic from the Sage City Live networking event at Sage Summit 2013. How are you using Sage Intelligence…