x Want to participate? Join the group to interact

  • Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…

  • What connectors (Data Tables) are used in Report Manager?

    How do I tell what connector (data tables) are used on a given report?

  • Sage 100 2019 Sage Intelligence. Company name or code for multi-company reports.

    Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name…

  • What tables to use to bring in fiscal year/period into GL reporting?

    I am creating a GL Detail report (GL_DETAILPOSTING) and need to have the fiscal year and fiscal period columns added to the report. What table do I use to join?

  • Sage Intelligence Connector - Adding a duplicate or alias table

    Sage 2019 I created a Data Container. I added a table and would like to add an alias of the same table with a left join. When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…

  • sql server new connection

    How do I add a new connection to a sql server in the same network as Sage 100 cloud?

  • Can you combine data from multiple companies using formulas like GLActual?

    Is there a way to combine data from multiple companies using formulas like GLActual ? Currently, I have 4 companies, and I have the individual account data being sorted on a second excel page to combine their data in Total column. I've tried using a formula…

  • UNION Query SAGE 100 (MAS90)

    Does the Connector support UNION Queries for Sage 100 Data? Have a simple UNION that just doesn't seem to work. See sample below: Select JT_Transaction.SalesOrderNo as 'SalesOrderNo' , JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost…

  • New Sally Series

    In a couple of days, we'll be releasing our next installment of the Sally Series, this time focusing on the Connector module and how to define your own data sets for your reports. If you haven't yet checked out the first and second series then why not…

  • report from excel container, only runs if workbook open

    Running Sage 2017 SP1, with Excel Container I have created an excel link for a large report that I'm going to pull several small reports from for distribution. This runs perfectly if the linked excel report is open but not if it's closed. I will…

  • Is anybody interested in Sage e-Business Web Services or SData website connector?

    Hello everyone! 2 years ago my company built a very powerful implementation of e-commerce store that integrated with Sage 100 ERP via both Sage e-Business Web Services and SData. As I said after that 2 years gone. Now I am interested are those technologies…

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

  • question about which modules I need for financial reporting

    We currently have MAS200 4.4 and are upgrading to Sage 100 2014/15. We are retiring FRx. I am setting up a test environment for Sage 100 and it's almost all set up. My question is with reporting. The new software comes with a license for Sage Intelligence…

*Community Hub is the new name for Sage City