Browse By Tags

  • Sage Intelligence Filter and Parameter combination - need help

    Need some eyes on a Sage Intelligence Transaction report filters and parameters. Please see attached file. Adding filters with parameters works for one set but not another. Can someone look to see if you have a suggestion as to why the filter/parameter…
  • Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and transactions for a given period at the G/L level across all entities?

    Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:
  • Consolidated Designer

    I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
  • Limit Account Lookup

    We are working on updating our security per user, and want certain users to only be able to see certain accounts in GL Transactions Reports. Is this possible by user?
  • Sage Intelligence Data Limit Reached in Excel

    I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
  • Drill Down Error - Invalid authorization specification

    I was following the instructions from this website: https://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2013/11/drill-values-view-deeper-level-data/ When trying to run the second drill down on the report, I get an error…
  • Report/Log for Fiscal Calendar maintenance

    Is there a report or log that shows Fiscal Calendar changes? We are in period 10 of 12 for 2016, and somehow period 8 START date was inadvertently changed from 01/06/216 to 06/01/2016. The start date is not even an editable field. No other dates were…
  • BI Reporting Manager Error

    Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…
  • Cashflow Statements

    Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.