Release Notes

2024.3.0

August 2024

Release notes describe the enhancements and bug fixes contained in new releases and maintenance releases for Prophix Cloud deployment only.

 Tip:   To find the release note that contains a specific issue, search on the Prophix Support Desk ticket number.

What’s new

Import exchange rates directly from the Monetary Authority of Singapore

Import of exchange rates from the Monetary Authority of Singapore (MAS) is supported and customers in the Asian-Pacific region (APAC) can now import exchange rates for their local currencies.

New job type: Export for external applications

A new job type, Export for External Application, is included in this release. It allows customers to access and process data stored in the Financial Consolidation database within their own applications. This feature is available under Automation > Jobs > Scheduler and provides a drop-down list of standard data types, enabling users to select the necessary queries.

Available data types include:

  • Consolidation Data

  • Consolidation Data with Flows

  • Chart of Accounts

  • List of Companies

  • List of Periods

  • Group Structure

  • Cube Data

  • Currencies

  • Currency Rates

  • Finance Adjustments

  • Client Period Entity

These data types can be executed or scheduled through a Data Integration task, with the output data being stored in a table within the staging database of the Prophix Cloud platform. A subsequent Data Integration task can then transfer the data to the customer’s application.

Additional features include optional filtering and the ability to set the staging table name.

For more information on exporting data for external applications, refer to the Export data for external applications article.

Export configuration settings

Users can now export all configuration settings from the Administration > System Administration > Configuration page. This feature is especially useful for making comparisons, performing validations, and duplicating configuration settings for new installations, and archiving configuration settings.

Administrators have the options to:

  • Extract settings from either a current tab or from all tabs.

  • Export to either a PDF or an Excel file.

For more information on exporting configuration settings, refer to the Export system settings section of the System Configuration article.

Email notification for Backup jobs

An option to set up email notifications for scheduled backup completions is now available on the Automation > Jobs > Schedules page. Administrators can use email notifications to follow up on the execution of Backup jobs without having to log in daily into the application.

Administrators can:

  • Choose to receive email notifications for successful executions, failures, or both.

  • Select other email recipients from the list of administrators.

Enhanced Dimension information view for reference periods

Clicking the active button in the table of the Adjustments > View > Manual Input page now displays analytical dimension information for the Reference Period.

 Note:  Except for the Dimension Group field, all the information presented is read-only.

Local Bundles Report: Specify Journal Entry for Local adjustments

Users can now specify a Journal Entry for Local Adjustments to narrow down the resulting data on the Reports > Standard Reports > Local Adjustmentspage.

  • Provides a more granular and focused report.

  • Enhances options for printing and archiving.

  • Allows comparison and verification with data from the Local Adjustments View page.

Import Mapping Table update: Source Code description now included

The Import process now supports both the Target and Source Code descriptions (in Release 24.2.0, we made a similar improvement to the Export process).

When uploading and importing a Mapping Tables export file on the Transfers > Structures > Import > Mapping Tables page, the Source Code Description is now included. However, the Target Code Description cannot be changed or modified through import.

Company Code management: New editable fields, improved navigation, and import /export features

The following updates were made to Change Company Codes page:

  • The Change Company Code page has been relocated to a tab on the Group > Companies page. Previously, it was located in the menu: Configuration > Group Management > Companies > Change Company Codes. This positions the Change Company Code page next to the Companies page where companies are added to the application.

  • The Code field is now editable, aligning with the updates made for the Chart of Accounts and Calculated Accounts pages. The same validation for disallowed characters remains in place. Additionally, customers can update the Description field both on the page and in the exported file.

  • The Description column has been divided into two separate columns: Description and New Description.

  • Export and Import functions are now available. This new functionality enables users to edit and update Company Codes and Descriptions for multiple companies in Excel, and then upload the modified file back into the application.

For more information on managing company codes, refer to the Change company codes section of the Add Companies article.

Calculated Accounts: New filters, improved management, and new Summation Accounts Report tab

The following enhancements were made to the Configuration > System Structures > Accounts > Calculated Accounts page:

  • On the Tree View tab, Type and Actions titles were added to the last two columns to make it easier for users to identify these columns.

  • Filters are now available in the Type column. Users can filter calculated accounts by A (Account) and S (Summation) types.

  • On the Change codes tab, the Description column has been split into two separate columns: one for the current description and one for the new description. Users can also update calculated account codes on this tab.

  • The Summations Accounts Reports page (formerly known as the Calculated Accounts Report) has been moved to a new tab on the Calculated Accounts page. Previously, this page was accessible from the navigation pane under Configuration > System Structures. Additionally, we have replaced the term “calculated” with “summation” to better reflect the purpose of the account.

Chart of Accounts: Enhanced account code management and new Account Reports tab

The following enhancements were made to the Configuration > System Structures > Accounts > Chart of Accounts page:

  • Export and import of account codes using Excel is now available on the Change account codes tab. Customers can export multiple account codes and descriptions, update in Excel and then, upload the modified file back into the application.
    Furthermore, there are now two columns for the description: one for the current description and one for the new description.

    For additional information on importing and exporting account codes, refer to the Change account codes section of the Chart of Accounts article.

  • The Account Reports page is now a tab on the Chart of Accounts page. Prior to this change, the Account Reports page was accessible via the System Structures menu in the navigation pane.

    For additional information on printing account reports , refer to the Generate account reports section of the Chart of Accounts article.

Intercompany Matching page redesign

The tables for Debit and Credit companies on the Consolidation > Consolidation > Intercompany Matching page was redesigned with improved column titles to help users recognize the different sections and respective data. Additionally, an Account Description column was added to the table.

Line limit for additional information

On the Configuration > Group Management > Companies > Define Additional Info page, the maximum number of lines allowed for additional information has been limited to fifteen (15).

  • This limit ensures that the additional information provided on this page is compatible with the export and import functionality.

  • A persistent reminder is displayed across the page to inform users not to exceed the 15-line limit.

The elements and icons on this page have also been enhanced to provide a better user experience.

Renamed Minority% and Minority Interests field labels

On the following pages, the Minority % and Minority Interests labels have been replaced with Non-Controlling Interests % and Non-Controlling Interests to better describe these fields:

  • Group > Companies

  • Configuration > System Structures > Consolidation Eliminations > Consolidation Eliminations

  • Configuration > System Structures > Accounts > Chart of Accounts > Specific Accounts

Exchange Rates: Titles added to the period columns

On the Group > Exchange Rates page, rates corresponding to the Current Period and those for the Reference Period are now clearly indicated.

Resolved issues

The following are the issues we resolved in this release:

Released Ticket Number Area Description
  178454, 178703, 178463 Consolidation Journal M300 was created at the subgroup level despite not being selected under Configuration > System structures > Journals > Define views.
  161791 Exchange Rates When retrieving the exchange rates for EUR and USD currencies, rates were reversed
  164522 Role Security Checkbox for “Transfers” disabled on trying to enable and save for Restricted user “Write” access.
  167475 Administration > Job > Schedules Scheduled Backup job triggered an error but there was no error in the system log.
  168795 Validation Rules Space in the dimension code prevented Validation rules from being created for the dimension.
  168858 Reports > Standard Reports > Consolidation Flows Account name description appeared as “??? ???” on the report.
  168963 Adjustments > View > Manual Input Despite not having the permission to edit adjustments, end user was able delete an adjustment that was already “Confirmed”.
  169100 Date Entry > Manual Data Entry > Local Amounts

On the Bundle Data Entry -Standard page, the following issues were observed in the content of the table:

  • “Non-Current Assets” displayed in the results of every filter.

  • “Total PPE” displayed for accounts that were part of the calculated account

  • “See only lines with participation differences” displayed accounts that were fully justified.
  169419 Group > Company Changes made to the main group not reflecting at sub groups.
  169501 Content Panels After downloading a validation report and opening it in a browser tab, users were unable to scroll through the validation report errors.
  169589 Transfers > Data > Export Data Journal Description and Journal Entry did not display correctly for “Contribution” data export done using the HUB.
  169806 Automation Scheduler: Export to reporting solution job not working.
  170412 Create Custom Events

When generating an event journal, the application used existing journal entry numbers instead of the next available journal entry.
  170601 Data Entry> Manual Data Entry > Partners Unable to enter Dimension detail per account, per partner, on Partner accounts.
  170806 Reports > Standard Reports > Bundle Last Modified Currency displayed on the Bundle Last Modified report not the same as the currency in the period.
  170820 Adjustments > View > Manual Input Journal entry not displaying as expected.
  170909 Reports > Standard Reports > Consolidation adjustments End user could not generate local adjustment report.
  171388 Consolidation > Events > Generate Events

Journal entries generated out of sequential order, the journal entry numbers were not incremental.
  171389 User Reports Negative sign did not display in the Modular Contribution by POV report.
  171598 Import Data

The amount displayed on the Data Entry page after an import was still significantly higher than the uploaded amount after the script provided was applied
  171603 Adjustments

Adjustments carried forward from a reference period to the working period not calculated correctly.
  172004 Roles Security Restricted End user able to add adjustment.
  172290 User Reports

User reports included page breaks not defined in the report definition.
  172883 Adjustments > View > Manual Input Debit and credit values in the technical adjustments T094 generated did not tally.
  172976 Data Entry > Manual Data Entry > Flows Historical rates showed rounded figure for subgroup period (different from the main group’s).
  173272 Data Entry > Validation Reports > Intercompany Validation

When using the “Merge debit/credit” function, merged data did not show in the Intercompany Validation report.

  173768 Group > Periods > Define Periods The Closing date changed upon saving when the months February, April, June, or September were used for the Date and Closing date.
  173936 Configuration > System Structures > Copy Structure Copying the structure for IC rules did not transfer the entire IC rules configuration.
  174165

Reports > User Reports > Define User Reports

Flow report not available in release 2024.2.0.5.
  174465 Transfers > Adjustments > Import Adjustments

The “Overwrite Journals Known in File” option did not overwrite the journals with those provided in the file. Instead, it added them to the adjustments.

August 2024 178447, 178463 Adjustments > View > Manual Input Manual adjustments were lost when consolidation was run at the subgroup level.
  178540 Transfers > Adjustments > Import Adjustments Uploading adjustments at the subgroup level triggered an arithmetic overflow error.
  171604,171654 Chart of Accounts Account codes with special character “_” (underscore), generated an error.

Known issues

Area Description Workaround
Reports > User Reports User Report “Company X Account” does not display the name of the companies. No workaround. An upcoming release will address the issue
Group > Companies Non-Controlling Interest percentages are changed in Equity and Not Consolidated methods, when a company changes its method from ‘Not Consolidated’ to ‘Equity’ No workaround. An upcoming release will address the issue
Data Entry > Manual Data Entry > Local Amounts The manual Input Form fails to load, appears to be stuck. No workaround. An upcoming release will address the issue