What is the best report to give a list of items sold, say for the last 12 months, from 1 particular vendor? 


  • Sage 100C Report Writer - Can an HTML Hyperlink be placed in a Report Form?

    I'd like to include an active hyperlink in a custom report form using Sage report writer. Is there any way that the report writer can recognize a hyperlink or HTML?

  • revision of the GL detail report


    One of the options when running a detailed GL report is to select the PRINT POSTED BY DATE field. This will add two columns to the report that includes the Source Journal and the Posted Date. My question is can I create a report, either by crystal…

  • Data in Sage but not showing in BI or SQL


    I was running a view in both BI and SQL for all customers who are tax exempt for company CEN.. when I run both views in BI and SQL I find that there is no data showing up in the TaxExemptno columns  however when I check some of the customers in…

  • P&L by Specific Date Range in Sage Intelligence


    I'm looking to create an Income Statement by a specific date range.

    There was a previous post of an individual stating they wanted to do the same thing and the response was that it could be done, but that you had to have Report Designer.


  • convert single company GL reports to consolidated company reports

    Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports?

    Or, is there a way to set the company code and add the 8 companies as sub-reports?

  • Sage Intelligence Excel Protected mode

    In upgrading office from 2010 to Office 365 reports generated in Sage Intelligence I can only see the data when the document is opened in protected mode. If the document is opened not in protected mode I get a NAME reference error on all the formulas…

  • Calculate aging over time

    Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously. 

    I want to be able to show a sales person, for…

  • Breaking Links within Excel Intel Report

    Normally I'm able to hit alt-E-K to eliminate all of the external links and replace with values within a spreadsheet, but no such luck with an Intel report.  What steps am I missing?


  • Drill down option missing for RV license users

    I have 2 report viewers who in excel don't have the option to drill down when right clicking on a cell. The report manager user however can drill down on the same report. I was told report viewers can drill down. Is there an excel setting that I need…

  • Sage Intelligence Reporting - Income Statement -

    I'm new to Intelligence reporting. Is there a way to change the presentation order of accounts on the income statement without changing the account numbers?



  • Crystal Reports / sub reports / Alias Items

    I need some help with a form and sub report that we are using to obtain the alias part descriptions for some of our forms.

    My issue is that I wish to ignore all the C type (customer type) alias data and only use the G type (general) details. 

    The sub report…

  • Business Insight Crystal

    Hello working with Sage 100 2019 learning the Business Insight module and discovered I dont have a Reporter folder under Business Insights. When re-running the workstation setup there is no option to install Crystal either, and I find no install files…

  • Cannot save Excel template

    Receive "No workbooks Open to Link" when trying to save  an Excel Template

  • Can I Use An Excel Intelligence Formula For Job Level Reporting?

    I currently use @GLActual and @GLBudget formulas to pull financial data by GL accounts. Is there a way to add another layer and pull this same type of info for specific job numbers (customers)? Right now it looks like the 3 dimensions the formulas use…

  • Multi-year (beyond Actual and Prior) comparative financial statements

    Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence? 

    Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on one…

  • Hide Zero Rows - ZeroingII

    Hi there,

    I am using the ZeroingII Add-In Function to hide zero rows and it works like a charm on one worksheet. However, most of my reports have multiple sheets in the same file. How can I replicate this add-in on all the worksheets? I have tried lots…

  • Duplicate Company Code in Consolidated Report

    I have a client that moved their Sage to Azure. The Subreports in the consolidated report has one of the companies duplicated. Has anyone seen this? Know how to fix?


  • Modules available to Sage Intelligence

    Is Sage intelligence able to access the PR module?

    All modules? or only specific modules as in the sample reports?

  • Report Writer - Searching for Consultant


    I run a fire protection company. We started a year ago and have grown to be 55 people and ~$7m of revenue. We use Sage 100. We're starting to need to get into analytics. We have an install and service part to our business and multiple services lines…

  • Create custom report


    First day to Sage 100/Crystal Reporting and have been tasked to find out if there is a way to add a column onto one existing report and that column of information is from a different report. They are in separate modules. Seems it should be an easy…

  • Is The Report Designer Connection To Sage Live?

    I'm curious to know if the data coming through the add-in are a live connection to Sage, or just the data that was available when first created the report from the Report Manager in Sage Business Intelligence.

    I have a balance sheet report that I…

  • One Report Two File Outputs needed

    Does anyone know if in Report Manager you can create 2 types of output files (xls & pdf) run with windows scheduler from one report or do you have to create a copy of the report to be able to do a second report output and schedule it after the 1st one…

  • Save Template: Deletes the Template after running report.

    Sage v2018 o 2019.

    Customer (user specific) will run out a Report Designer Financial Report, makes a small change and tries to perform Save Template.  The process starts and then Excel asks if she wants to save changes to:  reportname1.xlsx.   Regardless…


    Is there somewhere to look and find gross profit dollars on a specific invoice?