Release Notes 21.XX.00

Situation:

A period import with activated option "Overwrite period" does not create the standard unit.

A period import with deactivated option "Overwrite period" and without update, create/restore, archive of units does not reset the milestones.

Solution:

A period import with activated option "Overwrite period" creates the standard unit.

A period import with deactivated option "Overwrite period" and without update, create/restore, archive of units resets the milestones.

Situation:

The log4j version 2.17.1 has been published. It remedies a further security issue. Furthermore there was a problem with GTC installation in UNIX/Linux environment.

Solution:

GTC integrates the latest log4j version 2.17.1. The installation can also be done in UNIX/Linux environment.

Situation:

A user with the 'SysAdmin-Edit' permission cannot edit the 'Email Administration' dialogue.

Solution:

The 'Email Administration' dialogue is opened in the edit view for users with the 'SysAdmin-Edit' permission.

CoA Group

CoA Company

Situation:

The layout of OCI categories in the CoA dialogues by means of radio buttons is intransparent. Furthermore the list of OCI categories in row "income statement-related" is irritating, if the position was defined as a a temporary difference affecting equity.

Solution:

There is a new row "P&L relevant" with a checkbox "Temporary difference affecting equity". If the checkbox is not activated, the position is affecting P&L. If it is activated the position is a temporary difference affecting equity. Below is the row "OCI category" with a dropdown list of OCI categories maintained. Depending from the checkbox "P&L relevant" the selected category is to be understood as affecting P&L or affecting equity.

The Goodwill row is only shown for v1 and v2 periods. When the "Goodwill" option was selected in a non-v1 or non-v2 period, the CoA position is changed to "Temporary difference affecting equity" with OCI category "Other".

The changes described above are implemented for both dialogues "CoA Group" and "CoA Company", if the flag SHOW_COA_MOVEMENTTYPES is deactivated.

AMANA wants to standardise the design of its own software products.

Therefore, the colour palette, font family, font sizes and other elements of the GTC layout have been adapted to this. Adjustments will also be made in the future.

Situation:

The report "Rollforward deferred taxes" cannot be opened if the current period has no prior period or the currently relevant company (possibly also in the group structure) does not exist in the prior period.

Solution:

The report can also be opened if it is a new company or no prior period relationship has been maintained.

Situation:

The GTC uses the Log4j library to generate log files.

Log4j version 1.x is not officially supported anymore. Security vulnerabilities have been uncovered and are no longer secured in the version.

Solution:

The Log4j library has been updated to the latest available version 2.16.0.

Configuring log levels at runtime is no longer supported by this version. Therefore, this option is no longer available in the administration area.

Situation:

If a user performs a transaction data copy without authorisation "Master Data: Countries - Read", the GTC runs into an error when saving the data.

Solution:

The user does not need the above right to perform a transaction data copy.

Situation:

If flag SHOW_OCI_AT_SUMMARY is activated, entries in dialogue "Others", block "Change in consolidation (cur. year)", rows "Temporary differences" (P&L as well as OCI) are doubled in dialogue "Summary", block "Deferred taxes summary", rows "P&L Debit/(Credit)" and "OCI", column "Change".

Solution:

The values in column "Change" are correct.

Situation:

Feedback from our customers has indicated that the functions in the enhanced mapping could be expanded.

Solution:

1. additional check conditions have been implemented. Details can be found in the separately available documentation for the enhanced mapping.
2. the import into the data transfer is now possible with assembled target items.
3. it is possible to import into the tax balance sheet column of the B/S comparison.

Situation:

The enhanced bulk import of companies does not work, whenever it involves a filter with respect to materiality or reporting dimension and the subgroup company itself does not fullfil the filter condition.

Solution:

The enhanced bulk import of companies works with a filter for materiality or reporting dimension independent from properties of the selected subgroup company.

Situation:

If the upper/lower case of the target position in the mapping does not match the GTC TRR position during a standard import (e.g.: POS04A instead of pos04a), an error message is displayed, nevertheless the value is saved.
If the TRR had not been saved before, the imported value will not be displayed and the value cannot be changed via the entry in the TRR field either.

Solution:

Regardless of the upper/lower case of the target position in the mapping, the value is imported and saved. Consequently, the value can also be edited in the TRR dialogue afterwards.

Situation:

A company that transfers deferred taxes to its parent company in the previous period was deleted/archived in the subsequent period. The flag SHOW_OCI_AT_SUMMARY=1 is active.

The result sheet cannot be opened for the parent company in the current period. A system error message is displayed.

Solution:

The result sheet can be opened for the parent company in the current period.
In the breakdown of OCIs, the figures of the pre-period company are taken into account in the Change column.

Situation:

Over the time, new columns were added to the dialog. The current arrangement of the columns now seems completely random. The user has to jump between the columns to get an overview.

Solution:

According to the feedback of our customers the columns were rearranged. This does not change the calculation in the dialogue.

There is now another control of the functionality:
The countries and reporting dimensions, if full import is not selected, are only added or updated if they are archived or do not exist in the target system.

Further Documentation:
https://docs.amana.de/x/ywCzB

Situation:

The metadata for displaying the period export or import are managed in the system settings table. If the entries are too long (e.g. in the field for companies), the transfer is aborted.

Solution:

The information is stored in a separate table with enough space for all data.

Situation:

Depending on the configuration of the dialogue, values are incorrectly transferred from the previous period to the opening balance of the current period.

Solution:

The closing stock of the previous period is correctly taken over into the current period.

Situation:

If a period import has option "Overwrite period" deactivated, but option "Import shareholding structure" activated, circular references can exist in tax payer or legal owner relations.

Solution:

Before the import of each shareholding value the relations are checked for circular references. Whenever they exist the relaton is ignored and a message can be found in the import protocol..

Situation:

In the collection dialogue of Audit issues a user must have the authorization for „Master Data: Balance Sheet Structure (Company) – Read“, when the unit is an intermediate parent or tax payer of a tax group. The audit risk authorizations are not sufficient in this case.

Solution:

The collection dialogue of Audit issues can be used with audit risk authorizations alone.

Situation:

The standard tax reports
- Tax rate reconciliation Late Adjustment column
- Tax rate reconciliation IFRS column
- Tax rate reconciliation local GAAP column
- Tax rate reconciliation adjustment column
the "Unit tax rate" is not formatted as an Excel number. Furthermore there is no hint in the corresponding label that it is a percentage value.

Solution:

In order to make the unit tax rate accessible for Excel it is formatted as a number, which was already done for other tax rates within this report. The corresponding label gets an additional percentage symbol "(%)".

Situation:

When using an interface structure that ignores IFRS values, but imports Local GAAP and Tax balance values, different mappings for positive and negative values lead to an incorrect import.

Solution:

The import is adapted so that it works corrrectly for the situation described above.

Situation:

For connections with MySQL databases GTC uses the MySQL JDBC driver 5.1.21. This version suffers from several security issues.

Solution:

Connections with MySQL databases use the latest MySQL JDBC driver 8.0.26. This driver supports MySQL versions 5.6, 5.7 and 8.0.

Situation:

With a large number of users who have been assigned many individual permissions, the user overview opens very slowly. In addition, the table could not be exported correctly.

Solution:

The display is simplified by combining the four columns of the "Role-Company Assignment" into one column. This avoids the display problems and the page can be built up faster by the browser.

In addition, the column for displaying the " blocked" status is removed. Instead, the selection field " Display" can be used to control which data is shown: The entries "active", "archived" and " blocked" users are available for selection.

In the master data of the toolbox, the positions 13.1 "Taxed at a different tax rate" and 13.2 "Of which taxed from withholding tax" are now made available. After activation, these two items are mapped below line 13 and, according to the previous calculation logic, additionally run into and reduce the calculation of line 13 "Taxable income for corporate/local tax". Line 13.1 is determined by the sum of lines 40.1.1, 40.2.1, 40.3.1 and 40.4.1. Line 13.2 is a carryover of line 41.1. This function is activated with patch 1300981.

Situation:

The JDBC driver for Oracle databases which was used up to now is no longer maintained by Oracle.

Solution:

An up-to-date JDBC driver for Oracle databases is used (ojdbc8.jar). It supports Oracle 12.2, 12cR2 and later database versions.

Implementation of the interface type "direct import" for validation in the single company.

Situation:

When calculating in the audit questionnaire, incorrect results are stored in the overview.

Solution:

The calculation in the audit questionnaire is performed separately for each version.

Situation:
Compliance: file downloads via the ToDos overview are not possible.

Solution:
File downloads enabled again.

Situation: 
Currency fields with NIL values, are displayed as empty fields.

Solution: 
Currency fields with NIL values are displayed in gray in the Questionnaire.

Situation:
Calculated values which are displayed in the overview are not updated.

Solution:
Values are updated correctly.

Situation:

In the reports "Report Differences" and "Report Differences (without zero values)" no currency conversion could be executed.

Solution:

The selection in the dropdown "Currency" is now also supported for the reports "Report differences" and "Report differences (without zero values)".

The currency conversion takes place using the FX rate maintained for the respective company or the assigned country.

Situation:

In case of a tax rate change between the current and the true-up period, the corresponding effect on deferred taxes is shown once in the TRR and in the Other dialogue, but with different signs.

Solution:

In case of a tax rate change between current and true-up period, the corresponding effect on deferred taxes is shown in the TRR and in the Other dialogue with the same sign.

Situation:

Detail information in tax forms cannot be imported. They can only be delivered by manual input.

Solution:

The interface direction "Import enhanced" (Mapping Engine) supports an import into detail information of tax forms

Situation:

E-Mail Reminder does not send reminder mails for archived items

Solution:

E-Mail Reminder sends reminder mails for archived items

Situation:

Custom rows created through the Toolbox Master Data dialog were no longer present in the totals calculation of rows 16 and 33.

Solution:

By a job, which is executed at the start of the server, such manual lines are calculated again in the lines 16 and 33.

Please check in the autorun log if the job with ID 48 was processed correctly.

Situation:

The report "Rollforward DT" shows the deferred taxes of current and prior period and the detailled change between both periods. The calculation to group currency is only executed with the average exchange rate.

Solution:

The report is calculating with the correct exchange rate per single value now.

Situation:

The dialogue "Report tax balance based profit" is currently only displayed for companies with german tax law.

Solution:

The dialogue "Report tax balance based profit" shows the calculation of the taxable profit/loss. This is relevant for the tax calculation regardless of Germany. Therefore, this dialogue is now displayed for all companies.

Situation:

Very large numbers (several billions) without decimal places cannot be imported by REST service. An error message concerning an invalid data format is shown.

Solution:

Very large numbers (several billions) without decimal places are correctly imported by REST services.

Situation:

Master data for units have different fields concerning fiscal years in different years. The fields visible in "Bulk edit" mode may deviate from them.

Lösung:

The fields for fiscal years in "Bulk edit" mode are the same as those when editing a single unit.

The status overview in the (sub-)group area was revised.

The contents of the table with the dependent milestones were updated. The columns with the persons responsible have been removed; instead, the country of the company is now also displayed.

In addition, the table can be sorted and filtered. The print and export functions have also been updated.

Situation:

By means of the export of GTC IDs users can access nearly any GTC value and use them in their "Own reports". In some areas users have the need for addtitional IDs. Differences in the B/S comparison for columns with the same properties regarding P/L vs OCI and temporary vs permanent are not aggregated.

Solution:

Difference values in the B/S comparison for columns with the same properties regarding P/L vs OCI and temporary vs permanent are added up.
In the "Summary" values for Subtotal and Offsetting are exported with their own IDs.
In "LCF" values of the different categories are additionally exported with new unifying IDs. Some additional values are exported wiith new IDs.

In the report Companies (REPORT_UNITS), the data "Postal code, city" is no longer taken from the Company data tab but from the Management address tab.

Design / GUI

Situation:

When dialogues in the GTC are larger, such as in the balance sheet comparison, it is not easy for the user to keep a clear overview.

Solution:

The headings and line descriptions in tables can be fixed. The setting is made in the dialogue "My Profile".

You will find additional information in the user guide.

Situation:

There is a fixed list of file extensions within GTC which defines that certain file types must not be uploaded.
The system administrator has no possibility to modify this list due to security aspects.

Solution:

In dialogue "Administration / System settings" the system administrator can configure which file types may and which file types must not be uploaded. For this purpose either a list of "Allowed file extensions" or a list of "Not allowed file extensions" can be defined

If the list of allowed file extensions is configured, only files with a file extension included in the list may be uploaded. If the list of not allowed file extensions is configured, only files with a file extension which is not included in the list may be uploaded. It is not sensible to define both lists. In this case the list of allowed file extensions is the leading one.

In each case the list is specified as a sequence of file extensions without the dot separated by a comma, semicolon or blank. Initially these settings are filled with file extensions not allowed in GTC.

Situation:
Risks triggered via the Questionnaire were not displayed in the overview.

Solution:
Risks are displayed in the overview.

Situation:
Numerical values are wrapped in the risk overviews.

Solution:
Numerical values are no longer wrapped.

Situation:

The password guidelines provided at delivery were no longer in line with current recommendations.

Solution:

The guidelines provided at delivery were updated. Detailed information on the configuration options can be found in the corresponding chapter. Users can still log in. As soon as a user has to assign a new password on a regular basis, the new configuration is applied.
The minimum length of the username has been raised up to 8 characters.

Situation:

When archiving a company, an error message occurs if this company has subordinate companies. The error occurs as of version 20.16.00.

Solution:

Archiving of companies can be performed without error messages.

Situation:

The master data of the toolbox cannot be edited if "---" is selected as the country.

Solution:

The display of certain lines can be activated and deactivated in the toolbox master data.

Situation:

When archiving a company, an error message occurs if this company has subordinate companies. The error occurs as of version 20.16.00.

Solution:

Archiving of companies can be performed without error messages.

Situation:

The password guidelines provided at the time of delivery were no longer in line with current recommendations.

Solution:

The guidelines specified at delivery have been adapted. Detailed information about the configuration options can be found in the corresponding chapter. Users can still log in. As soon as a user has to assign a new password on a regular basis, the new configuration is applied.

Situation:

In the "(Sub-)Group / Status" section, the milestone "Actual taxes" is missing in the "Milestones of dependent companies / (sub-)groups" section for consolidation units.

Solution:

The milestone is now displayed.