Sage 300

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.

Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…

How can I filter AP vendor transaction report to get actual result with GL transaction report.

I have several custom reports (crystal reports). Now I want these reports to be also accessible via web screen. Which directory should I put my reports?

What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.

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…

When using Sage 300 webscreens, is there a way to run Intelligence reporting with installing Sage 300 desktop version.

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…

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…

Is there a way to link the year in the parameters sheet to the year selected when the report is initially generated? Thanks.

I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.

I am consolidating 3 companies company 1 current year is 2019 company 2 current year is 2019 company 3 current year is 2020 (does have different fiscal year end - am not consolidating on a single worksheet) When I run the statements i only see…

My client runs Sage 300 Advanced version 2018. They are on ALF Model. The ALF Licenses came together with Connector 6.4A and Designer 6.4A activations and I have already activated them. For the client to start using the module what do I need to procure…

Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:

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…

I'm having an issue when running the missing accounts tool. On one report I've built, the tool will only show missing balance sheet accounts even though I know for certain there are missing income statement accounts. I even went so far as to build one…

Hi, I'm using Sage 300 2018 PU 2, when running Sage Intelligence Cloud got this error You Are Not Authorized to view this page. I have given admin and a user with Financial Report and WEB Api access through the sage desktop. But still having this error…

In Intelligence Reporting module, whenever I try to open any app (ex. Report Viewer, Report Manager, etc) I always get an error message that says "ActiveX component can't create object" and it just doesn't work. It used to work with Sage 300 version 6…

Hi All, We have the designer license in place (shows YES in the license manager) yet standard reports fail to generate data and appears as "Designer License Required" instead. Sage 300 2018 PU1 Screenshots attached. Any issue with our licenses?

What is the default password for Sage 300 Intelligence Reporting Security?

Hello everyone! And thanks in advance for your help. :-) We are using Sage 300 2012 with PU5 and we have a security right issue in Sage Intelligence Viewer functionality. We have a user that should have access to only one report as a Viewer, but he can…

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…

Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.