Browse By Tags

  • Intelligence stopped refreshing data when changing Period or Year. Any ideas how to fix it?

    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…
  • Sage 300 Intelligence reporting

    When using Sage 300 webscreens, is there a way to run Intelligence reporting with installing Sage 300 desktop version.
  • How to get inventory ageing report ?

    How to get inventory ageing report in sage 200 evolution?
  • Create company parameter for Intelligence report template used across multiple databases

    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…
  • Breaking Links within Excel Intel Report

    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
  • Accounting Intelligence Reporting Not Working

    Hi All, I work for a group of companies all of which are on Sage One Accounting. When I enter into Accounting Intelligence Reporting and Upload my company data only the following reports work - Financial Management Pack, Dashboard Accounting, Financial…
  • Report search in viewer & Designer

    Anybody know any search report name or report ID feature in Sage Intelligence?
  • Sage Intelligence Report Designer

    Hallo, My sage Intelligence financial report designer does not have ; >Instructions sheet, >Dashboard Sheet, >Also giving me this error #Name . See screen shot below: Also trying to download Report download community this is what am g…
  • GLAccountEvo sums up subaccounts to main account thus inflating the values.

    i have a segmented GL. when running the Business Intelligence reports it sums up the values into the mainsubaccount. This inflates my values. Is there a solution for this or should we use another function if so which one. Tiro
  • PLDONGLE.DLL is empty and the download has been aborted.

    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…
  • Added a new company in Sage 100. How do we connect sage intelligence to the new company

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

    Intellegent reporting is linked into SAGE Online Earlier today I logged in and use the system ..all of a sudden the system does not want me to continue as I am adjusting reporting with the message: Sorry, an error occurred while generating the report…
  • Duplicate Sage300 User ID in intelligence Reporting

    There is a customer, some Sage300 user ID are duplicated in Intelligence Reporting security. Such duplicated ID cannot use run report properly. Would you kindly let me know how to rebuild the Intelligence Reporting User table or fix the problem?
  • Sage 300 People Sage Intelligence report templates

    Hi All, I will like to know if there is a group for Sage Intelligence where I can access free SI report templates.
  • Cannot save Excel template

    Receive "No workbooks Open to Link" when trying to save an Excel Template
  • 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…
  • Can't get accounts to populate properly

    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…
  • Error Number: [462] BICore

    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…
  • BI tools menus cannot be resized

    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…
  • Report Writer - Searching for Consultant

    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…
  • Function GetDataValue can only service SQL calls that result in a single return value' preventing deletion of report.

    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
  • One Report Two File Outputs needed

    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…
  • Schedule a Sage Intelligence report to run automatically

    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…
  • Error running out the Financial Report Designer

    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…
  • Fetching Alternate Item in query

    Trying to return the corresponding itemno for a given icitem.altset #. Normally, I'd just write a SQL statement such as: select [icitem].[itemno] from [icitem] where [icitem].[altset] but, alset is an integer, and I can't find a column in icitem…