Reservation management behind parameter

Feature ID: FPS-10343

A new environment parameter InputReservationManagement has been implemented. The administrator can set the parameter value to 'true' or 'false'. If the parameter value is set to 'false', no warnings appear when the same template is opened by different users or different templates are opened with same selections by different users. Also, users can save the changes.

If the parameter value is set to 'true', reservations work and warnings appear when the same template are opened by different users or different templates are opened with same selections. Also entries appear in the Reservations management view, and the administrator can delete them manually. Closing of the template also deletes the reservation.

By default, the parameter value is set to 'false'.

Clausion FPM Web Client: Search for templates (custom, input and report)

Feature ID: FPS-9464

When a template is opened in FPM Web Client, the user can now search from the template content. Use Ctrl+F to open the search dialogue box.

Clausion FPM Web Client: New features in templates in FPM Web Client

Feature ID: FPS-8846

In a template opened in the FPM Web Client the graphs defined in Excel are now shown. Note that the graph will be visible only when moving the pointer over the navigation bar. In addition, it has been noted that the waterfall graph is not supported in the Web Client spreadsheet component.

Also, cell data validation drop-down functionality now shows in web templates. 

User interface management: List available datatypes in task selections

Feature ID: FPS-4622

It is now possible to restrict the datatypes available for end user in task selections

1. New datatype list option has been implemented for data type component in user interface task settings.
2. Only the datatypes listed in task settings are available in the tasks selection screens in Data type drop-down list in Clausion FPM Web Client and Desktop Client.

Example templates mentioned in user guidance added to the Clausion FPM system

Feature ID: FPS-11457

Example templates, that are described in the renewed user guidance for template management, are now available in each FPM environment. UI definitions also exist, all included in the Examples UI block (block name: Example Templates). The folder name shown in the navigation (root folder of the block) is Example Input and Report Templates.

The new UI block is not automatically attached to any role. Attach it using User Role UI task, if you wish to self-study template management using these examples. Note that the templates include defined account, dimension, and unit codes, and thus most likely modification is needed in your environment before they may be opened. More information is found in administrator's guidance.

Maintaining period start and end dates to Clausion FPM default tasks and Clausion FPM Package yearly tasks to separate UI blocks

Feature ID: FPS-11226

Package yearly tasks included opening balance and cash flow opening document tasks. These were added in Package update that previously was done immediately after Clausion FPM update. Now that the updates no longer are forced together this structure is changed to avoid package tasks from disappearing in FPM update. These package tasks are moved to separate package specific blocks.

Also the task for maintaining period start and end dates is now part of default Clausion FPM tasks.

A separate package task for "Input Data Calculation, All Documents" have also been removed. In the future, the document series for the basic FPM task of calculating the input data are by default from the data of the global parameter (ALLDOCS). It is recommended to add list of all document series in the environment as value of the new parameter, thus getting all series calculated by default. List of package series is included in Package release material, and can be copied from there in phase when parameters are updated.

Layout and formatting improvements of default templates

Feature ID: FPS-10827

Colouring of the default templates has been renewed to lighter than earlier. In many places, the colour has been removed from the title rows. There are no longer differences in the colours between the input and report templates.

At the same time, in the Excel files other formattings that have no essential or any effect on the functionality of the templates, have been changed. For example:

• Datatypeusage data and utilizing the data have been enhanced on the Changes in Non-Current Assets and Continuity Check (FAS) and Consolidated Financial Statement (FAS) reports
• Formattings of single cells have been changed to conditional formatting on the Package default templates:
  • Fixed value in the datatypeusage column on the title rows, whereupon the same formatting applies as for the sum levels
  • In the FAS templates, datatypeusage="not in use" in use to format "only IFRS" account rows. Because of this, in the Clausion IFRS the FAS template has no special formatting for these.
• Excel files of the templates where columns are added by generation (e.g. units), no longer include several formatted columns, because the latest FPM version copies formatting to the generated columns.

Clausion FPM Web Client: Color theme renewed

Feature ID: FPS-10373

Clausion FPM Web Client color theme has been renewed, and some minor styling has been updated (for example, button corners and tooltips).

User Interface Management enhancements

Feature ID: FPS-4615

In user interface management functionality in the Clausion FPM Desktop Client it is now possible to:

• Move tasks from one folder to another within one UI block
• Copy a "Task" item as a new within one UI Block

Row sets for retrievefromdata report templates: Conditional row set logical implementation

Feature ID: FPS-4040

Conditional row set can be used in retrievefromdata type report templates. For example, it is possible to use an Excel formula to validate if the rows are visible with certain row set selection.

For example, in a reconciliation report, user may show all the reconciliation differences that are bigger than a certain tolerance value that the administrator has defined.

Do the following when adding row set definitions and formula to Excel definition file of the template:

• Add row set names right after (to the right from) the ACCCODE cell. (same as in predefined templates)
• Add the formula to define if X is the value (means row included in the row set) to the row set column below the row set name
  • Note that the formula must start with '=' to work as expected.

• Copy the formula to all rows that might have data in the opened template. If data is brought to more rows, the rowset filtering does not work on rows where the formula does not exist in Excel (the template opening does not copy the formula to all data rows)

Note: The ACCCODE naming in the template must follow the order of the sheets; ACCCCODE1 in first sheet, ACCCODE2 in second sheet etc. The naming has been corrected in the following default templates: BW_RT103, BW_RT105, BW_IT501 and BW_IT601. Note also, that the latter two are input templates, where the new rowset functionality does not apply.

XBRL UI example available in user interface management

Feature ID: FPS-3139

The option "XBRL report" is now available in User Interface Management in Clausion FPM Desktop Client, when the parameter element is selected, and no tree exists under it (previously implemented functionality).

Note that using this task requires XBRL licence.

Clausion DR: Replacing formulas with values

Feature ID: FPS-2580

Clausion DR for FPM users often share DR report files with other users who do not have access to Clausion FPM or DR. When a non-DR user receives the Excel file, Excel usually converts the DR formulas with hash values. Also, if a non-DR user tries to open the Excel file and edits anything, for example, opens hidden rows, all values are converted to hash values. In this case the DR user must replace DR formulas manually with values before sharing the Excel file to a non-DR user, which takes some time and is not fast enough. In addition, there is a possibility that a user may save changes and thus by accident remove all the formulas.

Now a functionality has been implemented, which enables the DR user to create a copy of the existing Excel file with the same data in the file but without any formulas. When the user clicks the "Create Static Copy" button on the DR tab, it creates and opens a new Excel workbook with all the existing data and removes all formulas (for example, DR formula and any Excel formula). The user can save the newly created Excel workbook and also share it to a non-DR user.