Sage 300

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…

We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…

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…

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

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…

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…

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…

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 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

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:

Please Help. We get the above-mentioned error on one workstation trying to print reports The other strange thing is that there are 3 companies and we only get this error on two of them, the third works fine. All other workstations are printing…

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…

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…

When running the inventory on-hand intelligence report I see that one item at one location is showing a quantity onhand as twice as much as it should be. The costs are also showing up at twice the correct amount. Any idea of what is happening. We look…

Hi all, Good day. My company's financial calendar starts from 1 Jul and end on 30 Jun. We have set his up in the FISCAL CALENDAR under COMMON SERVICES. We are creating a report that would use GL data, as well as Sales History from OE. At the…

Hi all, I have a question on the ExtendFormulaeToUsedRows. After I added this Add-in function, it always prompt an error message stating ....[Select method of Worksheet class failed]........ The worksheet is the first worksheet named Sheet1 which…

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.

I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?