Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 300 Newsletter – March 2016 » FAQ: Moving from Sage 300 Financial Reporter to Sage Intelligence

Sage 300 Newsletter – March 2016

Keeping You Up-To-Date With Information About Sage 300

FAQ: Moving from Sage 300 Financial Reporter to Sage Intelligence

By: Anna Chan, Senior Business Analyst

Thank you to all of you who joined our “Tips on Moving from Sage 300 Financial Reporter to Sage Intelligence” Live Webinar! We had one of Net at Work’s largest Webinar sessions. We had some great questions from the webinar that we didn’t have enough time for, and we thought this would be a good place to help answer some of your questions.

In case you missed it, here is the link for the recording: On-Demand Recording & Slide Deck: Tips on Moving from Sage 300 Financial Reporter to Sage Intelligence

Formatting and Design:

Q: Can you suppress zero lines?
A: Yes. Sage Intelligence provides a macro that allows zero lines to be suppressed. This can be set before the report is run, or afterwards. (If you intend to make updates to your report and save the template you will want to run the report without suppressing zero lines – or they will become permanently suppressed)

Q: How can we set up quarterly reporting and year to date columns on one sheet for four quarters?
A: This is fairly easy to do. We can set up four columns with the formula in each column to return the actuals for three periods. By doing so, each column will report a different quarter. For the Year to Date column, we can use the Year to Date formula, or sum the four columns using Excel’s native sum formula.

Q: Can Sage Intelligence use GL Account Groups in the design?
A: Yes, definitely. We recommend using GL Account Groups in the design to make the maintenance of the reports easier. Instead of referencing a GL Account, we can simply refer to a GL Account Group in the formula.

Q: Can we design financials by using a range of accounts instead of specifying just one account per line?
A: Yes, definitely. This is the way we recommend financials be designed as well. This can be done using Account Groups, as mentioned above, or specifying a range of accounts. To specify a range of accounts, you can use this syntax: “4000 TO 4999”. To define multiple ranges: “5000 TO 5051 + 5500 TO 5600”

sage300-qa-01

Q: How can we create a Reporting Tree?
A: In the Sage Intelligence Designer Task Pane, select the “Tree” option. Click on “Manage” and then “Add” and you can define the Reporting Tree in this following screen. (You can use question marks and asterisks as wildcard characters)

sage300-qa-02

Q: Can you query multiple segments in different columns?
A: Yes, we can. We can use an Excel cell reference in the formula where the segment labeled. The formula in each column would reference the cell that contains the segment value we’d like to report on. Using the Reporting Tree is another option to define group multiple segment values together.

Q: Can we consolidate by the second segment? For example, consolidate all accounts with “-01” and “-02” values in the second segment together?
A: Yes, we can reference both segment values in the financial formula to add the amounts together. The Reporting Tree can be a great way to do this as well.

Q: Do we need to manually update the report when there are new GL accounts?
A: The best way to design the reports is to use Account Groups or ranges in the definition for the accounts. Also, Sage Intelligence v2016 has two new tools “Missing Accounts” and “Dynamic Account Ranges” that can help you locate missing GL accounts if you’d still like to design your financials with specific GL accounts per line.

Q: When running reports for multiple years, can the reports actually show data for multiple years?
A: Yes, if the year is not specified, it will report the data for all the years.

Q: What does the Reporting Tree look like using the Report Viewer?
A: The Reporting Tree looks like the same when using the Report Manager or the Report Viewer. Here’s what it looks like.

sage300-qa-03

Q: What if you have multiple account numbers (15+) that make up one line on a financial statement?
A: The best way to manage your financials would be to make use of the Sage 300 Account Groups. You can assign those accounts to the same Account Group, and refer to the Account Group in the formula. Alternatively, you can list the GL Accounts in the Account Definition. The syntax is: “4000 + 4002 + 4010 + 4015”

Connecting to Data:

Q: Is it possible to run reports with provisional journal entries?
A: Yes, it is. With the Connector License, we can modify and create queries to include provisional journal entries.

Q: Can we report on amounts based on the source ledger?
A: Yes. There is an out of the box report “General Ledger Transactions Details” that you can run and it includes the Source Code and Source Ledger information. Also, using the Connector License, you can create custom queries that include any of the fields in the Sage 300 database to report off of.

Q: Can Sage Intelligence be used for Inventory Management?
A: Yes, certainly. There is an “Inventory Master” report that shows Inventory information. And with the Connector License, we can query any data in Sage 300. In fact, Sage Intelligence can connect to any database (SQL, Oracle, MS Access, etc.) that we can create an ODBC for.

Q: Can Sage Intelligence run the same type of reports as Stonefield Query?
A: Yes, it can return the same results that are being return in your Stonefield Query reports. The information will be presented in Excel, though. After the report is generated, all the formatting is done in Excel.

Q: How can we connect to additional databases? For example Technisoft Service Manager?
A: From the Sage Intelligence Connector, we can create a container to connect to any SQL Database.

Technical Setup and Licensing:

Q: If Sage is installed on a server, can the one license be shared between users?
A: Yes. The License Manager allows you to transfer the one license to different users. (Concurrent licensing versus user)

Q: Does Financial Reporter work with Excel 365?
A: No, unfortunately, Financial Reporter is not compatible with Office 365. Which is part of the reason we’re informing our clients to make plans to convert to Sage Intelligence.

Q: When trying to open Sage Intelligence, I get an “Active X” error.
A: Please give us a call. Your workstation simply needs to be setup to use Sage Intelligence.

Q: What Sage Intelligence modules and licenses are available?
A: Below are the different modules in Sage Intelligence. Sage 300 comes with one Report Manager license, the Security Manager, and the License Manager.

  • Report Manager
    The Report Manager provides an interface to create, run and modify reports.
  • Report Viewer
    The Report Viewer provides an interface to run the reports directly.
  • Report Designer
    The Report Designer consists of the Layout Generator which allows you to fast track the building of powerful financial reports with an easy-to-use, drag-and-drop interface.
  • Connector
    The Connector maintains the connectivity between Sage Intelligence Reporting and the data sources.
  • Security Manager
    The Security Manager controls the accessibility of Sage Intelligence Reporting reports by the various users.
  • License Manager
    The License Manager maintains the licenses installed for Sage Intelligence Reporting.
  • Analysis Module
    Perform multidimensional analysis of large volumes of data via OLAP

Training & Materials:

Q: Can we get all the steps for converting to Sage Intelligence?
A: Sage has provided a user guide. Here is a link for the download. And you can watch the webinar again if you’d like to follow the video on how to convert. If you have any questions, please don’t hesitate to contact us.

Q: Is there an example for converting a Project Job Costing Financial Statement?
A: The conversion would be the same if you are using the Financial Reporter.

Q: Is there a manual that comes with Sage Intelligence that we can review?
A: Yes, there is an active Sage Intelligence user community website. From this link, you can download any of the documentation that comes with Sage intelligence:
http://www.sageintelligencecommunity.com/group/sage300erpintelligence

Hope you found the Questions and Answers helpful. If you have any other questions, please let us know. We’d be glad to assist!

« Return to Newsletter

In This Issue
  • From the Desk of the Sage 300 Practice Director
  • Sage 300 in the Cloud – Are you Ready to Make the Move?
  • Key Improvements Using a Warehouse Management System (WMS)
  • Sage 300 Integration via APIs
  • FAQ: Moving from Sage 300 Financial Reporter to Sage Intelligence
  • Sage 300 Tip 1 : Sage 300 AR Collections Simplified!
  • Sage 300 Tip 2 : Sage 300 Accounts Payable Control Payments
  • Sage 300 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Sage 300 Webinar Series

    Tips for Sage Users to Improve Data-Driven Decision-Making
    March 28 | 2pm ET
    Register Here

    Recruiting & Quiet Hiring: What Quiet Quitting / Hiring Means for 2023 & How Technology Can Help
    March 28 | 2pm ET
    Register Here

    Sage-Integrated Document Management: From Chaos to Control
    April 7 | 2pm ET
    Register Here

    Sage Intacct Overview Demo
    April 7 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Sage Cloud Hosting: Moving On-Premise Sage 300 to the Cloud

    Building a Next Generation Finance Organization with Next Gen ERP Tools

    Reducing Manual Tasks in Your Sage Accounting & Shipping Processes

    Bridge Your Sage 300 Gaps

    Sage 300 Webinar Archive

    View our library of on-demand recorded webinars.

    Newsletter Archive

    Read our previous Sage 300 Newsletters here

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin