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

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

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 in a new…

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

When I run a standard Customer Sales report in Intelligence for a month (Nov in this instance) it does not tie to the PL or sales recap report .  Intelligence is typically higher than the PL.  I can trace it to a specific product line but I don't see anything…

A client has 15 Sage 100 companies & 9 Excel spreadsheets. Each spreadsheet has 20 tabs - one for each company plus several for combining different companies.  SIR will take about 5 minutes to load. I'm looking for a recommendation as how to structure…

Good afternoon.

It is my understanding that we are no longer able to publish Sage Intelligence financial reports that were generated using the Consol Financial Report Designer using the Distribution Tab in the BITools Ribbon beginning with version 2019…

Hello to our Sage 100 U.S. members! :) 

We understand the impact the Coronavirus (COVID-19) is having and how it has and still is affecting your business. We want you to know: we're here to help and as the new year approaches, we would like to take the…

any suggestions regarding Cost of Goods sold for sage Intelligence reporting... this is after the fact General Ledger only does not tie to the A/P module. I need to be able to show the beginning inventory balance, plus the purchases, and then deduct the…

Has anyone come up with a way to force SMI to generate reporting units to individual worksheets without manually creating a worksheet for each unit? I have a client migrating from FRx and they have a reporting tree with 280+ units.  Creating a worksheet…

We have added a new company.  When we try to generate our Sage Intelligence reports only the headers appear, the report does not display any data.