Sage 100

I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…

I feel like the Not Equal join used in Crystal in order to combine the Company file in a report to be able to get the company name/code would not work in SI. Is there a way of adding the company code for NON-FINANCIAL reports?

Hello, I'm just trying to set up auto delivery for this report but it looks like it is only available in the stock Crystal Report form. Does anyone know if it's available in Sage Intelligence or if there is a way to convert Crystal Report reports to Sage…

What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…

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!

What are the steps to upgrade Sage Intelligence on Sage 100 standard 2015 to Sage 100 2023 Premium (SQL)?

I am creating a new report for a client and after saving and re-running, the first custom tab has been partially overwritten by four columns of CompanyCode, Rollup Type, Rollup Type Description, and Rollup Code. The standard Rollup tab is still hidden…

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.

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 has stopped refreshing when I change the Period or Year. I have formulas linked to a Year and Period so that changing either cell with the Year or Period changes the data to that time frame. It worked fine in a previous report version…

We have a client that has several hundred companies in Sage 100. They have a report template that they would like to run individually on each of these companies. The customer owns the Connector module. Using the standard Autoconnect connection in…

Normally I'm able to hit alt-E-K to eliminate all of the external links and replace with values within a spreadsheet, but no such luck with an Intel report. What steps am I missing? Thanks

Trying to register in license manager and getting this error: Error: “The download file (PLDONGLE.DLL) is empty and the download has been aborted. Please check that your internet connection is functioning correctly." I have checked all the environmental…

User has added a new company in Sage 100, but doesn't know how to integrate the new company with SI reporting

Receive "No workbooks Open to Link" when trying to save an Excel Template

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…

Hello I have a 2018 Premium install of Sage 100 and I cannot get certain accounts to populate with balances in Sage Intelligence. The balance says zero but there is a balance in there for the period and year selected. It's selective. Some accounts do…

We are getting this error message on 4 machines (same company) running financials in Sage Intelligence. Error Number: [462] Description: [The remote server machine does not exist or is unavailable] Source: [BICore] The server is running Excel…

Using RDS to use Sage 100/Sage Intelligence. When clicking the BI Tools, manage instructions or select instructions, the window pop up isn't able to be resized and can't see and select what we need. They have it restricted to change the resolution. It…

Hi, I run a fire protection company. We started a year ago and have grown to be 55 people and ~$7m of revenue. We use Sage 100. We're starting to need to get into analytics. We have an install and service part to our business and multiple services lines…

I want to delete a report - get an error 'The function GetDataValue can only service SQL calls that result in a single return value' how can I fix this? We are on Sage 2020, not on a SQL server backend

Does anyone know if in Report Manager you can create 2 types of output files (xls & pdf) run with windows scheduler from one report or do you have to create a copy of the report to be able to do a second report output and schedule it after the 1st one…

If you want to run a Sage Intelligence report using Task Scheduler I see that the workstation where you create the scheduled task must be turned on at the scheduled time. The workstation I wanted to use probably isn't going to be on so can I setup the…

I successfully registered Sage Intelligence on a Terminal Server. The client is on v2020 Advanced. Excel 2007 is loaded on the Terminal Server. I can run out the non-financial report designer templates fine. When I try to run out the Financial Report…

I'm suddenly getting this error and the only thing that stops it is a reboot. Microsoft Excel is waiting for another application to complete an OLE action Running Sage 100 Advanced on Windows 2019 Server & Excel Standard 2016