Browse By Tags

  • report designer license required sage intelligence please help me.

    I've tried all of google about this error on excel about report designer license required sage Intelligence. Anyone please help me. Sage 300 2022 Premium with Connector, designer, viewer and manager license. Microsoft excel 64 bit 365 office version…

  • Sage Intelligence: Financial Report only prints for Current Year else it give #NAME Error for previous Years

    Dear Team, I am trying to print Financial Report and it only gives values for current year rest for previous year #NAME Error comes on the excel as result. your expertise are required. Thanking you, Murtaza Modi

  • GL Transaction Report

    I cannot get to the Sage Intelligence Reporting. When I click on Report Viewer, it asks for a network repository, and I select a folder but it just keeps asking for the network repository path. My question is 1) How do I get passed this, or 2) Is there…

  • compatible BI tool for Sage CRM

    Besides the build in report writer in CRM, what other report writer would you recommend to build analytical reports? For example, can I use Crystal Report, SSRS, Sage Business Intelligence? If can, how could I run the reports inside the CRM application…

  • Pop up Screen And Filling Data ?????

    When press new->Task the task screen shown when i press new company in the picture a popup screen appear and i fill the data for a company or person the when save the information and click continue the company and person filled and the popup screen…

  • Sage Intelligence with Excel 2019

    Sage Intelligence has been tested at high level and found that it works with Excel 2019. However, issues may arise from consistent Microsoft updates. In those cases we will determine cause and method for resolving. In one example, a Microsoft update…

  • Business Intelligence - Restricting Access

    To be able to restrict access to which cubes BI users are able to report on. Currently users have to given full access to all BI reporting data, even if available reports are restricted they are still able to create new reports on any data cube.

  • BI Tools in Excel Keeps Disappearing

    I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…

  • Power BI and Sage Intelligence and looking to hire an expert

    Hi All, Our company has Sage 100 2015 and we are just now starting to use Sage Intelligence. I am pretty used to report writers so learning to write reports in SI is fairly easy. However, my difficulties have to do with the set up of Power BI…

  • Sage 100 ERP 2017 Advanced Business Intelligence Explorer

    We are currently using Microsoft Access to collect AR Invoice History detail data. We have data from 1999 & use Access to lookup prior invoice line information detail, which displays service performed. We search by a UDF_ServiceLocation field. If possible…

  • Sage Intelligence and Microsoft Excel Tips and Tricks

    Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…
  • Ignite your Excel skills to save time and increase your productivity

    Ignite your Excel skills to save time and increase your productivity

    Microsoft® Excel® has become one of the most widely used software applications of all time, in both small and mid-sized businesses—as well as in much larger corporations. Whether you like it or not, Excel is everywhere you look in the business world.…
  • 3 Reasons why your business should invest in a Business Intelligence solution

    3 Reasons why your business should invest in a Business Intelligence solution

    A good Business Intelligence solution will give your company a competitive advantage, and there are many compelling reasons why all business owners should make it a priority to invest in one. Here are the top three: Reason 1: Automate reporting processes…

  • Use a calculated report as base for multiple reports with additional filters

    I have a customer that updates up to 2500 invoices in a day. I have created a report that pulls all the necessary header and line detail information to produce several pivot reports. Is there a way to now use this report (so it does not have to be…

  • Making Sense of Business Intelligence in the Mid-Market

    Companies of all sizes turn to Business Intelligence (BI) tools to help make sense of the information overload. Do you know what #BusinessIntelligence solution is best for your company? Here’s what you should judge a BI solution on: http://ow.ly/xwSU…

  • Previous Month - Rolling, to be used for automated report delivery

    Currently using Sage 100 2013 and Sage Intelligence 5.0. We have a need to pull previous month transactions from AR_InvoiceHistoryHeader. Would like to filter this data based on the ShipDate. We would also like these report so be distributed automatically…

  • Sage Intelligence Link Formula between Excel worksheets

    Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report? The purpose is to is to simplify update of accounts Say sheet1 we have a good report. In sheet2 column A, we want to link to accounts in sheet1. If…

  • Still looking for an FRx replacement? Register for session BUS-563 at Sage Summit

    FRx reports can be efficiently converted to Sage 100 ERP Intelligence Reporting using the powerful functionality of the Sage Intelligence Report Designer. Sage Intelligence Product Specialist, Sandra Smith, will show you how to simply export existing…

  • Server Upgrade for MAS90 and MAS Intelligence

    We plan to upgrade the server for MAS90 before year end and move to the latest version of SAGE, would the MAS Intelligence reports carry over, or is there a new reporting package? The IT department has informed me that FRx will not be available on the…

  • Excel Output has #NAME? errors

    I can run Sage Intelligence reports under my Windows profile and they work fine. Other users get the #NAME? for all formulas in the output of Excel. Other users have the same permissions that I do. Would anyone have any ideas on what would cause this…

  • RE: Noob question on reporting options (formerly on FRx)

    There are some options for migrating some canned reports and some of the trees as I recall, but if they are really customized FRx reports then there's a lot of cleanup work that has to be done. They might have to evaluate each report on a case-by-case…

  • Noob question on reporting options (formerly on FRx)

    Since the update to Sage 100 2013, staff are asking for FRx migrated reports. How and if that's possible remain a mystery to me. I've installed and licensed our 1 user Intelligence reporting and referred them to learning the product. Is there anything…

  • Getting the Most from Sage Intelligence Reporting

    "When creating Executive Dashboards for financial reporting, how can I get the information I need from Sage Intelligence Reporting or BI queries" was a hot topic from the Sage City Live networking event at Sage Summit 2013. How are you using Sage Intelligence…

*Community Hub is the new name for Sage City