Column Description Lines Sub-Tab
This section includes the fields and descriptions for the Column Description Lines sub-tab.
| Field | Description |
|---|---|
| No. | This is the column number. This number determines where on the printout the column is placed. This number is also used for referring to a given column in column calculations.
You can define up to 40 columns, but the number of columns printed depends on the layout that you choose. |
| Heading | Enter the column header here. It is printed in the report using a report line of the type “Column Heading.”
It is possible to use fixed texts as well as texts which refer to the period the column is for. When the report is printed, the text is replaced by the value it represents. If the column covers more than one month, the printout shows the first and the last month in the period. These are the references you can use:
|
| Type | In this field, you can specify the figures on which the amounts in the column should be based. You can choose between the following figures:
|
| Basis | Here you choose whether to display actual or budgeted figures, provided you have chosen “Amount in Base Currency,” “Amount in Currency,” “Amount in Enterprise,” or “Quantity” in the “Type” field. You can choose between “Actual” or “Budget.” Note that if you select “Budget,” you must select the option “Amount in Base Currency” in the field “Type,” as Maconomy only maintains budget figures in the base currency of the company assigned to each budget entry. If you have specified “Tax” in the field “Type,” you must select “Actual” in this field. |
| Balance | Here you choose whether to display the period’s opening balance, closing balance, or period changes, provided you have selected “Amount,” “Quantity,” or “Tax” in the field “Type.” The options here are “Closing,” “Opening,” and “Change.” |
| Direction | Here you choose whether to display the period’s debit entries, credit entries or all entries, provided you have chosen “Amount” in the “Text” field. The options are “Debit,” “Credit,” and blank, the last of which includes all entries. |
| Calculation | Here you enter a calculation formula, provided you have chosen “Calculation” in the “Type” field.
A calculation formula can consist of references to other columns, numeric constants, and math operators. You refer to a column by entering its column number. A whole number preceded by a 0 is interpreted as a numeric constant. The math operators +, -, *, and / can be used for calculations involving columns or whole numbers. Parentheses may also be used to separate calculation expressions. Finally, you can use the % sign to find the percentage ratio between two columns. Here are some examples of calculation expressions:
Please note that if a line in the Column Description Lines sub-tab is deleted, Maconomy will not check whether the deleted line was referenced by one or more calculation formulas on other lines. For this reason it is recommended that you check the calculation formulas for references to the deleted lines and any subsequent lines which have changed number because of the deletion. If you choose “Text” in the “Type” field, you can enter a text or a text reference in the Calculation field. If the line is a “Text” line, and you enter a text in the column, the printed report line will display the line text and not the column text. You can enter fixed texts as well as texts to be retrieved by references to account, location, entity, or project. When the report is printed, the reference will be replaced with the value that it represents. Note that to get correct information in your reports, you should enter kernel strings for the relevant texts. It is, however, possible to enter template strings, but as these might not be configurable when using localized versions of Maconomy, using template strings might result in incomplete reports. You can use the following account references:
You can use the following references for dimensions. Replace “<dimension>” with the name of the dimension in the list below. The dimensions are written as follows:
You can use the following references for the dimensions above:
You can use the following column reference:
You can use the following extra texts of the report:
(These texts will always refer to the main report, that is, the user-generated report). You can use the following reference to the main company, that is, the company which appears on all printouts not related to a specific company:
You can use the following references to the Company Information workspace:
Name 1-5, ZipCode, City, and Country refer to the Address fields in the Company Information workspace for the current company. Address 1-8, however, refer to formatted address information. This means that the address consists of Name 1-3, followed by ZipCode and City (in one field), followed by Name 4-5, and finally Country. Blank fields are omitted. This is best illustrated by an example:
The other address fields are blank. You can use the following references to the current year and month:
|
| Period Change | In this field you can enter a whole number that determines the column period relative to the period in the G/L report Selection Criteria. For example, if you enter “-12” the column will display figures for the same period range in the previous year. |
| Period Reference | In this field you can enter a time frame for which the figures in the column are to be shown, relative to the period in the G/L report Selection Criteria. You can choose between the following options:
It applies to each of these period references that any relative period specified in the field “Period” above will affect the period reference specified in this field. To find the relevant period, Maconomy adds the number of months specified in the field “Period” (or deducts it if it is a negative figure) to the last month covered by the report and determines the period covering the resulting month. If, for instance, a report is to print figures from months 1-7 in a given year, and this field specifies “Quarter,” the column will show figures for the third quarter of the year, that is, the months 7, 8, and 9, as mentioned above. If a relative period of “-2” is specified in the field “Period,” Maconomy will deduct two months from the last month to be printed (month 7), thus determining that the last month to actually be covered by the report is month 5, which is in the second quarter of the year. Therefore, the column will, instead, show figures for the second quarter, that is, the months 4, 5, and 6. |
| Show As | Choose the number format here. You can choose between “Decimals,” “In Whole Numbers,” “In Thousands,” “Millions with one decimal,” or “Millions.” |
| If you check this field, the current column will be printed out. | |
| Company From | The values in this field and in the field “Company To” constitute a range of company numbers to be included in the column figures. This range is only used if the column should display realized or budgeted figures. The range applying to a given report field can, however, also derive from the card or table part of the report definitions in which the column appears. For a description of the priority used for determining the company range to apply to each report field in a given report, you should therefore see the field “Company No. From” in the table part of the G/L Report Set-Up workspace. |
| Company To | The functionality of this field is similar to that of the field “Company From” above. |
| Account No. From | The functionality of this field is similar to that of the field “Company From” above. |
| Account No. To | The functionality of this field is similar to that of the field “Company From” above. |
| Location From | The functionality of this field is similar to that of the field “Company From” above. |
| Location To | The functionality of this field is similar to that of the field “Company From” above. |
| Entity From | The functionality of this field is similar to that of the field “Company From” above. |
| Entity To | The functionality of this field is similar to that of the field “Company From” above. |
| Project From | The functionality of this field is similar to that of the field “Company From” above. |
| Project To | The functionality of this field is similar to that of the field “Company From” above. |
| Purpose From | The functionality of this field is similar to that of the field “Company From” above. |
| Purpose To | The functionality of this field is similar to that of the field “Company From” above. |
| Spec. 1-3 From | The functionality of these fields is similar to that of the field “Company From” above. |
| Spec. 1-3 To | The functionality of this field is similar to that of the field “Company From” above. |
| Local Spec. 1-3 From | The functionality of these fields is similar to that of the field “Company From” above. |
| Local Spec. 1-3 To | The functionality of this field is similar to that of the field “Company From” above. |
| Budget Model | If you have selected “Budget” in the field “Basis,” you can select the specific budget model from which to retrieve the figures in this field. If you select both a specific budget model and a budget type in the field “Budget Type,” a budget model of the specified name and type must exist. Otherwise, no figures will be displayed. |
| Budget Type | If you have selected “Budget” in the field “Basis,” you can in this field select the budget type from which to retrieve the figures. Budget types are created in the Popup Fields workspace in the Set-Up module and assigned to budget models in the Budget Models workspace. For example, you have created a budget type called “Anchor.. In one fiscal year, the name of a budget model of the type “Anchor” could be “Anchor 1998,” and in another year it could be called “Anchor 1999.” To avoid adjusting the G/L report column specifications every fiscal year, it is advisable to select a budget by budget type, instead of selecting a specific budget model. |
| Budget Version No. | If you have selected “Budget” in the field “Basis,” you can in this field select which version of budget specified in the fields “Budget Model” or “Budget Type” you wish to use. |
| Budget Version Type | If you have selected “Budget” in the field “Basis,” you can in this field select the budget version type from which to retrieve the figures. Budget version types are created in the Popup Fields workspace in the Set-Up module and assigned to budget models in the Budget Models workspace. Instead of selecting a specific budget version in the field “Budget Version No.,” you can in this field specify a budget version type. For example, you have created the budget version type “Revision 1.” In one fiscal year a budget model of the version type “Revision 1” has budget version number 2; in another year the version number might be 3. To avoid adjusting the G/L report column specifications every fiscal year, it is advisable to select a budget by budget version type instead of selecting a specific budget version. |
| Currency | In this field, you can specify the currency in which to display amounts in the current report field. The reporting currency used in any given report field can, however, also derive from the card or table part of the report definitions in which the column appears. For a description of the priority used for determining the reporting currency to apply to each report field in a given report, you should therefore see the field “Currency” in the table part of the G/L Report Set-Up workspace. |
| Exchange Rate Table | In this field, you can specify the exchange rate table to be used when converting currency amounts in the current report field. The exchange rate date used in a given report field can, however, also derive from the card or table part of the report definitions in which the column is used. For a description of the priority used for determining the exchange rate table to apply to each report field in a given report, you should therefore see the field “Exchange Rate Table” in the table part of the G/L Report Set-Up workspace. |
| Exchange Rate Date | In this field, you can specify the exchange rate date to be used when converting currency amounts in the current report field. The exchange rate date used in a given report field can, however, also derive from the card or table part of the report definitions in which the column appears. For a description of the priority used for determining the exchange rate date to apply to each report field in a given report, you should therefore see the field “Exchange Rate Date” in the table part of the G/L Report Set-Up workspace. |
| Price Year | If you have selected “Budget” in the field “Basis,” you can in this field select the price year to use when displaying figures from the budget selected in the budget specification fields above.
If you select a price year, and the budget model selected was not created using that price year, Maconomy will convert the budget figures to the prices of the price year selected according to rules specified in the Price Areas and Price Registers workspaces in the Budget module. For a further description, please see the description of those workspaces in the documentation about the Budget module. If you do not specify a price year, the figures in the selected budget model will be used without conversion. |
| Price Register | In this field you select which price register to use if the budget figures need to be converted to a price year specified in the field “Price Year.” See the description of the field “Price Year” above. |
| Prior-Period | For actual figures, you can choose only to show entries from a given prior period.
Prior-period journals are used when posting in closed fiscal years. Periods are created in the pop-up field “Prior Periods” in the Popup Fields workspace in the Set-Up module. |
| Column Width | In this field, you can specify the desired width of the current column. The field only applies when the column specification is used on a report which is printed to an RTF file, in which case the width of the table cell corresponding to the current column will be applied the specified width. |