Sage 300 ERP Intelligence Reporting (864)

Discussions Replies Latest Activity

SAGE 300 Intelligence Reporting - Dynamic ranges, with reporting trees. Excel Sum function error

Hi there I have a report for a client that I have created. My approach was to build a template add a "List"(Excel function) in a specific…

Started by Jaco Schoeman

0 Apr 18

Date Parameter for Stored Procedure not showing Date Calendar

Great day everyone, We had a problem where the date parameter is used, but calendar function is not coming out. We found out this issue oc…

Started by Hee Zhi Cheng

0 Apr 18

SAGE 300 BI license activation count issue

Hi We have noticed from SAGE 2018 (6.5) that the license count defaults to 1 when activating Intelligence Manager and Viewer licenses. I h…

Started by Derick

7 Apr 15
Reply by Sandra Smith

Date/Time stamp

Hi, I need to add a date/time stamp to my output file in the following format: YYYYMMDDHHMMSS (without any segment delimeters etc.).  Is t…

Started by Riekie Roux

1 Apr 15
Reply by Dino Sak

Is it possible to get a Non-Sage database to appear in the consolidation list?

I have a client who would like to add a non-Sage 300 database into a report that is also pulling data from a Sage 300 database.  They have…

Started by Tony Yip

2 Apr 14
Reply by Marius Yung

Database is showing up twice in the excel report

Anybody run across this before - I have six databases in a consolidated report.  For some reason, one of them is showing up twice.  I have…

Started by Howard Whiting

4 Apr 14
Reply by Mariano Catalano

Sage 300 Intelligence 22 Company Consolidate TB with Dynamic Account Ranges SLOW

I created a new consolidated trial balance report for a Sage 300 customer recently that includes 22 companies in the consolidation. The Dyn…

Started by Elena Bello

2 Apr 14
Reply by Mariano Catalano

Union report with different underlying Databases

Hi all, I'm trying to create a union report that holds Sales volume data on Sheet1 and GL Fiscal set data on Sheet2. Sales Volume data has…

Started by faiyung

4 Apr 14
Reply by Mariano Catalano

Running Union Consolidation reports with different companies in Sub-Reports

Hi Everyone, I have only just noticed that when running union consolidation reports, if you have different companies selected in your sub…

Started by Ian Barbour

6 Apr 14
Reply by Mariano Catalano

totaling by 1st segment in account using dynamic range

Is there any way to use dynamic account range feature to get a total by segment 1 of an account number?  Comparing to FR statement designe…

Started by Andy Bruner

14 Apr 14
Reply by Mariano Catalano

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service