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.
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…
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…
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 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…
Error Message:
"The following application were not installed properly. This may indicate that you are using illegally copied software. An entry has been made to the anti piracy log. this situation can also be arise in rare circumstances from failure…