Browse By Tags

  • Sage Intelligence error 1004 when trying to save template

    When attempting to save the template I get an error message. This is Sage 100 ver 2023 using Office 365 This happens on any financial report I select. I have been running this report and updating regularly for several years. I have re-installed…
  • Sage Intelligence Icon in French

    Hello, Apologies if it's the wrong forum, I'm new to Sage Intelligence as I've taken over and reinstalled on a new computer, but for some reason the icon is no longer showing up. Could it be because I'm using a French OS? We're a small flower delivery…
  • Creating new Designer Reports - Receiving incorrect SQLSyntax near ')'

    Steps to recreate this issue: Select the Designer folder and right-mouse click to Add Report Choose Standard Give it a name Select Container – Report Designer – Accounts S300 SQL 1-1 (Sage Accpac (Auto Connect) ID 11 Click Run And this error…
  • Sage Intelligence Report Designer Consolidation Fiscal to Calendar

    Would it be possible within Report Designer to add a conversion field of Fiscal to Calendar? If 2 UDF's were added to Fiscal Year Maintenance for each period noting the calendar year and period, could they then be used in consolidated financials? …
  • sql drop leading zeros in SO number

    can someone tell me a sql formula to use in a Sales Order container to drop the leading zeros. I need to match / index to files where the sales order number is entered without the leading zeros.
  • Sage Intelligence

    Report Trees are not all showing - is there a fix?
  • Reporting Tree Report

    Is there a way to generate a report of the contents of our reporting trees? The contents seem to be XML like but can't figure out a way to use the data to generate a report of what's included in each tree. Thank you.
  • Recording Statistics

    I'm looking to add statistical information to my reporting and I'm wondering if anyone has found a way to make that work. If there's not a direct way to add these types of accounts does anyone have any ideas for workarounds?
  • BI Generator

    Hi my client is on ver 11.1.1 of sage 200 evolution - and we cant seem to get the BIGenerator addin to show up under addins. its not under inactive or disabled addins either. When trying to manually install it says its not a valid excel addin. They…
  • SIR Reformatting Excel Template At Run Time

    I created the Report in separate sheets with Pivot Table. The cell/columns formatting are complete e.g. alignment, date and number formats, conditional formatting. The Excel Template has been linked to SIR. The Pivot Table is set to Preserve cell formatting…
  • 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…
  • The container has no expressions defined error

    Hi, when adding the container as a report in SIR the system prompt: The container has no expressions defined and therefore cannot be used. Please add expressions to the container in the Connector. Whereas I already created the 3 expressions. I tried…
  • Execute a parameterized MS SQL Stored procedure via SIR Container

    I'm using a parameterized stored procedure named sprptPaymentsTx having 3 parameters (vendor_ID, from_date, to_date) to generate the Payment Transactions Report. Test confirmed it working in MS SQL example exec spr ptPaymentsTx null, '20200101', '20201231…
  • Sage Intelligence Consolidated Job Cost reports

    I feel like the Not Equal join used in Crystal in order to combine the Company file in a report to be able to get the company name/code would not work in SI. Is there a way of adding the company code for NON-FINANCIAL reports?
  • Sage 300 Intelligence

    Hi all, I know this is a very specific question but I am using Sage 300 Intelligence and I have consolidated 3 entities into one report (all 3 listed under Database Consolidation List). Within this report I have built financial statements for all 3…
  • AR Aged Invoice Report

    Hello, I'm just trying to set up auto delivery for this report but it looks like it is only available in the stock Crystal Report form. Does anyone know if it's available in Sage Intelligence or if there is a way to convert Crystal Report reports to Sage…
  • #value on retained earnings

    I am experiencing a #Value error on the Trail Balance & Balance Sheet when running the financial reports. Any help on how to resolve this? I followed the instructions on the Knowledge base article on importing the financial report designer 1-9(SI) but…
  • Sage 300 Intelligence Reporting

    I am moving client from Sage 2020 to Sage 2024 and in doing so the Sage Business Intelligence Reporting has changed and I am looking for find out how to move the templates from BXDATA\SQL folder into new reporting folder. Can anyone let me know the process…
  • How to use sage intelligence reporting with optional fields?

    I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300. /resized-image/__size/640x480/__key/communityserver-discussions-components…
  • Pass through variable "Last full month"

    What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…
  • Sage 300 business intelligence reporting trees

    We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…
  • Sage Intelligence and O365 Cloud

    Does anyone know if Sage is planning on supporting Sage Intelligence with O365 Cloud? I have several clients having issues with not being able to use SI with O365 Cloud and needing to install Excel locally. Thanks!
  • Upgrade Sage Intelligence from 2015 Standard to 2023 SQL

    What are the steps to upgrade Sage Intelligence on Sage 100 standard 2015 to Sage 100 2023 Premium (SQL)?
  • Sage Intelligence Reporting - Need currency conversion rate in Sales Master Report

    I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…
  • Where is the Sage Intelligence workstation setup install registry key?

    There was a scenario that the client didn't uninstall Sage Intelligence workstation setup before their old server was already offline with the new server in place. When the client tried to uninstall Sage Intelligence workstation setup, the program was…