Alchemex Report Writing (274)

Discussions Replies Latest Activity

License Manager Automatically Clears

Hi Has anyone had an issue, where the license manager automatically clears itself ? So you have to go back in and manually allocate licens…

Started by Lavinia Govender

1 Feb 12
Reply by Keeveshin Naidoo

Running automated reports through windows scheduler

Good day all, I have an issue with scheduling automated reports through windows scheduler? The reports work fine when they are user initiat…

Started by Terence Graaff

1 Nov 1, 2017
Reply by NATE

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, 2017
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, 2017
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, 2017
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, 2017
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, 2017
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, 2017
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, 2017
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


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service