Topic overview

In contrast to standard reports, defined reports use the row and column schemes you have defined. Complex reports can be individually configured and structured and created according to your ideas. The underlying definitions are stored in the applications Row scheme and Column scheme and are combined in this application. Column and row definitions are not limited to one report model, but can be used in different reports. In terms of the combination, however, both must be compatible with each other.

Possible row and column combinations are shown in the following table:

Defined reports that have already been created can be searched for and called up again using the Defined reports query application. There it is also possible to switch to the Voucher analysis by clicking on the balance items and to list the composition of individual items in detail. This is why the applications Output defined reports and Defined reports query are closely linked and complement each other in the creation and detailed view (Voucher analysis) of selfdefined reports.

Cross-organizational evaluations are possible for defined reports using the field Additional organizational units. This function was implemented for both financial accounting (e.g. balance sheet and PL) and controlling reports (e.g. BAB).

Which organizations can be evaluated together is checked on the basis of the parameterization when called. E.g. only organizations for which the evaluation currency is the primary main currency or a parallel currency are evaluated together. Compatible fiscal years and periods etc. must also be defined. Basically, the structure of the data must be compatible. You will be informed of any existing incompatibility when composing rows and columns.

It is also possible to create defined reports as an evaluation analysis. The deviation analysis compares two selected columns and uses the comparison data to calculate the deviation amount and the deviation in percent.

This document informs you about the parameters with which you define what the output of the report document should contain. You will also find information about the output result. The possible output settings in this application match the setting options in the dialog window for any output. You will find a description of the possible output settings in the user guide (see output orders).

You can find the procedures for using the document “Procedure: Output report documents“.

Restrictions

There is no compression (consolidation) for the reports. The summation takes place at runtime. This can have an impact on performance.

In order to limit the maintenance effort in the event of extensions or errors, this function was implemented with the existing report templates.

• Report with 5 columns
• Report with 8 columns
• Report with 5 columns
• Report with 11 columns
• Report with 14 columns
• Report with 17 columns

This function is implemented for row schemes with the following characteristics:

• For controlling database:
  • Cost types
  • Dimension elements
  • Dimension elements 2nd assignment
• For financial accounting database:
  • Object accounts
  • Debtors
  • Creditors

Organization-related and cross-organization reports are same menu item.

The input help for selecting the data only contains data from the organization from which the report was called.

Organizations in the columns are currently not realized. This means that it is not possible to compare different organizations in columns.

An organizational dissolution was not realized. In other words, a call in which every organization generates a report with a final overall report is not possible.

Application description

The application enables the selection of the data to be evaluated according to various selection criteria and with the row and column schemes you have defined. A front page with the selection parameters is output. You can also specify the output modalities (print, fax, mail) in the usual way.

Identification pane

The information on the report identification is stored here. You can choose from the existing reports and / or create new ones. The fields of the identification pane in detail:

• Definition – the name uniquely identifies the selection. You can assign names using either numbers or letters.
• Description – the description serves as an additional identifier. It can consist of freely selectable text. Enter a descriptive, memorable, and as unambiguous as possible name so that the search for it is made easier. A description with the same name can also exist several times.
• Additional organizational units – enter the organizational units you also want to evaluate.
• Infosystem (deviation analysis) – you use this field to specify whether the report should be created as a deviation analysis. If you activate the field, additional information is required for the report under the heading “Information system (deviation analysis).”

Work pane

 Tab Parameter

With the parameters you determine the search features and the resulting output. Accordingly, parameters are used to select data sets.

The following table explains the parameters. The parameter column contains the displayed name for a parameter. The contents of the Explanation column provide you with the respective meanings, among other things.

The fields in detail:

• Row scheme – the name uniquely identifies the row scheme. The assignment of names is possible with numbers as well as letters. Row and column schemes must match.
• Column scheme – the name uniquely identifies the column scheme. The assignment of names is possible with numbers as well as letters. Row and column schemes must match.
• Accounting standard – enter here the accounting standard for which the report should be output.
• Time frame type – select the time frame here. Valid values are: Posting period
  Calendar month
• Analysis period – analysis period with which the evaluation period is determined.
• Calendar month – a month must be specified.
• Internal currency – enter here the local currency (or currencies) to be evaluated.
• Display parameters – this indicator controls whether the selection parameters are printed.
• Check for complete authorizations – when activated, a check is made to ensure that evaluation authorization is available for all selected posting objects. If the authorization is missing for a posting object, the value is set to zero, and the information “No authorization” is displayed. Otherwise, it could be assumed that the full values are listed, although this is not true.

Tab Row details

Depending on the context of the selected row scheme type in the field Row scheme, the Financial accounting and Dimensions categories are either shown or hidden.

Layout of defined rows

Regardless for of how many organizations the report was accessed for, the rows defined are displayed in the same way.

The row display in the reports is summed up across all organizations. A detailed dissolution of a cell value by organization is possible using the voucher analysis.

Standard dissolution

The line explosion in the reports is still only carried out for the assigned elements (e.g. object accounts, cost types) and not additionally for the organizational units.

• Print help rows – determination of whether help rows are displayed in report evaluations.
• Line resolution – you can use the selection in this field to control the display of the value lines within the report. The following settings can be selected: With resolution – select this setting if you want a detailed analysis of the cost types or accounts posted. Only value lines where the field “Line resolution” is activated in the specified row scheme will be resolved. Additional lines will appear in the report according to the number of assigned cost types or accounts.
  Without resolution – select this setting if only the row values should be displayed in the report. The field “Line resolution” from the specified row scheme has no influence on the display in the report.
• Font size for resolved lines – this parameter is only useful if the report is called with line resolution. It defines the font size of the resolved lines.The following settings are available:
  • Analog lines
  • Normal
  • Enlarged

• Bold print for resolved lines – this parameter is only useful if the report is called with line resolution. It defines the bold print of the resolved lines. The following settings are available: Analog lines
  Bold print
  Normal
• Figure dimension for resolved lines – this parameter is only useful if the report is called with line resolution. It defines the number unit for the values in the resolved lines. For example, if the value is in hundreds, the number 12,345,678.90 is displayed as 123,456.79 when the report is printed or displayed, with the 2nd decimal due to rounding. The following settings are available:
  • Analog lines
  • In ones
  • In tens
  • In hundreds
  • In thousands
  • In tens of thousands
  • In hundreds of thousands
  • In millions
• Decimal places for resolved lines – this parameter is only useful if the report is called with line resolution. It defines the number of decimal places for the values in the resolved lines. The following settings are available:
• Analog to column
• Without decimal places
  • 1 decimal place
  • 2 decimal places
  • 3 decimal places
  • 4 decimal places
  • 5 decimal places
  • 6 decimal places

Tab Column details

If necessary, help columns can be output here and / or ascending or descending sorting can be specified. Depending on the selected row scheme type, the fields are either active or deactivated.

The fields in detail:

• Print help columns – determination of whether help columns are displayed or printed for report evaluations.
• Without column-/allocation selection – determination of whether the column/allocation selection should be taken into account. This parameter is only useful if information has been entered in the columns in the field “Select allocations.” If set, the assigned elements (e.g., cost types, object accounts) are assigned to all columns. Otherwise, each value of an assignment is checked to determine which column it should be assigned to.
• Hit column – determination by which column the report is sorted. Only value and formula columns can be specified as hit columns. Sorting can be done in ascending or descending order according to values, and both negative and positive values are taken into account.
• Sort hit column – the sorting of the hit column can only be specified if you are working with a hit column. Sorting can be done in ascending or descending order according to values. The following settings are available:
  • Descending
  •  Ascending
  • Not used

Tab Financial accounting

Depending on the context of the row scheme type selected in the field Row scheme, this Tab is either shown (e.g. for object accounts) or hidden (e.g. for cost types).

• Current account breakdown – determination of whether and how a current account breakdown takes place. The following settings are available: By balances, By balances from OI, No.

Example for two debtors:
In this example, both debtors have the same collective receivables account.
Debtor 1 has three open items:
OI 001 = 1,500.00 D
OI 002 = 1,500.00 D
OI 003 = 500.00 C
Debtor 2 has one open item:
OI 004 = 1,000.00 C

• Selection current account breakdown: No – the receivables and payables or credits are shown balanced according to the receivables collective account. According to the example, there is a total debit balance of 1,500.00 on the collective receivables account; this is shown on the assets side in the report.
• Selection current account breakdown: By balances – a total of all debit balances and a total of all credit balances are determined. There is a debit balance of 2,500.00 on debtor 1. For debtor 2, there is a credit balance of 1,000.00. In the report, the collective receivables account is shown once on the assets side with 2,500.00 in debit and once on the liabilities side with 1,000.00 in credit.

Tab Dimension

Depending on the context of the selected row scheme type in the field Row scheme, this tab is either shown (eg for cost types) or hidden (eg for object accounts). The same applies to the activated fields in this Tab.

Tab Output settings

Here you deposit the document templates and file saving options.

• Data name – name of the file without file extension. The file extension is added automatically. If a file with this name already exists, a sequential number is automatically added to the name of the new file to be created. Variables can be used in the file name. When the file is created, the placeholders are replaced by the values they represent. The variables and their meanings are given below:
  • {report} description of the report
  • {user} user name
  • {timestamp} date and time in milliseconds (yyyyMMdd_HHmmss_SSS)
  • {datetime} date and time (yyyyMMdd_HHmmss)
  • {date} date (yyyyMMdd)
  • {time} time (HHmmss)
  • {week} calendar week (ww)
  • {year} year (yyyy)
  • {month} month (MM)
  • {day} day (dd)

The following variables are also available for the output of voucher documents:

• • {document} description of the voucher
  • {number} complete order number (type and number)

Tab Info system (deviation analysis)

Creating a report as a deviation analysis allows you to select any two columns from a set of value columns as comparison columns and to determine deviation columns (amount and percentage) for these columns.

Deviation columns must be created as formula columns in a separate column schema of the type Info system (deviation analysis).

The fields of the tab:

• Base column – in this field, enter the number of the column that you want to evaluate as the first comparison column in the deviation analysis. Only a value column from the level column scheme specified in the report is permitted as a base column. You can use the input help Find column position to select the desired column.
• Reference column – in this field, enter the number of the column that should be compared with the base column as a comparison column in the variance analysis. Only one value column from the column scheme specified in the report is permitted as a reference column. You can use the input help Find column position to select the desired column.
• Analysis row – you can optionally enter a row number here in order to limit the deviation analysis to one row. The report is then only created for this row. Only one value line from the row scheme specified in the report is permitted as an analysis row. You can select the required row using the input help Find row number.
• Column scheme (Info system) – in this field, you enter a column schema of the type Information system (variance analysis). The columns from this column scheme supplement the deviation analysis with freely definable deviation calculations. You can use the input help Find column header to select the desired column scheme.

Application-related action

The application-related action Generate report is available in this application:

Generate report

Activating this action starts the website dialog Generate defined report with which you can define the background and output settings. You can also get information about the completion of the processing order and then branch to the processing or output order. A general description of how to deal with processing and output orders can be found in the articles Processing orders and Output orders.

Output result

In the cover sheets if requested the selection criteria of the subsequent report are reproduced so that a unique assignment and assessment of the list output is guaranteed.

The report contains the following areas:

• Headline
• Column headings
• Data lines
• Footer line

Headline

The following is output in the headline:

• Defined reports – general report name.
• Definition – definition of report.
• Comarch ERP Enterprise – name of software.

Column headings

Explanation for the output data, which is located under the respective column heading:

2nd row – selection data are specified as header data, separated by horizontal lines. The relevant headings are shown depending on the underlying column scheme. A listing and description of the columns is therefore dependent on the definition in the column scheme and cannot generally be reproduced at this point.

Data lines

The following is output in the data lines:

n.n. – values defined by row and column schemes, possibly consisting of individual, sums, dates, difference values, etc.

Footer line

The following is output in the footer line:

• Name of organization – the name of the organizational unit is shown on the left.
• Current page number – the current page number is shown in the middle. You can see the total number of report pages in brackets.
• User and time – the user of the report is displayed right-aligned.

Evaluation options for percentage columns

Percentage calculation in columns is possible in defined reports from financial accounting (e.g. balance sheet and PL) and controlling (e.g. BAB). This assumes that the corresponding information is available both in the column definitions and in the row definitions of the column and row schemes used in the report. You can find detailed information on this information in the articles Definition of Columns and Definition of Row.

The following example shows the link between column and row definitions for the percentage calculation and shows the respective calculation of the relevant rows and columns for the report.

Column definition:

Row definition:

Rows and columns in defined reports:

Based on the information in the row and column definitions, the respective row value for column 10 (related column) is calculated as follows and output in the report. In this report, column 10 remains in row 500 EMPTY, since there is no information for this row in the row definition.

Percent calculation:

Per mill calculation:

Multiplication:

Division:

Customizing

No settings need to be made for the Output defined reports application in the Customizing application.

Report

The following report is relevant for the Output defined reports application: Output defined reports com.sem.ext.app.fin.reporting.ui.DefinedReportsReportOutput

Authorizations

Authorizations can be assigned by means of authorization roles as well as by assigning an organization. The authorization concept is described in the technical documentation Authorizations.

Special capabilities

The Output defined reports application has no special capabilities.

Organizational assignments

To ensure that a person can use the Output defined reports application the person must be assigned to an organization in the partner master data that is integrated into at least one of the following organizational structures:

• Financial accounting

Special features

There are no special features for the Output defined reports application.

Authorizations for business partners

 The Output defined reports application is not released for business partners.