Sage 300

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…

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…

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

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…

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…

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…

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.

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