Gareth Holley's Page

Hi All,I need to install and setup Alchemex for X3 that is running on an Oracle database. I have downloaded Alchemex for X3 but as far as I can see, the first connection screen that I need to input data into before accessing the Administrator module is designed for SQL ODBC connections only. Is this correct? Has anyone installed Alchemex for X3 on an Oracle database? If so, please help me out here? Do I need to use the generic Alchemex install rather?RegardsGarethSee More

Hi,I have used Alchemex to create a pivot table from my raw data in sheet1. I have got the format of the pivot table correct as per the requirement but I would like to know how to handle the "Current month" issue within the Pivot. For the "Value" in the pivot, I have pulled in "Sum of actual current period" to get the current months values in the report. However, I do not know how to change the month that I am looking at. The usual "Change month" button on the Excel toolbar is not available.Any…See More

Hi, I am trying to add a SQL expression to a container to give me the account balances of all accounts on a specific day (01/03/2011) as this is the date that opening balances were brought in. I assume that this is the easiest way to get the opening balances into my BS report? I don't have an issue writing the SQL query to return the data but I am not sure how to get the expression to work correctly. SELECT AMTLED_0, ACCNUM_0FROM SERCO.GACCENTRYDWHERE ACCDAT_0 = '2011-03-31 00:00:00.000' Please…See More