Hi my client is on ver 11.1.1 of sage 200 evolution - and we cant seem to get the BIGenerator addin to show up under addins.
its not under inactive or disabled addins either.
When trying to manually install it says its not a valid excel addin.
They…
V2024
logged Sage 300 as Administrator, when run any reports, we get above error, even when firewall is off.
Everything else in Sage in fine.
Please help.
We recently upgraded to Sage 300 2024 and added Web access. Intelligence Reporting does not work with the Web screen. Does anyone know of a workaround or if this may change in the future?
Hi there, just a quick question please.
to do custom reports or build sql queries easier (what I actually would like to achieve) would Intelligence reporting be the one to use? and I assume one would need advance for that? the evDict is abviously useful…
I have a client that wants to send the financial reports to a partner that does not have access to Sage 300. We would like the partner to be able to change the parameters on the Excel workbook that is e-mailed so he can take different looks at the data…
Sage300 2018 v6.5 Program: Workstation local Share Folder: Server folder
Workstation - Win10, UAC enabled (Cannot change)
SI Activate License in Server. Server is working fine.
All workstation able to see IR license if run as administrator. All…
My reports from Intelligence Reporting (Sage Evolution) are returning #VALUE errors after my Excel was upgraded from 2016 to 2019.
These are all the add-ins that I currently have.
Am I missing anything?
Or has anyone else come across this error…
I am attempting to create an On-Time Shipping Report. I want to add a parameter to only show items shipped during a certain date range.
I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records.
Any…
Hello everyone I am a new IT person to involve with sage50
I want connect to database by using 3rd party application such as Excel, Access, Power bi through ODBC to create real time and interactive report by power BI, I following this article https…
Hi,
I have a client running Sage 2022.0 on RDS Windows 2019. On the RDS, we have published the workstation, hence Sage resides on a different application server. UAC and Windows firewall are off on both servers. I have also run REGACC as Administrator…
We will be removing the Sage Intelligence Reporting solution from our Sage 50 U.S. Edition product portfolio. We have made this decision to streamline our product offerings and development resources to better serve our customers.
Sage Intelligence Reporting…
I am trying to create a SQL stored procedure with a date range parameter to be used in a Sage Intelligence report. One old procedure uses the following:
CREATE PROCEDURE [dbo].[TJWEEK]
-- Add the parameters for the stored procedure here
@S_Date…
I currently use @GLActual and @GLBudget formulas to pull financial data by GL accounts. Is there a way to add another layer and pull this same type of info for specific job numbers (customers)? Right now it looks like the 3 dimensions the formulas use…
Whenever I open excel I got error message saying
The file format and extension of 'Sage.BI.ExcelFunctions1.1.xll' don't match. The file could be corrupted or unsafe.
I am new to Sage300 so i'll apologies in advance. I am trying 2 things to work on sage300 (2021).
1) I am trying to get department name on FR View dynamically. I have tried following but did not work for me.
=IF(ISNA(IF(FR("ReportAs")="Separate",FRSDESC…
We have a person that just started learning Sage 50 US Intelligence Reporting recently. We purchased the connector a month ago but have not installed it because we aren't on the newest software version. We got the email notice that it is being retired…
On our Sage 50 2022 we are receiving a notification about Sage 50 Intelligence Reporting is being retired.
Will this affect the reports that are designed in this tool after the stipulated date?
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
Hi everyone,
1. We are not happy with the standard Customer reports in Sage
I have had a look at Sage Intelligence reporting, but this only reports on the financials (Profit & loss and the Balance sheet) in various lay-outs - nothing on sub-modules…
Does a profit and loss report exist in Sage 50?
Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage?
I would like the report to include income, cost…
We have created a Financial Statements SAGE Intelligence Report Template that has default Distribution Instructions attached to it. For one particular user, it seems that these Distribution Instructions intermittently do not load with the template for…
Hi,
I am trying to spool a report on intelligence reporting- Financial Designer Cashflow Prt. However, the figures keep showing as error.
Please what do we do?
Regards,
Akin
Hello, I am having trouble with a running a few reports in the Report Manager that I have created data containers for in the Connector Tool. I keep getting a missing resource error like this one:
https://imgur.com/a/PlNPghp
This occurs right at…
Hi,
I have Sage 50 US Quantum 2020 edition.
How can I make a copy of a standard Intelligence Reporting, Jobs Profitability Report, into the Report Manager so I can modify it. I need to modify it a little and regularly email to someone in the company…