Release Notes 23.1 IDL Konsis, Forecast, Xlslink
Contents
- 1 General Notes
- 2 IDL Konsis
- 3 IDL Forecast
- 3.1 General
- 3.2 Planning
- 3.2.1 Distribution according to reference periods while maintaining the IC/CNT breakdown of the reference periods
- 3.2.2 Creating/Changing ICGP Profile
- 3.2.3 Scenario Settings Datasheet
- 3.2.4 Creating/Adapting Resolution Components
- 3.2.5 Control flow: selection boxes
- 3.2.6 Follow-up application "Other development transactions"
- 3.3 Rules
- 3.4 Plausibility checks
- 4 IDL Xlslink
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.