Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Release Notes 23.1 IDL Konsis, Forecast, Xlslink


Contents


1 General Notes

1.1 About this Release

This documentation describes the changes in IDL Konsis, IDL Forecast, and IDL Xlslink compared to Release 22.3. The minimum requirement for installing this version is the installation of Release 22.3.

The previously released fixpacks are included.

With this release, maintenance for the 22.3 release ends.

1.2 Data Backup

You should make a backup of your database(s) before installing this version.

1.3 Migration

After installation, the release migration for IDL Konsis / IDL Forecast must always be performed first. After logging in, start the release migration via <Start migration now> in the message window. A restart is not necessary, all applications are available afterwards.

You can find the protocol of the migration under the short word KONVERT (right-click on the corresponding migration).

If the migration is not started in this manner, e.g., because the logged-in user lacks authorization, the call of other applications is blocked. The only exceptions are the applications for maintaining the authorization data if the logged-in user does not have authorization to execute the migration due to the use of individual authorization groups. After manual execution of the migration, IDL Konsis / IDL Forecast must be restarted.

1.4 Documentation

In the subdirectory Doku\Release you will find the following documentations:

  • Technical Installation Instructions
  • Operational Installation Instructions
  • Release Notes

For the currently valid "Hard- and Software Requirements", please refer to the Customer Portal

https://help.insightsoftware.com/s/article/IDL-Hard-and-Software-Requirements (login required).

1.5 Security

TLS 1.3 is used as the communication protocol between the client and the application server. Perfect Forward Secrecy makes it even much more difficult to decrypt the connection at a later date.

Numerous external libraries and the Java runtime environment have been updated.

1.6 Technical Information

The Desktop Client and the Launcher deliver the used JRE (Java Runtime Environment) in the installation directory, so that no separate installation is necessary.

Java 17 has been used since release 22.1.

1.7 Other Notes

1.7.1 Cloud Platform

Authentication and licensing have been extended to allow operation within the Insightsoftware Cloud Platform. The use is in an Early Adopter Program until Release 23.2.

The platform has multifactor authentication (MFA) to increase IT security.

The insightsoftware Platform also guarantees a single sign-on (SSO) to other insightsoftware brands.

1.7.2 User Interface

Further adjustments were made towards a uniform UI for all products of insightsoftware.

1.7.3 French language

The work in French language has been improved.

1.7.4 External libraries

Numerous external libraries were updated to eliminate potential vulnerabilities.

2 IDL Konsis

2.1 Menu authorizations

The following menu items have been deactivated with this release because they have already been replaced by other applications in previous releases. The menu items will be deleted in a subsequent release. Until then, please remove all individual uses (authorizations, menu structures) of these menu items:

  • BSLUAWE - Posting key conversion rule
  • EAICLOCK - Lock intercompany account balances
  • EAICUNLOCK - Unlock intercompany account balances
  • POSKTOPE - Positions+accounts allocation - period

2.2 Master Data

2.2.1 Enhancement of the Chart of Accounts Definition Application (KTODEF)

A set of accounts selected in the table can now be assigned the account with the same number from the associated group chart of accounts via a row action (if available).

For accounts with missing exchange account, a warning is now displayed in the "Open tasks" area. There the problem can also be fixed automatically with a click on the gear icon.

The account table now contains a new column in which an "X" makes it visible whether at least one company account has been assigned to this account.

2.2.2 Changing the operator of a checking rule

The operator can now be changed for an existing check rule and when copying a check rule. If an operator with left and right sides is changed to an operator with only one side, a message is displayed informing that the positions on the side that is no longer required will be deleted.

2.3 Consolidated financial statements

2.3.1 Automatic reversal of a value adjustment as well as its reversal on loans/receivables

A valuation allowance recognized in the separate financial statements for loans or receivables from affiliated companies and their subsequent reversal must be reversed from the group's perspective.

Through an extension of the existing debt consolidation, it is now possible to represent these value adjustments in a correct way. Please contact your consultant for more information!

2.4 Reporting

2.4.1 Voucher classes as report columns

A new report option 'K' (Balance sheet/P&L report with BKL breakdown) is available for balance sheet and P&L reports as well as for cash flow reports.

The following report column definitions are available for this purpose:

  • #CFGBK (Company Cash Flow Report)
  • #CFKBK (Group cash flow report)
  • #NEUBK (Company Balance Sheet/P&L Report)
  • #ROHBK (Group Balance Sheet/P&L Report)

In contrast to the #HB1/2 column option, the HBII postings are displayed in columns per voucher class.

For vouchers/postings to which no voucher class is assigned, the display is as 'NOBKL'.

2.5 Group-wide data exchange

2.5.1 Unloading the report results

If the "Suppress start window" checkbox is set in the "Start import" section of the "Import/Export" options dialog box, the message regarding the unloading of the report results is now displayed anyway. Due to the missing query, the report results were previously always unloaded, and the runtime was unnecessarily prolonged (sometimes considerably).

2.6 Import

2.6.1 Support of foreign language attributes

There was a requirement that certain attributes can also be imported with foreign language values. This requirement was initially implemented for the debit/credit code ("S01") and the period relation ("Z03"). In the application Transformation Groups (UMS), the desired attribute value for the import can be specified in the "Miscellaneous" area (e.g., D instead of S and C instead of H for the debit/credit code). The corresponding conversion group must then be specified during the import.

3 IDL Forecast

3.1 General

3.1.1 Improvement and standardization of the English interface

For a more uniform presentation and for better readability, the English translations have been generally revised.

3.1.2 Technical optimizations

It is now avoided that IDL Forecast creates internal sequence numbers that are too large for processing in IDL Konsis when writing IC balances, controlling balances, or development transactions.

3.2 Planning

3.2.1 Distribution according to reference periods while maintaining the IC/CNT breakdown of the reference periods

In addition to the distribution function according to previous year, it is now also possible to distribute according to the IC (Inter Company) and controlling breakdown of the reference periods and ignore the breakdowns of the source periods.

3.2.2 Creating/Changing ICGP Profile

The ICGP profile (Inter Company Counter Planning) can now be created or changed retrospectively without creating a new scenario.

3.2.3 Scenario Settings Datasheet

Via the statistics tab of the scenario properties, a data sheet can now be created, e.g. for support, which contains settings, statistics, and log entries for the opened scenario and the rule templates.

3.2.4 Creating/Adapting Resolution Components

The 'Number of days' field used to calculate resolution components is now reset for manual changes and the 'Calculate' button is deactivated to avoid accidental overwriting of your own entries.

3.2.5 Control flow: selection boxes

The selection boxes for process and parameters are now sorted alphabetically for a better overview.

3.2.6 Follow-up application "Other development transactions"

The follow-up application has been renamed "transactions" and now leads directly to the capital or development transactions, depending on the account assignment.

3.3 Rules

3.3.1 Marking incorrect assignments in the General Rule

In the wizard for the General Rule, incorrect assignments are now indicated by a red border as in other rules.

3.3.2 All companies for company management

In order to facilitate the selection of many companies, "All companies" can now be selected in the company management via the button.

3.3.3 Financing rule / Investment rule

For financing, different posting keys for borrowing, repayment, interest postings, and interest payment can now be assigned.

3.3.4 Leasing rule

The leasing rule can now also be applied in the Forecast area, not only in the Plan area. The prerequisite for this is that cross-rule rules are not deactivated in the scenario.

3.3.5 Propagation of blocks by rules

Source accounts are no longer automatically locked.

3.4 Plausibility checks

3.4.1 Extended information

In the case of errors during the plausibility check, you will now receive extended information on the cause of the error directly by double-clicking in order to simplify troubleshooting.

These are also displayed when checking for missing accounts as well as for original UKV (function of expense method) accounts in the scenario.

3.4.2 Summation function in the status line

The view of the plausibility check and balance variance display now show their own total of the selected entries, since the sum of the status line only outputs the sum of the values selected in the planning form.

4 IDL Xlslink

4.1 General

In addition to the new features described below, a number of bug fixes and performance improvements have again been incorporated into IDL Xlslink in this release.

4.2 Read function

4.2.1 New fields for read group monitor

The company ID and consolidation type can now be read from the group monitor.

4.2.2 Read function account balances filters by voucher classification

Values from individual closing entries (balance option BUC) can now also be selected by voucher class when reading individual closing account balances.

4.3 Export function

4.3.1 Export PROMAR mandatory fields are marked as such

The fields "Company shipped by", "Closing date actual period", "Fact", "Product group/No.", and "Intercompany " are now marked as mandatory fields in the export function for product margins.

4.3.2 New field and field arrangement in export controlling objects

The export function for controlling objects now also contains the field "Default for consolidation" and the arrangement of the fields has been optimized for better grouping and overview.

Four new fields added to export REPZEI and rearranged

The fields "Restriction of data origin", "font style", "Font size", and "Number of expanded details" have been added to the export function of the report line definitions and rearranged for better overview.

4.3.4 New field Audit per company in export check rules

The export function for check rules now also has an input option for the attribute "Audit per company", which is to be filled with an "X" if required.

Published:

Release Notes 23.1 IDL Konsis, Forecast, Xlslink


Contents


1 General Notes

1.1 About this Release

This documentation describes the changes in IDL Konsis, IDL Forecast, and IDL Xlslink compared to Release 22.3. The minimum requirement for installing this version is the installation of Release 22.3.

The previously released fixpacks are included.

With this release, maintenance for the 22.3 release ends.

1.2 Data Backup

You should make a backup of your database(s) before installing this version.

1.3 Migration

After installation, the release migration for IDL Konsis / IDL Forecast must always be performed first. After logging in, start the release migration via <Start migration now> in the message window. A restart is not necessary, all applications are available afterwards.

You can find the protocol of the migration under the short word KONVERT (right-click on the corresponding migration).

If the migration is not started in this manner, e.g., because the logged-in user lacks authorization, the call of other applications is blocked. The only exceptions are the applications for maintaining the authorization data if the logged-in user does not have authorization to execute the migration due to the use of individual authorization groups. After manual execution of the migration, IDL Konsis / IDL Forecast must be restarted.

1.4 Documentation

In the subdirectory Doku\Release you will find the following documentations:

  • Technical Installation Instructions
  • Operational Installation Instructions
  • Release Notes

For the currently valid "Hard- and Software Requirements", please refer to the Customer Portal

https://help.insightsoftware.com/s/article/IDL-Hard-and-Software-Requirements (login required).

1.5 Security

TLS 1.3 is used as the communication protocol between the client and the application server. Perfect Forward Secrecy makes it even much more difficult to decrypt the connection at a later date.

Numerous external libraries and the Java runtime environment have been updated.

1.6 Technical Information

The Desktop Client and the Launcher deliver the used JRE (Java Runtime Environment) in the installation directory, so that no separate installation is necessary.

Java 17 has been used since release 22.1.

1.7 Other Notes

1.7.1 Cloud Platform

Authentication and licensing have been extended to allow operation within the Insightsoftware Cloud Platform. The use is in an Early Adopter Program until Release 23.2.

The platform has multifactor authentication (MFA) to increase IT security.

The insightsoftware Platform also guarantees a single sign-on (SSO) to other insightsoftware brands.

1.7.2 User Interface

Further adjustments were made towards a uniform UI for all products of insightsoftware.

1.7.3 French language

The work in French language has been improved.

1.7.4 External libraries

Numerous external libraries were updated to eliminate potential vulnerabilities.

2 IDL Konsis

2.1 Menu authorizations

The following menu items have been deactivated with this release because they have already been replaced by other applications in previous releases. The menu items will be deleted in a subsequent release. Until then, please remove all individual uses (authorizations, menu structures) of these menu items:

  • BSLUAWE - Posting key conversion rule
  • EAICLOCK - Lock intercompany account balances
  • EAICUNLOCK - Unlock intercompany account balances
  • POSKTOPE - Positions+accounts allocation - period

2.2 Master Data

2.2.1 Enhancement of the Chart of Accounts Definition Application (KTODEF)

A set of accounts selected in the table can now be assigned the account with the same number from the associated group chart of accounts via a row action (if available).

For accounts with missing exchange account, a warning is now displayed in the "Open tasks" area. There the problem can also be fixed automatically with a click on the gear icon.

The account table now contains a new column in which an "X" makes it visible whether at least one company account has been assigned to this account.

2.2.2 Changing the operator of a checking rule

The operator can now be changed for an existing check rule and when copying a check rule. If an operator with left and right sides is changed to an operator with only one side, a message is displayed informing that the positions on the side that is no longer required will be deleted.

2.3 Consolidated financial statements

2.3.1 Automatic reversal of a value adjustment as well as its reversal on loans/receivables

A valuation allowance recognized in the separate financial statements for loans or receivables from affiliated companies and their subsequent reversal must be reversed from the group's perspective.

Through an extension of the existing debt consolidation, it is now possible to represent these value adjustments in a correct way. Please contact your consultant for more information!

2.4 Reporting

2.4.1 Voucher classes as report columns

A new report option 'K' (Balance sheet/P&L report with BKL breakdown) is available for balance sheet and P&L reports as well as for cash flow reports.

The following report column definitions are available for this purpose:

  • #CFGBK (Company Cash Flow Report)
  • #CFKBK (Group cash flow report)
  • #NEUBK (Company Balance Sheet/P&L Report)
  • #ROHBK (Group Balance Sheet/P&L Report)

In contrast to the #HB1/2 column option, the HBII postings are displayed in columns per voucher class.

For vouchers/postings to which no voucher class is assigned, the display is as 'NOBKL'.

2.5 Group-wide data exchange

2.5.1 Unloading the report results

If the "Suppress start window" checkbox is set in the "Start import" section of the "Import/Export" options dialog box, the message regarding the unloading of the report results is now displayed anyway. Due to the missing query, the report results were previously always unloaded, and the runtime was unnecessarily prolonged (sometimes considerably).

2.6 Import

2.6.1 Support of foreign language attributes

There was a requirement that certain attributes can also be imported with foreign language values. This requirement was initially implemented for the debit/credit code ("S01") and the period relation ("Z03"). In the application Transformation Groups (UMS), the desired attribute value for the import can be specified in the "Miscellaneous" area (e.g., D instead of S and C instead of H for the debit/credit code). The corresponding conversion group must then be specified during the import.

3 IDL Forecast

3.1 General

3.1.1 Improvement and standardization of the English interface

For a more uniform presentation and for better readability, the English translations have been generally revised.

3.1.2 Technical optimizations

It is now avoided that IDL Forecast creates internal sequence numbers that are too large for processing in IDL Konsis when writing IC balances, controlling balances, or development transactions.

3.2 Planning

3.2.1 Distribution according to reference periods while maintaining the IC/CNT breakdown of the reference periods

In addition to the distribution function according to previous year, it is now also possible to distribute according to the IC (Inter Company) and controlling breakdown of the reference periods and ignore the breakdowns of the source periods.

3.2.2 Creating/Changing ICGP Profile

The ICGP profile (Inter Company Counter Planning) can now be created or changed retrospectively without creating a new scenario.

3.2.3 Scenario Settings Datasheet

Via the statistics tab of the scenario properties, a data sheet can now be created, e.g. for support, which contains settings, statistics, and log entries for the opened scenario and the rule templates.

3.2.4 Creating/Adapting Resolution Components

The 'Number of days' field used to calculate resolution components is now reset for manual changes and the 'Calculate' button is deactivated to avoid accidental overwriting of your own entries.

3.2.5 Control flow: selection boxes

The selection boxes for process and parameters are now sorted alphabetically for a better overview.

3.2.6 Follow-up application "Other development transactions"

The follow-up application has been renamed "transactions" and now leads directly to the capital or development transactions, depending on the account assignment.

3.3 Rules

3.3.1 Marking incorrect assignments in the General Rule

In the wizard for the General Rule, incorrect assignments are now indicated by a red border as in other rules.

3.3.2 All companies for company management

In order to facilitate the selection of many companies, "All companies" can now be selected in the company management via the button.

3.3.3 Financing rule / Investment rule

For financing, different posting keys for borrowing, repayment, interest postings, and interest payment can now be assigned.

3.3.4 Leasing rule

The leasing rule can now also be applied in the Forecast area, not only in the Plan area. The prerequisite for this is that cross-rule rules are not deactivated in the scenario.

3.3.5 Propagation of blocks by rules

Source accounts are no longer automatically locked.

3.4 Plausibility checks

3.4.1 Extended information

In the case of errors during the plausibility check, you will now receive extended information on the cause of the error directly by double-clicking in order to simplify troubleshooting.

These are also displayed when checking for missing accounts as well as for original UKV (function of expense method) accounts in the scenario.

3.4.2 Summation function in the status line

The view of the plausibility check and balance variance display now show their own total of the selected entries, since the sum of the status line only outputs the sum of the values selected in the planning form.

4 IDL Xlslink

4.1 General

In addition to the new features described below, a number of bug fixes and performance improvements have again been incorporated into IDL Xlslink in this release.

4.2 Read function

4.2.1 New fields for read group monitor

The company ID and consolidation type can now be read from the group monitor.

4.2.2 Read function account balances filters by voucher classification

Values from individual closing entries (balance option BUC) can now also be selected by voucher class when reading individual closing account balances.

4.3 Export function

4.3.1 Export PROMAR mandatory fields are marked as such

The fields "Company shipped by", "Closing date actual period", "Fact", "Product group/No.", and "Intercompany " are now marked as mandatory fields in the export function for product margins.

4.3.2 New field and field arrangement in export controlling objects

The export function for controlling objects now also contains the field "Default for consolidation" and the arrangement of the fields has been optimized for better grouping and overview.

Four new fields added to export REPZEI and rearranged

The fields "Restriction of data origin", "font style", "Font size", and "Number of expanded details" have been added to the export function of the report line definitions and rearranged for better overview.

4.3.4 New field Audit per company in export check rules

The export function for check rules now also has an input option for the attribute "Audit per company", which is to be filled with an "X" if required.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk