...
In the menu "Own Reports" users of the GTC who have the appropriate authorisations can compile individual reports for data evaluation. Examples are key figure analyses or complex posting documents. These individual reports can then be stored and marked as "own standard".
In order to be able to use an "Own Report" in the GTC, the following steps must be carried out:
...
- Navigate to "Reports / Tax Reports"
- Click on the "Columns" button in the header of the overview table
- Click on "Change columns"
- "Click "ID" to display the GTC-IDs of the "Tax Reports"
- Copy the ID of the required report
Configuration in the report template
- Switch to the "config" worksheet
- Enter the report IDs to be used in column A
- Define the name of the output report in column B
- Optional: Specify the period type to be evaluated in column C
- <empty> .. current, selected period
- PRIOR .. Previous period, the currently selected period
- COMPARE .. specified comparison period
- TRUEUP .. TrueUp period, the currently selected period
- PRIORTRUEUP .. TrueUp period, the previous period, the currently selected period
Creation of the basis of SQL-SELECT-Statements
- Switch to the "config" worksheet
- Enter SELECT statement in column A
- Define the name of the output report in column B
- Optional: If the SELECT statement has been defined with the "?" operator, the columns C ff. can be defined what to replace them with. The value in column C thus replaces the first "?", the value in column D replaces the second "?", and so on. (case sensitive)
- PERIODID .. current, selected period
- PERIODID_PRIOR .. Prior period, the currently selected period
- COMPARE .. specified comparison period
- PERIODID_CURRENT_TRUEUP .. TrueUp period, the currently selected period
- PERIODID_TRUEUP .. TrueUp period, the previous period, the currently selected period
- UNITID .. Unit ID of the currently selected company
Upload created templates for the first time
- Navigate to „Own Reports“
- Click on „create Report“
- Assign report names
- Click on „create Report“
- Click on "Select file" or "Browse" and select the created template
- Upload the template by using the "+"-symbol
...
The report can be created in the "Run Report" column and then downloaded from the "Report Repository" at the top right.
After successful download, the previously defined spreadsheets were created.
...
Now a new sheet can be created in Excel, where the data from the GTC can be displayed clearly.
Editing / Final upload of the
...
Report Templates
When the template with the descriptive presentation is finished, it must be uploaded again.
- Click on the "Pen" symbol first
- Then delete the old template
- Now upload the new template by clicking on "Select file" or "Browse" and select the created template
- Upload the template with the "+" symbol
- Own report is successfully created
...
- When selecting the reports, make sure that reports from different period types are not mixed. For example, reports from planning periods cannot be used in "Closing V3" periods.
- When using setting parameters such as comparison period, currency and scope, you should ensure that not all reports used necessarily support these parameters. The table under "Tax Reports" shows whether a report supports a parameter.
Editing the Report Templates
...
...
...