Introduction

This document includes information about the new features, other improvements, and corrected known issues implemented in the Clausion FPM 23.10 general availability version.

The previous general availability release is Clausion 23.10.

New Features and Other Improvements

Data Uploader: Importing IC items to external accounts not supported

Feature ID: FD-12077

If you try to upload an internal item to an external account you get an error and the item is not saved.

Web Client: The option to set a scheduled message to display on the header

Feature ID: FD-11119

As an administrator user, you can configure Maintenance messages and a schedule them to display on required dates. An activated Maintenance message is displayed on the header when you open tasks on the left tree view navigation pane. You can continue to use Web Client when the message is displayed. You can add the Maintenance task anywhere in the User Interface. When adding a new task, just select MaintenanceMNT as the Folder/Task ID in Folder/Task Settings. You can edit the message settings when opening the Maintenance task.You can write the message in different languages (en, fi, sv) in the according language text fields depending your language selections. Please note that all the provided language fields must include content. The maximum length for the message is 200 characters. Set the message active with the On/Off toggle switch and set the Start Date and End Date for its display. When you are finished, click Save. If settings are missing or they are incorrect, you get a validation message.

Web Client: Copying zeroes (0) from cell to cell with input templates

Feature ID: FD-10418

You can now copy zero (0) value to input sheet in Web Client similarly to Desktop Client. You can also copy multiple cells with copy and paste function. If the cells are locked, they cannot be copied. Note! The copy and paste function works only when using either mouse or keyboard actions. For example, the function does not work if you right-click the mouse to copy a cell and then paste it with the keyboard shortcut CTRL+V.

Web Client: A new feature to automatically open Management and Admin tasks or any Input or Report sheet using new component in User Interface Management.

Feature ID: FD-10343

In Web Client, you can directly open Management tasks like Data Uploader and XBRL Management simply by clicking on the task in the left navigation tree tiew window. Earlier you would have had to click the Open button. You can also use the feature to open automatically any Input, Report or Custom Sheet by clicking the relevant task from left navigation tree view window. This feature is enabled by a new parameter called opentask with value automatic. You can add the parameter in User Interface Management on Desktop Client. Navigate to outlookparameters section and and add opentask parameter under outlookparameter and set the value to automatic. Please note that even though this feature is set in Desktop Client, it is applicable only to Web Client.

Web Client/Data Uploader: Database change: search and transfer by any similar source filename or part of it (Wildcard feature)

Feature ID: FD-10156

In Data Uploader in Web Client, you can use the wildcard feature (using the asterisk character in a search term) to define the beginning of the integration filename. This enables you to import several integration files with the same integration run. For example, when you define SAP* in the integration definitions, individual transfer files SAP10 and SAP20 can be imported with same integration run.

Data Uploader: A new #FILEMOVE parameter

Feature ID: FD-9249

In Data Uploader, you can now use a new #FILEMOVE parameter to move files to a new folder after an integration run. Please note that the integration status must be either Completed (successful) or Completed with errors.
In addition, please mind the following while using the #FILEMOVE parameter:

  1. You must add the #FILEMOVE parameter in the FILESTEP after the #FILE parameter.
  2. Use the following format: #FILEMOVE=History/SAPSALDOT*_%TIMESTAMP_INT%.csv. where after the equals sign, comes the folder name; after the forward slash, the file name or file name prefix with the wildcard asterisk character; and if you want, after the underscore character, the %TIMESTAMP_INT% timestamp parameter.
  3. It is mandatory to use the forward slash “/” after the folder name and the underscore character “_” between the filename or wildcard prefix and the %TIMESTAMP_INT%.
  4. You can add the %TIMESTAMP_INT% parameter. If not added, the file moves to the new folder without the time and date value as a suffix.
  5. The value of the #FILE parameter and the filename or wildcard prefix in the #FILEMOVE parameter must match. For example, if #FILE parameter has value #FILE=Te*.csv, then #FILEMOVE parameter must also include “Te*.csv” in its value, for example, #FILEMOVE=history/Te*.csv.
  6. You can use any name for the folder. If the folder does not exists, a new folder with the name you have inserted for it is created automatically.
  7. If the timestamp is in invalid format or if #FILE parameter does not match the #FILEMOVE parameter filename value, you receive an error message.
An example of a complete FILE STEP where the wildcard functionality and the #FILEMOVE parameter are used:[integration].[FM_INTEGRATIONPRERAW_STANDARD_%DATATYPE%] @INTEGRATION_UDID=%INTEGRATION_UDID% @INTEGRATIONRUN_GUID=%INTEGRATIONRUN_GUID% @MAPPING_UDID=%MAPPING% #TABLE=integration.FMINTEGRATIONPRERAW%INTEGRATION_UDID% #FILE=Test*.csv #FILEMOVE=history1/Test*_%TIMESTAMP_INT%.csv #FILEHEADERTYPE=MappingTable

Desktop Client: %INCLUDE ALL DIMENSIONS% parameter to input and report User Interface Tasks

Feature ID: FD-7908

%INCLUDE ALL DIMENSIONS% parameter has been added to input and report templates in Desktop Client, similarly to Web Client functionality. %INCLUDE ALL DIMENSIONS% is a parameter that when inserted in input and report templates, retrieves the dimensions defined in the <dimensioncount> user interface parameter and displays them on the templates. The default value of the dimensions retrieved by %INCLUDE ALL DIMENSIONS% is BWAllocatedItem for input templates and for report template, the top or the first unit. If you have defined a value for the dimension 00 with the home unit parameter, or if a dimension value has been added to a component in the user interface, those values overwrite the default values.

Corrected Known Issues

Issue ID

Issue

Resolution

FD-10784

Delete source data does not apply to Internal Data Transfer (IDT) with extra fields anymore

You can execute IDT with the option ‘Delete source data’ without any issues. Now data from the source extra fields, which are selected in the selection screen, gets deleted from the database.

FD-10531

Web Client: Saving when column count varies in different areas of the sheet

In Web Client, you can now save and retrieve the data when there are several areas and column count is different in each area.

FD-10428

Web Client: Executing input template calculation successfully

You can execute input template calculation with expected results without receiving the error message "Unable to cast object of type 'System.InvalidOperationException' to type 'System.TypeInitializationException'.”

FD-9863

Web Client: Incorrect column widths in multiple data columns

In Web Client, data columns in reports including generation and normal columns now appear in correct format similarly to Desktop Client.

FD-9831

Data Uploader: Uploading large files successfully

You can now upload even large, e.g. 2 GB in size, CSV files with Data Uploader without receiving an error message. However, if you upload files around the size of 2 GB, you need to increase the timeout value in IntegrationExecutorService.exe.config file. The default timeout value is 900 seconds.