Adding my own defined System Variables

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Our company has worldwide branches and would like to cater for the different Month and Year ends.

I am currently using the System Variable @DATE@, but can I add my own variable?

Yes you can, by defining the Variable in the Alchemex.ini file.

Method

To view the existing list of System Variables:

1.From the Report Manager Module, right-click on Home and select Show System Variables,or from the

Administrator Module, right-click on Enterprise and select Show System Variables

Adding my own defined System Variables

2.This will show all currently defined System Variables

Adding my own defined System Variables

3.To define your own System Variable, go to the Alchemex.ini file.

By default this is installed under the Alchemex60 folder on the C drive.

Adding my own defined System Variables

4.Add the following, each variable must be added on a separate line, then save the file:

[GlobalSysVars]

Active=@COUNTRYAFINYEARSTART@,@COUNTRYAFINYEAREND@

@COUNTRYAFINYEARSTART@=01 June 2009

@COUNTRYAFINYEAREND@=31 May 2010

5.The new variable will be added under the System Variables:

Adding my own defined System Variables

Please note that because the System Variables are defined in the Alchemex.ini file, Custom System Variables will vary from site to site.

If they are used on a report intended for distribution then the same definitions need to be created at the destination site.

Ordinary System Variables are available to all Alchemex sites without having to create them.