• 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?
  • Multi-year (beyond Actual and Prior) comparative financial statements

    Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence? Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on…
  • sql server new connection

    How do I add a new connection to a sql server in the same network as Sage 100 cloud?
  • 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…
  • Not getting any data

    Hello, I am new to Sage and the usage of ODBC. I am able to run through the step in Excel (Get Data -> From Other Source -> Microsoft Query -> Pick my database -> I choose "GL_TrialBalanceWrk" -> select all with no filters) everything runs smoothly and…
  • Profit Report by Customer

    Is there a way to do a profit report per customer?
  • 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…
  • 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…
  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • Workstation "locked" while SI reports run

    A client has 84 companies in their Sage 100 Standard system, which was recently upgraded from v4.50 to v2016. The upgrade was installed on a new Server 2012 and workstations are new Windows 10 units, all exceeding current SPM specs. In Sage Intelligence…
  • 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…
  • Connectors

    HI There, When I was at Sage Summit I was told that I could find a list of Table Connectors on Sage City, does anyone know where to find this report? I'm trying to find what connectors match up so that I can run an A/P report with some general ledger…
  • Renovo vs Intelligence Reporting/Report Writer

    Sage 100 2014 - Server 2008 I am finally finding acceptance in letting go of Frx. I had to go through all the steps of grief. LOL. I have used FRx since the 90s. But it's time to move on, obviously. I have watched both Youtube presentations of Renovo…
  • 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…
  • Error Printing range of Invoices (Data is not selected for report printing)

    I do not want to use the option "Print the option already printed" I know for sure that there should be a way to print in range without selecting that option. Thank you for your help.
  • 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…