Alchemex Report Writing (272)

Discussions Replies Latest Activity

Report not picking up negative invoices

I am running two reports off of BIC, that were created by someone who does report writing. Both reports, each, consolidate 2 companies sale…

Started by Rudene

1 Aug 14
Reply by Rudene

System Variables - Giving Error 7481 - Inconsistent Types

I'm getting an error in my connector when I try to use the '@MONTHSTART' system variable: I have the following SQL statement (Which works…

Started by modhorat

7 Jun 15
Reply by Peter Scully

Financial Report Designer

Hi everyone I am using Sage Pastel Partner V14 and also the sage BIC module.  I have recently designed a new report using the financial re…

Started by Camy

4 Jun 5
Reply by Camy

Default Null to Zero

Greetings Anyone know of a setting, or way to default all Null values to zero? I have some long and complicated SQL Expressions, and I woul…

Started by Anthony Whitehouse

1 Apr 11
Reply by Tesh

Using Report Designer for specific X3 folder

Hi all, Doing some reporting for a company on Sage X3. How do I specify in the Report Designer to use a specific Folder for the database? W…

Started by Awie van den Berg

1 Mar 23
Reply by Tesh

OLAP platforms and Alchemex???

What platform does Alchemex use for OLAP 1. SQL or 2. Pivot tables in Excel? or 3. Other? 4. ODBC

Started by Ruth Gray

7 Mar 8
Reply by Leroy Gordon

SQL statement

Hi:  I am trying to get past an error where Intelligence isn't able to format a date field, because in some cases the field is zero.  I am…

Started by Dane Hoover

2 Jan 5
Reply by Dane Hoover

Availability to other users

Hi   I've just started using BIC and I'm sure I'm forgetting something really basic but haven't the time to keep trying to figure it out. I…

Started by Wendy Carr

3 Sep 1, 2016
Reply by Willie Oosthuizen

Extracting data from an Excel file

Hi everybody, I have only worked with SQL databases to generate BI reports. Is it possible to extract data from an Excel file to generate…

Started by Prabha VIRAH SAMMY

3 Jul 7, 2016
Reply by Prabha VIRAH SAMMY

unique list of customers

I am looking for a way to produce a list of customers that has unique customer IDs and names. All I get is list with same customer name or…

Started by Ernesto Quinonez

3 May 16, 2016
Reply by Carmen Griessel


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service