G/L Report Columns Workspace
Use this workspace to enter and change column specifications that Maconomy uses in financial (G/L) reports.
A G/L report has columns and lines (or rows). The columns control the type of information to be shown, such as actual or budgeted figures, while the lines control the range of information-the accounts and dimensions that are included in the lines.
You define a set of columns in this workspace. For each set of columns, you supply a name, a description, and a report layout (for example, 16ColumnsHorizontal).
The lines in the Column Description Lines sub-tab represent columns in the report. For each column, you enter a header, identify which figures to show, enter a calculation formula, specify whether the report is to include period changes or opening/closing numbers, select a number format, and so on.
For each column, you can also select the period for which the data should be calculated. The period you specify can be relative to the period you entered when you executed the report. For example, you can specify that a column show data for the current period, and another column show data for that same period but from a different year. If you select August 2014 when you execute the report, Maconomy shows one column with data for August 2014, and another column with data for August 2013.
The layout that you choose might limit the number of columns you can include in the report. The absolute maximum is 40 columns, but some layouts allow for fewer columns.
- A text column, which is defined for every report line in the G/L Report Set-Up workspace.
- Additional columns that display text, actual figures, budgeted figures, or calculations (for example, a percentage variance between actual and budget figures).
Each line in a column shows information that is consistent with other lines in the same column. For example, if the first column displays actual figures for a given period, all lines in that column display actual figures for the specified period. Budget figures and figures for other periods must be shown in another column. However, you can change the period for an individual line in a G/L report, such that all of the figures for this line relate to the specified period.
For actual or budgeted figures, you can choose to include only figures for a given location, entity, project, or period. You can enter a limitation using a range of dimension values for each line and for each column in the report. If you do so, the limitation on the column level has higher priority than the limitation on the line level.
If you delete a line from the Column Description Lines sub-tab, Maconomy does not check to see whether the deleted line was referenced by one or more calculation formulas on other lines. For this reason, you should carefully consider the effect of deleting lines.
If you do not define a column, it is blank on the report.
You can print G/L reports using the Print Report action in the G/L Report Set-Up or Print G/L Report workspace. You can also export the report to a tab-separated file using the Create Tab-separated File action in the G/L Report Set-Up workspace.