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.
Hi all,
I know this is a very specific question but I am using Sage 300 Intelligence and I have consolidated 3 entities into one report (all 3 listed under Database Consolidation List). Within this report I have built financial statements for all 3…
I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300.
/resized-image/__size/640x480/__key/communityserver-discussions-components…
Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output:
1. Opening balance on account at every point in time the report is printed ie yearly or monthly,
2. outstanding invoices unpaid…
I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…
This is a known issue with task scheduler and is being investigated by Sage Intelligence development.
As a workaround, use a batch file to launch report and add in a task kill statement to clean process.
For example.
TASKKILL /F /FI "USERNAME eq…
On Sage 300 version 2022 product 3, Business Intelligence on web screen (Windows 10 last update server) , we cannot access business intelligence web screen as picture below. Please help us.
As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget?
Objectives are like optional fields:
Eg: Acccount 1010 : Allowances
Objective 1: budget $100k
Objective 2: budget $200k
Hi everyone,
I have two Excel versions installed on my computer (Excel 2010 and Excel 365) because I need both for work. When I only had Excel 2010, SI works fine. And then I had Excel 365 installed, SI switched to using Excel 365. This morning, SI…
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.
we recently migrated to Sage 300 2020 (PU1) and facing this error.
the reports work fine previously. but after migration, for login ADMIN - okay, but failed for other users.
these reports work in the old version. any help?
I have created a new container and report, but when I attempt to add a start date >= parameter, it will not show the calendar. The user has to enter the exact date.
Any ideas?
Hi,
When I run the sage intelligence report I have this error.
Sometimes the error is "Method '~' of object '~' failed" and sometimes is "Sheet number 12 does not exist in the workbook".
I can run the report using the user that installed the sage…
I have a client wanting to use the free BI reports provided by Sage called the
Customer Aged Trial Balance S300-SQL(C4-0-5) or the
Detailed AR Aged Trial Balance S300-SQL(C133-0-4)
Unfortunately, both aging reports cut off by Doc Date and for…
We migrated Sage 300 to a new server and de-commissioned the old server.
We save intelligence reports monthly on our network drives, when opening the files that were created prior to migration, we get the following error message:
An error occurred…
New to Sage Intelligence? Or want to take your reporting to the next level? We have the right Sage Intelligence Reporting course for you.
Sage Intelligence:
Beginner
Sage Intelligence:
Intermediate
Sage Intelligence…
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 Everyone,
Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…
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?
Are you ready to start using Sage Intelligence Reporting to create your own reports? The next Intermediate course is scheduled for May 17. Click here for more information. It is recommended that you view the Beginner Anytime Learning topic first.
At Sage Intelligence, our goal is to make the running of your business easier, so that you have more time to do the things you want to do. One of the ways we do this is by providing you with additional reports that give you actionable business insights…
Hi all.
Just a reminder to peruse and download your free reports through the Sage Intelligence Report Utility. Also take a moment to watch the new video we've added to the page, highlighting the benefits.
https://www.sageintelligence.com/report-utility…
Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?
We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac…
Sage Intelligence gives you a lot of value out-the-box, through the ready-to-use reports provided in the Report Manager and the free reports that you can access via the Report Utility. If these aren’t exactly what you’re looking for then you also have…