Skip to main content

Version 9.4

July 9, 2020

Improvements​

Web Client​

Command Center​

  • Search in Command Center now only starts when at least three characters are entered or when the Enter key is pressed.

View​

  • Map type view:
    • Changed the label related to the Heat Map to display Heat Map instead of Toggle HeatMap.
    • Added the Clusters feature. Refer to Map View for more details.

Security​

  • Implemented compatibility with LDAPS domains by adding the Use SSL/TLS slider. Added an SSL/TLS column in the Domains list to distinguish which domains use LDAPS.
  • The Kentor library used by Single Sign-On (SSO) is now called Sustainsys. Procedure to edit web.config updated for Azure SSO.
  • Improved Cookie compatibility. Refer for Cookie Management for more details.

DataSync​

Packaging​

  • Changed the time interval related to Log Cleaning to reduce high CPU usage.

Connections​

  • Added Connection Timeout field for the Acumatica connection to define server wait time before error.
  • Added new Source Connections: Space X, Agile CRM, and Custom API. Custom API acts as an all-in-one connector. More details.
  • Improved compatibility with VARCHAR2 data type in Oracle by setting CHAR storage type.
  • Use Client-Side Paging enabled by default for OData and Acumatica connectors.

Extractions​

  • Improved reading speed performance for Oracle tables.
  • Improved detection for NVARCHAR2 and VARCHAR2 data types to avoid Oracle compatibility issues.
  • Changed label Truncate and Load to Load for Migration extraction type.

Settings​

  • Changed label Use SSL/TSL to Use SSL/TLS.

Excel Add-in​

Default Drill Down​

  • Implemented Default Drill Down to access Formula detail directly without pop-up. More details.

Templates​

Sage 300 (Version 109)​

  • Changed to Order Detail data model regarding Quantity and Amount.

Sage X3 HR​

Version 107

  • Added missing French translations for new fields.
  • Changed folder GUID for Dashboards and Data Models.

Version 105

  • Added Formation and Skills Improvement fields to Historical HR Statistics data model.
  • Added Professional Status field to Time Sheets data model.
  • Added new data models: Training Formation and Annual Work Time.
  • Added reports in Professional Training and Work Condition Improvement folders.

Sage X3​

Version 114

  • Custom script for LEGGTESEL view created to improve compatibility with ETNA.

Version 113

  • Changed Reporting Currency script parameter to Global Currency.
  • Added new parameter in Global Currency Rates calculation in Info-Pages.
  • Improved French translation.
  • Changed VB Script to Javascript in Data Model Designer.
  • Adapted PJM module to x3v12 changes.

UDM (Version 218)​

  • Improved UDM_FORECASTADDLINES stored procedure to add lines to Forecasts by Quarters.
  • Translated Dashboards to French.
  • Changed Closed Date field in AR and AP Historical Staging data model.
  • Added Refresh by Date feature to all Cubes for Sage 300.
  • Improved performance on AR and AP views and cubes for Sage X3.

Fixes​

Web Client​

About​

  • Fixed redirection to Online Help when interface language was other than French or English.

Administration - Security​

  • Non-Administrator users now have access to Domains if granted.
  • Fixed Combination Option to use correct AND/OR values.

Data Model​

  • Hyperlinks appeared in a Worksheet but were not clickable. Refer to Adding a Hyperlink for more details.

View​

  • Negative values now correctly handle Chart Labels rotation.
  • Fixed Save As feature to reflect new title in View properties and export.
  • Restored Description Format and Sort Based On features when multiple Worksheets open.
  • Fixed Prompt icon visibility in Selection Page.

Dashboard​

  • Changing Environment now correctly updates filter values.
  • Fixed missing Owner and Description fields when creating new Dashboard.

Report​

  • Fixed text when exporting empty sections to PDF or Excel.

Excel Add-in​

  • Fixed TLS version requirement from TLS 1.0 to TLS 1.2.

Formulas​

  • Fixed Formula Wizard memory error for large numeric ranges.
  • Fixed formulas showing VALUE instead of numeric results in filters.

Templates​

Sage X3​

Version 115

  • Fixed Create Budget feature in Budget Entry Info Page for Oracle server.
  • Updated script in Embed into Sage X3 for Adjustment for Syracuse in Sage X3: Due to a recent web browser modification, exporting reports were not able to be downloaded.

Version 114

  • Fixed bad join on Stat Group 3 table in Invoice Analysis.
  • Fixed filters for Sales Regional Manager - Material Black Theme and Account Receivable dashboards.

Version 113

  • Fixed Oracle Special Script issue.

Sage X3 HR​

Version 107

  • Added missing Scripts for Historical HR Statistics and Annual Work Time data models.

Version 106

  • Fixed scripts hardcoded to SEED instead of user-entered schema.

UDM​

Version 221

  • Fixed Info-Page of Sage X3 Opening Balance cube.
  • Sage X3 schema no longer required if template installed for another ERP.

Version 220

  • Fixed multiple Sage 300 and Sage X3 cube issues (Sales Orders, Sales Summarized, OLAP Summarized, CRM mapping, translations, UDF precision, etc.).

Version 218

  • Fixed Opening Balance loading only Period 1 for Sage 100.
  • Fixed Oracle bugs and added tracking to DimWarehouse cube.
  • Fixed global parameter issues between Default Sales Rep and Document Sales Rep.
  • Fixed missing Format in some custom calculations.

DataSync​

Extractions​

  • Fixed INT64 synchronization issue for OData.
  • Fixed errors in Sample Mode or Preview Table for OData.
  • Fixed NUMBER type in Oracle destination not allowing decimals.
  • Fixed Collation Transformation being set to True during template import.

Connections​

  • Fixed memory leak for Acumatica, OData, and Excel connectors.

Transformation​

  • Fixed issue requiring manual space for values in Transformation module.