Version 2023 Release 11 (September)

Web Client Build Number: 23.0.11.10071

Excel Add-in Build Number: 23.0.11.10071

DataSync Build Number: 23.0.11.10071

September 23, 2023

Breaking Changes

  • As of October 10, 2023, Windows Server 2012 R2 will no longer be supported by Microsoft nor by Nectari.

  • As of the July 2023 release, we no longer support HTML export. Please ensure to edit your distribution jobs settings, the output will be done in a different format.

  • For On-Premise customers using a version before the July Release 8, we highly recommend upgrading your Excel Add-In.

Improvements

Web Client

  • The Web Workbook:

    • Excel formulas will be dynamic when exporting a workbook in xlsx format.

    • New options to set formulas in Manual or Automatic mode.

    • The possibility to set different Themes for Web Workbook.

Fixes

Web Client

  • When there is no data within the web workbook, exporting the workbook inside of a template would throw an error.

  • In a Report, the Custom Calculation would show an extra column for Pivot Total even when if it was disabled.

  • Removed the prompt icon within the Execute Stored Procedure popup that was being displayed when it was not required.

  • A job containing a view with Google Map would either fail or remain in running status.

  • Increased the size of the SQL Script Builder window to accommodate the size required to display the list of fields.

  • Following the JQuery upgrade from Release 8, enhancements were made to fix UI glitches.

Web Client Templates

Template Change description
Universal Data Model

  • Fixed an issue where UDM_SALES was only including costs for kit items (Sage X3 datasources)
Sage Intacct

  • Added post-execution scripts in Datasync extractions to add missing fields to AR and AP tables.

  • The UDD mapping procedure could break when the UDD name is also a SQL keyword.

Sage X3

  • QA on SQL and Oracle has revealed a bug in the BI_DATEDIFF function in the Data Model Designer.

    A workaround is possible and requires users to adjust a Global Variable, depending on whether they are on SQL or Oracle...

    SQL:

    • Navigate to Global Variables

    • Edit "@@CURDATE" and make sure the last line is as follows: {necResult=yyyy+'/'+mm+'/'+dd;}

    Example

    • Press "Update" to save your changes (if necessary)

    ORACLE:

    • Navigate to Global Variables

    • Edit "@@CURDATE" and make sure the last line is as follows: {necResult=yyyy+''+mm+''+dd;}

    Example

    • Press "Update" to save your changes (if necessary)