Sage 300

Hi, We need to create reports that include dollars and quantity produced. How can we accomplish this? Ty.

Hi All We are in need of an aged inventory report for Sage Intelligence. Did anybody write something like this?

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…

Trying to return the corresponding itemno for a given icitem.altset #. Normally, I'd just write a SQL statement such as: select [icitem].[itemno] from [icitem] where [icitem].[altset] but, alset is an integer, and I can't find a column in icitem…

Hello, I have 2 report in BI that I have scheduled to run in Task Scheduler. This is Sage 300 2021 PU1 with Office 365 Excel installed on the server. If I open Excel and run the BI report from BI, it runs fine and generates my output files properly…

Hello, I have a client with over 160 customized Sage Intelligence reports. They know that some of these reports have not been used by their 200+ users in a long time. Their IT staff is looking to streamline which reports will need testing as they move…

Is there a way to default the Intellligence parameters @month@ to default to two digits, i.e, 01, instead of a single digit? We do not receive history unless we manually change the default period "1" to "01".

Hi All I am new user of Sage 300.Intelligence Reports I face a problem of out of memory when i execute reports even it contain minor data more than 100,000 unique record, i am using excel 7 , Microsoft windows server 2003 R2 (Service pack 2) Regards…

I am looking to create some buckets of dates in Sage intelligence. I am very new to Sage Intelligence, so please help me understand. I started by creating a view in SQL (I was planning on creating a view for each bucket and then combining the views…

Good morning, I think this is the correct forum, but please advise me if not: Looking at the data dictionary for table ARIBD (that is, the "Invoice Details" table which lives in the ( AR ) module) - every row represents an "invoice line item". Now…

Hi Everyone !! When I try to download a report from Sage Intelligence Centre and when it comes to Naming Ranges, I receive the below error message: Can someone please advise for a permanent solution to fix this problem.Thanks beforehand. Can someone…

I am using SubTotals in a large financial report using Dynamic Ranges, when I refresh the report I receive Circular reference errors. Note I manually fix the reference errors but they keep coming back when Refreshing the worksheet. Any ideas?

Good Day, I have created a new report in Sage Intelligence. Client is Running Sage 300 2018. I am trying to exclude data before a certain date but the date only gets set on the run of report. I have tried to add in a filter and a parameter…

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.

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?

Have a report built container in Sage 2016 Connector. The test runs fine, but when I attempt to run in Report Manager I get a syntax error near ',' (that's a comma). here's the error text Description : [Microsoft][ODBC SQL Server Driver][SQL Server…

how to resolve? how to delete user in sage accpac intelligence?

Our Sage 300ERP 2019 is generating a error. Excel crashes with the following error. The Error showing the Server Log was. Faulting application name: EXCEL.EXE, version: 16.0.5017.1000, time stamp: 0x5ebb1f39 Faulting module name: ntdll.dll, version…

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?

I have a multi page BI financial where i have defined the print area. When I publish the report to excel it publishes everything on that worksheet and not just the defined print area. Is there any work around for this? I would use PDF but the problem…

When you choose to publish a BI reporting to PDF the option to "distribute each worksheet as a seperate document" is forced selected. Is there any solutions out there to allow a single pdf of multiple worksheets?

When we generate a balance sheet using the Balance Sheet template in the layout generator, all of the period numbers are correct EXCEPT period 6. Period 6 is set at 1 for both the actuals and budget columns. I can't see any way to change that in the layout…

I am developing a new Sage Intelligence Report for a client and I had to create a new container. I know how to export and import the report. How do I transfer the required container? TIA

Hi, Does anyone dealt with IFRS 17 with Sage 300 or has come across any resources? IFRS 17 is the new standard for Insurance companies. Marios