GL Report Writer - Editing a Report Column Record
GL Report Rows are added and edited by right-clicking on a column on the Rows and Columns sub-tab of the Setup GL Reports window:
Field Descriptions
Item |
Description |
Report |
The name of the selected report. This is displayed by default. |
Column Details |
|
Heading |
The heading for the column. As well as plain text, this field can contain the parameters <PERIOD> or <QUARTER> - at runtime, these parameters will be replaced with the name of the period/quarter being reported on. |
Type |
Determines the function that the column performs. The following list describes each function.
|
Field Name |
This becomes active if the "Data Field" option is selected in the Type field. Allows the user to select directly from the GLACCS table. |
Period No |
Determines the period to be reported on. Current Period = 0. |
Frame Length |
This becomes active if the "Moving frame of periods" option is selected in the Type field. It specifies the number of periods to report on. |
From Period |
Used in conjunction with PD RANGE. Period No becomes the start period and From Period is the end Period No. |
Quarter Offset |
This becomes active if the one of the "Quarter" options is selected in the Type field. Specify the quarter to report on. The current quarter is 0; numbers greater than 0 signify past quarters, e.g. 1 is the previous quarter, 4 is the current quarter in the previous year. |
Include rolling 12 months |
The system accommodates reporting on either a financial year or rolling year (rolling 12 months) and the choice can be made at run time. This is achieved without having to modify the report after each period roll. For each column in the report you wish to optionally report on a rolling 12 month basis, tick this option so that this field will be either rolling 12 months or financial year only dependant on run time selection. If not ticked, then the field will always report financial year only. |
Order periods from oldest to newest |
This option applies to columns where the Type is set to "Moving frame of periods", or where the Type is set to "Period" and the Include rolling 12 months option is ticked. It affects the ordering of columns: when ticked, columns are ordered from oldest to newest, e.g. July 2011, August 2011 ... June 2012; when unticked, columns are ordered from newest to oldest, e.g. June 2012, May 2012 ... July 2011. |
Formatting Options |
|
Branch |
Used to set a specific branch in a column. If using branches in the column the user should have branches in rows set to All. |
Sequence |
Enter a number here to set or change the sequence that the row performs its defined action. |
Alignment |
Sets the option for printing alignment to the right or the left of the column. |
Width |
Determines the column width. |
% Range Row Seq |
For "Percentage" columns, this setting specifies the ID of the row that is the upper bound for percentage values. The report will calculate percentage values for all rows between the %Range Row Seq row and the % Row sequence row, and leave all other rows blank. If this value is set to -1, the report will calculate all rows as percentages of the value in the % Row sequence row. |
% Row sequence |
For "Percentage" columns, this setting specifies the ID of the row that all rows will be expressed as a percentage of. |
% Column sequence |
For "Percentage" columns, this setting specifies the ID of the column whose values will be expressed as percentages in this column. |
% Column Destination |
For "Percentage" columns, the setting specifies the ID of the column that values from this column will appear in. This can be useful if the report contains several sections, each with its own total - by setting up a percentage column for each section, then setting this value to the ID of the first percentage column, all percentages will appear in the same column. Note: If %Range Row Seq is set to -1, this value is ignored. |
|
|
Include Rolling Quarters in the financial year of the specified quarter offset |
Tick this option to report on quarters in a financial year going back from the quarter entered in the Quarter Offset field. |