Variable Valuation
The standard system includes global variables for fiscal years, half years, quarters, and months. You use variables for defining forms. Variables are parameters of a report for which you define the contents when executing a report and which are replaced in different ways, depending on the values you enter for the variables.
The following example describes how the variable valuation functions for the General Ledger Account Information System.
Example 1: Year comparison for two fiscal years
For this, you use the following variables in the first and second columns of your report:
Column 1 |
Column 2 |
&1FY |
&1FY-1 |
When running the report, you enter
1995 as the fiscal year under Change settings. The variables are then replaced as follows:
Column 1 |
Column 2 |
1995 |
1994 |
Example 2: Half year comparison for two fiscal years
For this, you use the following variables in the first and second columns of your report:
Column 1 |
Column 2 |
&2FY |
&2FY-1 |
&2PF |
&2PF |
&2PT |
&2PT |
When running the report, you enter
1995 as the fiscal year and the second half of 1995 as the period under Change settings. The variables are then replaced as follows:
Column 1 |
Column 2 |
1995 |
1994 |
007 |
007 |
016 |
016 |
Example 3: Quarterly comparison for two fiscal years
For this, you use the following variables in the first and second columns of your report:
Column 1 |
Column 2 |
&3FY |
&3FY-1 |
&3PF |
&3PF |
&3PT |
&3PT |
When running the report, you enter
1995 as the fiscal year and the third quarter of 1995 as the period under Change settings. The variables are then replaced as follows:
Column 1 |
Column 2 |
1995 |
1994 |
007 |
007 |
009 |
009 |
If instead you enter the second quarter of 1995, the following values are inserted for the variables:
Column 1 |
Column 2 |
1995 |
1994 |
004 |
004 |
006 |
006 |
Example 4: Monthly comparison for two fiscal years
For this, you use the following variables in the first and second columns of your report:
Column 1 |
Column 2 |
&4FY |
&4FY-1 |
&4PE |
&4PE |
When running the report, you enter
1995 as the fiscal year and 10/1995 as the month (period) under Change settings. The variables are then replaced as follows:
Column 1 |
Column 2 |
1995 |
1994 |
10 |
10 |