Release Notes

2024.1.0

March 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

The Help Center

Besides a link to the online help, the Help icon at the top right corner of a page now opens the Help Center which contains link to other supporting pages:

  • Help: Opens the context-sensitive help file for the application page in view

  • Getting Started:Launches Embedded Enablement. If you are a subscriber, your Self-Service Implementation materials are delivered; otherwise, you see a preview of the available materials and details about how to become a subscriber.

  • Academy: Opens the Prophix Academy web page where you can sign up or sign in to access the training modules and videos of the applications in the Prophix platform.

  • Community: Takes you the Red Carpet Community page where you can connect with other Prophix customers and product experts.

  • Product Feedback: Opens the Financial Consolidation Feedback page.

  • Request Support: Takes you to the Prophix Help Center.

Merged Exchange Rate pages

In this release the Group > Exchange Rates and the Reports > Standard Reports Currencies pages have been merged and now appear as tabs on the Group > Exchange Rates page.

  • On the Exchange Rates page, we added a new option, , that users can toggle to display either all rows or only the rows with amounts.

  • The link to the Currencies page has been removed from the side navigation menu and the Roles Security page.

  • For updated instructions on adding group exchange rates and printing currency reports, refer to the Currency exchange rates article.

Merged Calculated Accounts pages

The Configuration > System Structures > Accounts > Change Calculated Account Codes page has now been merged with the

Configuration > System Structures > Accounts > Calculated Accounts page:

  • The link to the Change Calculated Account Codes page has been removed from the side navigation menu and the Roles Security page.

  • For updated instructions on how to calculated account codes, refer to the Calculated accounts article.

Merged Accounts pages

The Configuration > System Structures > Accounts > Chart of Accounts page and the Configuration > System Structures > Accounts > Change Account Codes page are now accessible as tabs within the Configuration > System Structures > Accounts > Chart of Accounts page:

   

  • The link to the Change Account Codes page has been removed from the side navigation menu and the Roles Security page.

  • For updated instructions on how to change account codes, refer to the Chart of accounts article.

Add description in several languages on the Chart of Accounts page

Starting with this release, using the new button users can easily select and add description translations to an account in the data language of their choice on the Configuration > System Structures > Accounts > Chart of Accounts page. Users can also review the descriptions in other languages to ensure that they are accurate.

For more information on adding account description translations, refer to the Chart of accounts article.

Export group structure (ownership information)

A new tab, Ownership, was added to the Transfers > Structures > Export page to export group structure or ownership information.

 Note:  Import of group structure information is scheduled for the next release.

For instructions on exporting an Ownership structure, refer to the Export ownership structure section of the Export structures article.

Revised several pages for improved user experience

We made some revisions to improve user experience on the following:

Point of View Criteria page and Validation Rules Report page

On the Configuration > Group Management > Companies > Point of View Criteria and Configuration > System Structures > Validation Rules >Define Reports page, we made the following enhancements:

  • Arrows replace chevrons for copying criteria from one table to another.

  • Error message alerts user if any incorrect usage is detected such as when a user does not make a required selection or entry.

  • Pagination has been replaced by a more user-friendly vertical scroll bar.

  • Placement of the and buttons, along with the Point of View page link on the Point of View Criteria page underwent careful review and optimization.

  • Extra columns and headers have been incorporated into the table for enhanced functionality.

Data Entry /Local Amounts page

On the Data Entry > Manual Data Entry > Local Amounts > Bundle Data Entry page, we made the following UX improvements

  • Added a Gridlines option, , that users can toggle to display data in Excel-style grid lines, providing the entire page with a more modern appearance.

  • Column sizes in the table were adjusted to allocate more space to display information for crucial columns.

  • The Reference Period and Current Period titles at the top of the columns now include a period code.

  • Buttons representing links to Flows, Intercompany, Dimensions, Partner, and Participation pages, previously located in separate columns, have now been consolidated in the Actions column. They have been redesigned using a single character with an optional yellow background to highlight differences to justify. Tool tips provide explanations upon hovering over the new buttons.

Consolidation Adjustment report

On the Reports > Standard Reports > Consolidation Adjustments page, we added a new option, Split Journal by Category, to display various Journal Types on separate sheets in the Excel output file, or have them separated by a page-break in the PDF output file. The option is applicable to the Detailed with Flows and Detailed with Dimensions reports.

Resolved issues

The following are the issues we resolved in this release:

Released Ticket Number Area Description
March 157115 Transfers > Data > Import Data

The import data process was timing out before data was completely imported.
  161250 Data Entry > Manual Data Entry > Intercompanies Adding an intercompany transaction in EUR currency triggered an error.
  161272

Reports > Standard Reports > Consolidation

Flows

During the consolidation process, company employing the “Not Consolidated” method experienced an issue where the correct flow in the liaison account (at the holding company) was not displayed. Rather than F06 (exit flow), the process generated the interrogation mark ? flow.
  161492 Configuration > System Structures > Bundles > Offline Templates

Consolidator was unable to download existing offline templates. The button was not responsive.
  161611 Reports > Standard Reports > Consolidated Figures The Difference amount was blank even when the reference period was provided. Also, in instances where the Difference amount was displayed, it was not accurately calculated.
  162247 Consolidation > Consolidation > Intercompany Matching Rules on Intercompany Matching report were not sorted in the correct order.
  162667 Consolidation > Consolidation > Intercompany Matching

When using the Merge Debit/Credit option to generate a report, the report failed to display the Difference amount for the pair of companies
  162729 Configuration > System Structures > Events > Create Custom Events

When All Entering Partners was chosen as the Selection Method, and the shareholder was the parent company, events were not being generated.

  164282 Bundle/ Consolidation Adjustment

Transaction rate flow issues occurred as a result of the disparity in the number of decimal places between the Bundle Entry forms with six decimals and the Exchange Rates currency structure with 12 decimals.

Moreover, in the Bundle, automatic flows did not take into account the specified transaction currency with 12 decimals.
  161130, 165562, 165559 Consolidation > Events > Generate Events Users encountered a timeout error when trying to generate events.
  164949 Consolidation > Validation Reports > Bundle Validation Validation error count was missing on the Consolidation Bundle validation report.
 

164948, 164955, 164896,

166202,

166203

 Data Entry > Manual Data Entry > Local Adjustments > Manual Input End users were not able to post local adjustments. Their effort to do so was throwing an error: User has not access to journal ‘L001’.
  165140 Reports > Drill-Down Analysis > User Reports User was unable to choose criteria for a Point of View.
  165424 Data Entry > Manual Data Entry > Local Amounts > Bundle Data Entry - Multi Period Monthly data entered in Multi-period input form was not retained on the page and input figures were being replaced with different values.
  165026 Transfers > OLAP > Cube Definition When executing an OLAP Export job for an account configured with Account Type of Other, the system failed to capture the corresponding account details in the export.
  164966 Reports > Pivot Reports > Define Pivot Reports > Run Reports Using the Account Type filter for a pivot report was not functioning as expected.
  164965 Administration > Security Following SaaS migration, Restricted access setting was not carried over for users.
  164521 Configuration > Analytical Dimensions > Dimension Report On the Dimensions Report, the accounts that were associated with a dimension were missing.
  163960 Group > Companies Despite not choosing the Calculate deferred tax option, the tax value was still considered in the adjustments.
  163464 Group > Periods > Define Periods

In the current period, upon changing the reference period in the Ref Period field, the Parent Company drop-down list failed to show the expected list of companies from the current period. Instead, it displayed the list of companies from the reference period.
  163696 Report > User Report > User Report When creating Excel reports, a single Excel sheet with all companies was produced instead of separate sheets for each company.
  162190 Data Entry While entering data, rounding of unjustified difference amounts was observed, but upon saving, the accurate and precise entered amount was correctly displayed.
  161402 Adjustments > View > Manual Entry

The user could alter an adjustment number linked to an existing journal number, and the application permitted the use of identical numbers for different journals.
  162940 Reports > Standard Reports > Intercompany Reconciliation Report Using the Merge Debit/ Credit option to generate a report did not combine matching data from both companies as anticipated.
 

161674

161774

166336

 Excel Add-in

The Excel add-in refresh was causing significant delays, slowing down the consolidation process.
  163034 Reports > User Reports > User Reports Page breaks did not occur where they were expected on reports.
  161614 Consolidation > Validation Reports > Bundle Validation Downloaded reports contained a single sheet with all companies instead of separate sheets for each company.
  161732 Configuration > Group Management > Companies > Point of View Criteria When selecting companies from multiple pages and applying a criterion, only the companies on the last page were modified.
  161861 Reports > Analysis Reports > Accounts

Pivot table did not display all the data in the data range specified.
  161924 Reports > Standard Reports > Consolidation Adjustments Adjustments for various journals were printed on one sheet instead of being separated into different worksheets, making it challenging to find specific journals.
  161102 Configuration > System Structures > Consolidation Eliminations Despite activating Consolidation Elimination S082, the Elimination Details page remained unpopulated.
  161040 Adjustments > View > Manual Input The (Diff sign) was malfunctioning due to the culture info: 'ca-ES : 1.234,56 ; 31/12/1999'.
  161478 Consolidation > Consolidation > Intercompany Matching Companies listed in the Select a Company pop-up window were not sorted alphanumerically.
  155041 All General Ledger pages Figures in the Current Amount and Reference Amount columns were not right-aligned.
  160941 Adjustments > View > Manual Input Journal entry was saved even when both the company and partner were the same entity.
  160954 Adjustments > View > Manual Input When creating an adjustment for journal M001, the application showed an error indicating duplicate entry, even though there was no existing adjustment entry for the journal.
  161126 Reports > Standard Reports > Companies Hidden empty columns were impeding user’s ability to apply column filters.
  161197 Configuration > System Structures > Copy Structures During the copy structure process, errors occurred due to eliminations being copied before accounts and journals, thereby obstructing the copy process.
  161128 Configuration > Group Management > Companies > Point of View Report

Due to the single-page display of POV trees instead of tabs for different trees, POV Tree codes did not appear on reports.
  159002 Transfers > OLAP > Cube Definition In Excel, dimension data was duplicated in OLAP data after export.
  159023 Transfers > Data > Data Import

Using (-) minus or (.) dots in some local accounts resulted in generating an error with an ID code instead of a PDF file listing unmapped accounts.
  159993   The end user could still edit the company data in the data entry form after the company status was changed to Confirmed on the dashboard.
  160301 Configuration > System Structures > System Validation Validation report included all field and not only the fields selected.
  159530 Transfers > Data > Import Data

A blank PDF file was generated when on the uploaded file 'From row' is selected as '1' with header details.

  159827 Reports > Drill Down Analysis > User Reports When doing a drill down analysis, user could not filter the last row by Point of View.
  160228 Group > Periods > Define Periods Locked periods were being automatically unlocked by the system.
  158227 Transfers > Exchange Rates > Import Exchange Rates Error occurred when importing exchange rate using non-CSV as a data source.
  157146 Configuration > System Structures > Events > Create Custom Events Unable to delete elimination event without deleting all the event details first.
  155947 Configuration > System Structures > Intercompany > Define IC Rules When doing a Bundle IC validation and using the threshold, a negative difference was wrongly considered as OK.
  155963 Data Entry > Manual Data Entry > Local Adjustments > View > Manual Input Local adjustments created with 'CarryForward and Keep P&L' option are generating unbalanced local adjustment in the next period.
  156540 Reports > Standard Reports > Consolidation Adjustments Long text added to journal entry was causing an error when attempting to retrieve a report.
  156350 Administration > Content Panels Validation report not properly formatted.
  158156 Configuration > Analytical Dimensions > Dimension Groups Using Code and Description filters did not fetch the desired data.
  158592 Transfers > OLAP > Cube Definition Accounts in different periods looked similar but were not getting published.
    Automation > Job > Schedules Running the Copy structure job generated an error.
  159005 Configuration > Group Management > Companies > Point of View Criteria Unable to select all companies because the checkbox was missing.
  159062 Transfers > OLAP > Cube Definition Unable to export OLAP cube for a closed period even when 'Include Closed Periods' was selected.
  159159 Configuration > Periods Management > Define Natures Deleting a Nature triggered error FK_TS018S3_TS096N0 and no system logs were generated for the error.
  160942 Transfers > Structures > Import The import Mapping Table process was stuck and could not be completed.
 

161256

 Configuration > System Structures > Bundles > Offline Templates Consolidator was unable to upload an offline bundle template.
  161487 Consolidation > Consolidation > Intercompany Matching > Pilot Report Intercompany Rule codes column missing on page.
  161733 Configuration > Group Management > Companies > Point of View Criteria Filters did not display expected results.
  161623 Reports > Standard Reports > Bundle Last Modified The restored bundle last modified report was not correct.
    Configuration > Group Management > Companies > Point of View Criteria User was unable to save changes made on the page.
  161658 Data Entry > Manual Data Entry > Analytical Dimensions Companies not sorted alphabetically on the page.
  161728 Configuration > Group Management > Companies > Point of View Criteria Grid issues were observed on this page, tables were split into columns without correct headers.
  161208 Adjustments > Manage Adjustments An unexpected error occurred while importing adjustments.
  161605 Reports > Standard Reports > Local Bundles Journals for all companies were displayed on just one worksheet instead of one sheet per company.
  163014 Reports > User Reports > User Reports User reports were printed on one Excel worksheet.
  161806 Data Entry >Validation Reports > Bundle Validation Application was selecting entity by default.
  162559 Reports > User Reports > Define User Reports > User Report Definition - Cash Flow Calculated flows sign “-” not working as expected.
  162328 Automation > Jobs > Schedules “Scheduled” filter not working.
  163810 Consolidation French translation of buttons incorrect.
  163807 Events French translation of buttons incorrect.
  163802 Data Entry Error sign displayed on the Data Entry pages for Dimensions, Flows and Interco, even when there was no difference to justify.
  163386 Administration > Security > Roles Security Issues with Restricted Consolidator role.
  162656 Transfers > Data > Import Data

Despite a successful data import, error messages were displayed.
  162807 Reports > Pivot Reports > Define Pivot Reports > Run Reports Issues were observed with Pivot report.
  163871 Transfers > Data > Import Data No data on Import Data report.

Known issues

Area Description Workaround
Adjustments > Manual Input > Analytical Dimensions

End users cannot update values as the input fields and button remain unavailable in the pop-up panel.

User with Consolidator role can perform the update. An upcoming release will address the issue.
Reports > Drill-Down Analysis > Shareholder Analysis On the Shareholder Analysis page a user with Restricted Consolidator role can see all companies including those they were not granted access. The workaround is to remove access to this page for the restricted roles. An upcoming release will address the issue.
Workflows There is no size limit to the text that can be entered in the Comment area of the Workflows page, opening the possibility to overload the database and impact the performance. No workaround. An upcoming release will address the issue.
Analysis Reports The Account X Flows report displays an amount in reverse sign when a calculated account that is used by assets contains a liability account (credit). No workaround. An upcoming release will address the issue.
Consolidation Reports

Consolidation reports in XLS format features all companies on one sheet instead of one company per sheet. However, when the PDF format is chosen, companies are appropriately separated by a page break.

 No workaround. An upcoming release will address the issue.
Data Entry > Bundle Validation Executing the Bundle Validation report on the DATA ENTRY > VALIDATION REPORTS > BUNDLE VALIDATION page might yield inaccurate outcomes, such as presenting a closing amount on the Left side instead of the expected intercompany transaction. Remove the accounts set for the validation rule details and then add them again. An upcoming release will address the issue.
Data Entry > Bundle Validation Running the Bundle Validation report on DATA ENTRY > VALIDATION REPORTS > BUNDLE VALIDATION page might produce incorrect and inconsistent results, such as displaying an inaccurate number of errors, failing to update updated amounts, and corrupting the error count on the Content Panel. First, run the Consolidation > Consolidation > Integrate Bundles process and then, run the Validation Report on the Contents Panel /Dashboard. An upcoming release will address the issue.