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.
Would it be possible within Report Designer to add a conversion field of Fiscal to Calendar?
If 2 UDF's were added to Fiscal Year Maintenance for each period noting the calendar year and period, could they then be used in consolidated financials?
…
can someone tell me a sql formula to use in a Sales Order container to drop the leading zeros.
I need to match / index to files where the sales order number is entered without the leading zeros.
In Sage Intelligence if I run the report Fiscal Year Detail, the start date is not accurate if you are using a 4-4-5 Fiscal Year.
The formula used to calculate the start of the month is not accurate and is off by days, resulting in incorrect period…
Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?
We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
I have a client that is getting the following error when they try and send a sage intelligence report via email. Has anyone encountered this issue and been able to resolve?
Thanks
What is the sql statement needed to get the last full month for a pass-through variable.
Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month.
As always thanks in advance for your assistance…
Greetings SI & SQL Gurus! I built customer SI containers for tables containing UDFs as part of a larger project. Some of those UDFs are date fields, which are typically null. This doesn't present a challenge for Sage, SQL, or the custom Crystal Reports…
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!
Hello,
I'm using an SQL version of Sage, and use Sage 100 Premium. I'm having an issue with a report in Sage Intelligence.
I have a copy of the Sales, Customer Sales report that I had copied into another folder. When I try to click on it, it immediately…
On Sage 100 Advanced 2021 sp5.
I created a container with only the AR_InvoiceHistoryHeader file.
added 4 fields. set the filters to a single date and only Source Journal "SO"
the invoices are all duplicated. I tried the same thing on a different…
I have a client using Sage 100 in a cloud platform (SWK). When I login under the client's name into SAGE (but my name on the network), I can see a report in Report Viewer. When the client logs in under their name in the network and into Sage, they do…
Anyone have any information on how to convert F9 v5 (previously called FRx) reports to Sage Intelligence? I have a client who is faced with upgrading to F9 v6 and I would like to get them over to Sage Intelligence instead.
The only information I can…
I need to export invoices that are from yesterday's date and the related Sales Order begins with a J.
I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL.
I'm able to get the below SQL…
Good morning.
A few years back when upgrading a client from Sage 100 Advanced to Premium I needed to obtain a special Sage Intelligence installation file to install a version of Report Manager that was made for connecting to SQL rather than the ProvideX…
Hello,
I'm looking to create an Income Statement by a specific date range.
There was a previous post of an individual stating they wanted to do the same thing and the response was that it could be done, but that you had to have 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?
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…
I'm hitting a wall. My client wants a column in Sage Intelligence to pull only total of net activity for a specific day instead of a period. It has to do with accruals. They don't want to enter accrual journal entries. They want to keep the expenses dated…
I have an usual situation where I'm trying to setup Sage Intelligence on a new workstation and I have all the proper permissions set on the BI folders, the program data folder and the registry for the excel add in. There's multiple reports that use the…
I am upgrading a client from Sage 100 2018 Premium with a complex Sage Intelligence install to Sage 100 2021 Premium with no change in Sage Intelligence's version. According to the documentation and a support call, I need to do a clean install of the…
Would anyone be able to explain what the Request Server (WEB) License is and why it has a count in there in license manager for some installs and not others? Thanks.
