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…
We have created a report using the trees - which works
Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc
Non organic 12,18,32,etc
How can I drag all the trees into…
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!
We are using Sage 500 2018 (v7.9) and we recently upgraded from Office 2016 to Office 365. Now our Accounting department is receiving errors when using Sage Intelligence i.e. Sage.BI.ExcelFunctions1.1.x11 don't match. I have tried to Add the Report Designer…
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?
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…
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
I am looking to create some buckets of dates in Sage intelligence. I am very new to Sage Intelligence, so please help me understand.
I started by creating a view in SQL (I was planning on creating a view for each bucket and then combining the views…
After switching machines, my Sage Intelligence reports are not sending properly. I had been sending the reports to users utilizing the File - Share option in Excel on my old laptop. After switching, when I send through the File - Share option, all users…
We would like to install Excel 2019 perpetual license so Sage Intelligence can be run, however, the Sage Compatibility Matrix lists Excel 2010, 2013, 2016 or o365 Desktop as compatible with Sage Intelligence for Sage 100 version 2020 (6.2). Excel 2019…
Have a recurring issue where the report run time is considerably different from one workstation vs another. A report takes 11 mins on one and 40 on another. Looking for advice on what to look for between the 2 workstations. Sage 100c v2018 adv.
On several of our Report Designer reports we are now getting #VALUE! or Object reference not set to an instance of an object errors when just the other day they were fine. I believe it is an Excel issue this time since I ran and saved the same reports…
First thing to check is your edition of Sage 50 CA, is it Pro? If so, then you only have 7 years + the current year of financial data for reporting available. The Premium and Quantum editions allow for a history of 100 years of data.
Side note: Our…
What would the sql statement be to add 3 business days to the Sales Order Delivery Date?
There is probably a shorter version but I got this to work.
CASE
WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader…
I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
Hi,
i get this error when open BI Report Manager
I'm on Sage 2014 PU3
"The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : -
SELECT…
I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?
I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report.
I can see the revised budget in the Budget Maintenance screen. I have reviewed the…