• SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
  • Webcast: Customize reports with Sage 300 Intelligence Reporting Cloud

    Isn't simpler sometimes better? Sage 300 Intelligence Reporting Cloud's Online Report Designer thinks so. It can save you time and effort by customizing a report to only show the specific accounts - like expense accounts - that you want to review. Cut…
  • Viewer security not working

    Hello everyone! And thanks in advance for your help. :-) We are using Sage 300 2012 with PU5 and we have a security right issue in Sage Intelligence Viewer functionality. We have a user that should have access to only one report as a Viewer, but he can…
  • Free five-part video series on reporting: Gearing Up with Sally

    Learn about report creation and how to visualize your data better with this FREE, five-part video series. In Starting Out with Sally , you discovered how to make sense of the numbers behind your business, as Sally led you through practical ways to improve…
  • Intelligence Reporting

    Hi There, We're on Sage 2014 and we know that Intelligence Reporting is already included but when I open any icon I have a missing file [path\bx62a\bicore.exe cannot be found. Checked the path and the file is there. Any idea?