Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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!
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
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.
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…