Ad Hoc Analysis Tab
This section includes the fields and descriptions for the Ad Hoc Analysis tab.
Report Island
| Field | Description |
|---|---|
| Name | Here you specify the name of the report, the name being the sole identification of the report. You cannot change the name of an existing report. To retrieve existing reports, use the search functions in the Find menu. The name is transferred to the tab-separated file created by the “Create tab-separated file” action. |
| Updated since Last Calculation | This field shows whether the report has been redefined since the last calculation. If the field is marked, you cannot transfer the report to a tab-separated file before recalculating the values. This is a precaution against inconsistencies.
When you make a new calculation using the “Calculate Ad Hoc Analysis” action, Maconomy removes the mark. You cannot change the value manually. |
Last Calculation Island
| Field | Description |
|---|---|
| Month/Yr. | This is the period of the last calculation for the report displayed. If no information is displayed in this field, the period has no influence on the report figures. The value cannot be changed. It is copied to the tab-separated file created using the “Create tab-separated file” action. |
| Company | These fields display the range of companies for the last calculation of the current report. If these fields are empty, no company range was entered when the report was created. The value cannot be changed. It is copied to the tab-separated file created using the “Create tab-separated file” action. |
| Made by | This is the name of the user who last made a calculation for the report. |
| Date | This is the date of the last calculation. The date cannot be changed here. The date is not transferred to the tab-separated file created using the “Create tab-separated file” action. |
Last Calculation, Dimensions Island
| Field | Description |
|---|---|
| Location | Here you can specify a range of locations. The G/L report in the Lines sub-tab will only include periodic figures for entries with dimension values within the specified range of locations. If no range is specified, the report is not affected by the Location fields. |
| Entity | The functionality of this field is similar to that of the field “Location” above. |
| Project | The functionality of this field is similar to that of the field “Location” above. |
| Purpose | The functionality of this field is similar to that of the field “Location” above. |
| Spec. 1-3 | The functionality of these fields is similar to that of the field “Location” above. |
| Local Spec. 1-3 | The functionality of these fields is similar to that of the field “Location” above. |
Currency Island
| Field | Description |
|---|---|
| Reporting Currency | In this field, you can specify the currency in which periodic figures should be displayed. All amounts in the window be converted into and displayed in this currency. If the current user has been assigned to a company in the window Users, Maconomy suggests the company base currency of the company in question.
When converting amounts into the selected currency, Maconomy uses the exchange rates valid on the date entered in the field “Exchange Rate Date” below, and the exchange rate table used is the exchange rate table selected in the System Information workspace in the Set-Up module. Please note that Maconomy performs currency conversion even though the original amount has been registered in the same currency as the one specified in this field, which may cause discrepancies between the registered amounts and the amounts shown in this window. |
| Exchange Rate Date | In this field, you can specify an exchange rate date. When converting amounts into the reporting currency, Maconomy uses the exchange rates that are valid on this date according to the enterprise exchange rate table selected in the System Information workspace in the Set-Up module for conversion of currency amounts. See also the field “Reporting Currency.” |
Description Island
Here you enter a description of the report. The two lines of text are copied to the tab-separated file that is created when you select the “Create tab-separated file” action.
New Calculation Island
| Field | Description |
|---|---|
| Month/Yr. | Here you enter the starting month/year and ending month/year of the period for which the analysis is to be printed. Enter the period as a number, for example, “1” for January, “2” for February, and so on.
If your company uses flexible periods that do not follow the calendar year, the month and year that you enter here refers to the period defined in the window Fiscal Year. |
| Company | In these fields, you can enter a range of companies. The G/L report in the Lines sub-tab will only include periodic figures for entries assigned to the specified range of companies. If no range is specified, the report is not affected by the Company fields. |
New Calculation, Dimensions Island
| Field | Description |
|---|---|
| Location | This is the range of locations used in the last calculation. The G/L report in the Lines sub-tab only includes periodical figures for entries with a location in the “Location” field that is within this range. If the fields are blank, they have no influence on the report. The information is transferred to the tab-separated file created using the action “Create TAB-separated File”. |
| Entity | The functionality of this field is similar to that of the field “Location” above. |
| Project | The functionality of this field is similar to that of the field “Location” above. |
| Purpose | The functionality of this field is similar to that of the field “Location” above. |
| Spec. 1-3 | The functionality of these fields is similar to that of the field “Location” above. |
| Local Spec. 1-3 | The functionality of these fields is similar to that of the field “Location” above. |
User Island
See the chapter “Getting Started” for a description of the fields in the User island.