Objective

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:

1. Create a report template including the customized reports and formulars
2. Uploading the report template in the GTC
3. Running the "Custom Report"

Creating the Report Template  

The report templates are based on Excel. Therefore, the first thing to do is to open an empty workbook in Excel. The report template must be able to load information (calculation data, master data) from the GTC during later execution in the GTC. For this purpose, a worksheet with the name "config" is created in the workbook.

There are 2 ways to load information from the GTC:

1. Read out existing standard reports ("Tax Reports")
2. Reading database contents with the help of SQL queries

Creation on the basis of "Tax Reports"

To be able to build on existing reports, the technical ID of the respective report must first be determined. This is then used in the configuration of the report template.

Determine the IDs of the tax reports to be used

1. Navigate to "Reports / Tax Reports"
2. Click on the "Columns" button in the header of the overview table
3. Click on "Change columns"
   
4.        "Click "ID" to display the GTC-IDs of the "Tax Reports"
5.         Copy the ID of the required report
   

Configuration in the report template

1. Switch to the "config" worksheet
2. Enter the report IDs to be used in column A
3. Define the name of the output report in column B
4. Optional: Specify the period type to be evaluated in column C
   
   1. <empty> .. current, selected period
   2. PRIOR .. Previous period, the currently selected period
   3. COMPARE .. specified comparison period
   4. TRUEUP .. TrueUp period, the currently selected period
   5. PRIORTRUEUP .. TrueUp period, the previous period, the currently selected period

Creation of the basis of SQL-SELECT-Statements

1. Switch to the "config" worksheet
2. Enter SELECT statement in column A
3. Define the name of the output report in column B
4. 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)
   
   1. PERIODID .. current, selected period
   2. PERIODID_PRIOR .. Prior period, the currently selected period
   3. COMPARE .. specified comparison period
   4. PERIODID_CURRENT_TRUEUP .. TrueUp period, the currently selected period
   5. PERIODID_TRUEUP .. TrueUp period, the previous period, the currently selected period
   6. UNITID .. Unit ID of the currently selected company

Upload created templates for the first time  

1. Navigate to „Own Reports“                
2. Click on „create Report“               
            
3. Assign report names
4. Click on „create Report“  
    
5. Click on "Select file" or "Browse" and select the created template                                                                                                                         
6. Upload the template by using the "+"-symbol

A first execution of the report

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.

Integration of individual evaluations

Now a new sheet can be created in Excel, where the data from the GTC can be displayed clearly.

Final upload of the report template

When the template with the descriptive presentation is finished, it must be uploaded again.

1. Click on the "Pen" symbol first                                                                                                                                                                                
2. Then delete the old template                                                                                                                                                                                  
3. Now upload the new template by clicking on "Select file" or "Browse" and select the created template
4. Upload the template with the "+" symbol
   
5. Own report is successfully created

The own report is now filled with "fresh" data in combination with the selected parameters each time it is executed. By deforming the own spreadsheet with the GTC reports, the updated data is displayed on the own spreadsheet.

Further notes

1. 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.
2. 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

1. Navigate to My Reports (Under the Reports section)
2. Click on Edit                                                                                                                                                                                                            
   
   
3. Then download the template (click on the file name)                                                                                                                                             
4. Now save the file locally and edit the Excel table as desired and save it again.
5. Upload the edited template, return to edit mode and delete the old template.
   
6. Then select the new file (template) and upload it (click on the "+" symbol)                                                                                                          
7. Then press Edit
   
8. Finally, execute the report