Sage 300

Hi. Can we import new tables to report manager without connector license?

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…

Has anyone encountered this issue: The financial year has just ended. I created the new year and i closed out the year so that the GL can start posting for the current year. The year is moving from 2019 to 2020. it all changed as usual. I went to…

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…

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.

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. Last year I provided two webcasts on how Microsoft Power BI can be used with Sage Intelligence to provide attractive and interactive visualizations of your data. I also covered some of the other benefits of making use of Power BI like sharing…

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…

I have created a new database container and most of the field in the container are available for filtering, but a couple of them are not. I really need to use one of the fields to filter my report. Why are some field not allow to be used in the parameters…

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?

I have attached a screen shot of my Report Manager UI. I am on Sage 300 2014 PU 3. The panels on the screen are mixed up. Has anyone seen this behaviour? Thanks

I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…

I need to total my Sage Intelligence Report by the state of the ship-to address. What table(s) do I need to link to Sales Master 3-0 data container.

I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report. I can see the revised budget in the Budget Maintenance screen. I have reviewed the…

Log in to Sage's Knowledgebase to download Sage Intelligence Reporting product update 3 for Sage 300 ERP 2014.