Welcome to the Sage 300 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.
Sage 300 with RDP session to server.
User cannot add report object.
Select Object > New or R-Click > New, and it stops there. All option including Report are greyed out. No problem with ADMIN or other users.
Hi there,
I would like to create a Revenue and Expense statement for budget purpose, that shows current year YTD, Last year Annual Auctual, and the year before Annual Actual, what is the FR function I need to use?
I also would like to create a…
Hello Everyone.
How do I print the totals for a range of accounts for the whole year using FRPOST function?.(I'm using FRPOST because of the Transnational Optional fields). The current formula ' =FRPOST("TRANSAMT","2400:2400ZMA","(T.ACTIVITIES LIKE…
- report launches from Sage web client and functions fine with paramater set to a certain department
- Add a runtime paramater for department report works fine from classic client
- report will not run from Web client
Unexpected Error:
A problem…
Hi
We are using Sage 2017 version,
Please advise how to change the report format. All report comes with the name who left our company.
Our sage cannot be opened via web browser (becouse of no cloud version?) and ther are no "setting" botton on my…
Sage 2023 has not been officially released in Australia yet so I have not checked in the install iteself.
In relation to this thread https://www.sagecity.com/us/sage300_erp/f/sage-300-announcements/190585/important-information-regarding-sage-intelligence…
while trying to run sage intelligence report under report manager, hit the following error.
error occurred trying to refresh excel's links to its installed addins. the error was [unable to set the installed property of the addin class}. the report will…
Hi,
Using Sage 2022 on Windows 2019 server.
I am facing a problem with running PJC canned reports in Intelligence reporting. This is with the dates in the filter screen that comes up as soon as I run the report. Please note that I am using European…
I am having issues with opening multiple Intelligence Reporting reports from the same company database. If I only have one open everything is fine and works well but if I open a second one (from the same company database) all of the formulas from the…
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…
Hi, we need to send financial statements in Excel to a third party. How can we create a separate Excel sheet with the data and formatting produced by Intelligence? Ty.
I am having difficulty after upgrading SAGE 300C to 2022 version running any Designer reports, as the Toolkit add-in is no longer appearing in Excel. The client is using Office 365.
I tried the same directly on the server with Office 2019 and the BI…
I've tried all of google about this error on excel about report designer license required sage Intelligence.
Anyone please help me.
Sage 300 2022 Premium with Connector, designer, viewer and manager license.
Microsoft excel 64 bit 365 office version…
Where do I specify the different companies to run the report in.
I created a container and the report and it is currently "auto connecting" meaning the report runs in the company in which you are.
I want the report to run the information on sheet…
Hi Sage 300 Community,
How do I export or get a list of data table names so that I can build out specifics in Intelligence Report? Is it simply going through our database server and doing a generic query?
If so, is there a quick query that anyone…
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 am getting this error message when I clicked Quick Edit or Quick Generate:
Initiialization of System Windows Data ObjectDataProvider threw an exception.
I have attached a pdf of the error.
Intelligence Reporting error message.pdf
Hello everyone,
I need to report Period 13 and the adjustment period (Period 14) on a financial report in Sage Business Intelligence from Sage 300 GL.
Is that possible?
Any Advice would be greatly appreciated
Dana
Hi
I have a client using Sage 2021 and I made a copy of the Dashboard report. When I run it there are #value errors and user licence required errors. Does anyone have any ideas.
Side note they dont have the Report Vliewer Licence installed or…