Version 2023 Release 8 (July)

Web Client Build Number: 23.0.8.10138

Excel Add-in Build Number: 23.0.8.10138

DataSync Build Number: 23.0.8.10138

July 22, 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.
In the July 2023 release, Excel Add-In is not retro-compatible. The upgrade of your Excel Add-In is mandatory with this release for Cloud customers and highly recommended for On Premise customers. 20318

The Web Workbook (Preview):
- Ability to open Formula Wizard when there are multiple NECFormula present in a cell. This gives the ability to edit each of them individually, and give them custom names for easy sorting.14016
- New "Reset Group By" button enables users to remove preset default values to Group By = False and Aggregation = NONE. 21642
- Drill down side panel now provides the ability to open a hyperlink field (set up in the data model designer). 21066
- Improved Workbook Cell click event handling and corrected found memory leaks. 20903
Upgraded jQuery from version 1.11.1 to version 3.6.1. Some parts of the interface styling may have been changed by this upgrade. 21494
Enhanced security when reading data in Nectari. 20474

Ability to customize output file name with Custom Name, and use Global Variables and Special Variables in it.20435
New email notification sent when a distribution job fails to complete.15980

New extraction parameter "Trim all values" allows you to removes unnecessary spaces after the string. 19577

Template	Change description
Universal Data Model	Added a backup/restore functionality for the Account Mapping and Report Builder configuration tables in UDM.
Sage Intacct	Opening Balance records Generated via the info page in the Template will no longer insert an Entry_date. This is to avoid problems where the new Process Deleted Records functionality in Datasync could potentially delete these records if the partition field is set to Entry_date.
Sage 300	New Add-on: AutoSimply (Manufacturing). Includes 3 Data models (Manufacturing orders, Manufacturing Quotation and Transaction Histories), multiple views and a dashboard.

In Dashboard, Custom Heading and Custom Column Group Heading was sometimes not retained after saving. 21892
In Web Workbook, only the first 1000 rows would get imported and/or saved even when the workbook contained more than 1000 rows. 22059
When installing with an HTTPS certificate, an error sometimes occurred which prevented the process from completing. 21811

Creation of trigger to run sequentially instead of in parallel to avoid this error : The referenced entity 'Inserted' was modified during DDL execution. 22183

When distributing reports with a scheduler filter, it was sometimes applying the wrong filter. 21473
Resolved a memory leak issue that occasionally occurred when a distribution job failed. 21129

Pivot Table fields order was not retained when editing a pivot or doing a Pivot Table Refresh. 21867

On SQL Server destination, when reading the metadata of an object that is in the process of being dropped, a deadlock can potentially occur. 21731
When a lot of jobs are running at the same time, a job could sometimes be skipped with this error message : "Index was outside the bound of the array". 21822

Template	Change description
Sage Intacct	Fixed an issue where the Opening Balance calculation (info page) for the GL Transactions data model would fail due to missing fields. Fixed an issue where fields in the GL Transactions data model caused an error.