Version 2023 Release 13 (November)

Web Client Build Number: 23.0.13.10209

Excel Add-in Build Number: 23.0.13.10206

DataSync Build Number: 23.0.13.10203

November 18, 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. 20318

Data Extraction Wizard (Preview) is now available in the Web Workbook. 4244
Improvement to the performance of the formula by loading the data models and environments when opening the workbook instead.18681
Improvement to the Search filtering within the Reporting Tree. 22373
Improve the logging when importing the template. 24405

It is now possible to re-order the selected columns in the Pivot Table Editor. 24166

New connector for GraphQL (Beta version). 19233
Increase the size of the column DESTINATION_TABLE_NAME on SCH_CHILD_TRIGGERS table to avoid issue when logging on big table name. 24196

Template	Change description
Sage 300	Newly added: AR Invoice Payments; Data Model combining AR Transactions and Payments
Sage X3	Invoice Analysis (with Kit Margins) and Invoice Analysis without Valuation (with Kit Margins) Data Models now translated in French, Spanish, Portuguese, Chinese and Italian.

Template

Change description

Sage 300

Newly added:

Sage X3

Invoice Analysis (with Kit Margins) and Invoice Analysis without Valuation (with Kit Margins) Data Models now translated in French, Spanish, Portuguese, Chinese and Italian.

Data would not display when filtering in the worksheet with a value that contains special characters. 23602
Exporting Template would fail when the description of Cubes or Global Scripts contained accents. 24126
When exporting, indentation in the group was missing when it was set as hyperlink. 24032
In Dashboard, adding a chart was not working if the Show Specific Title toggle button was disabled. 24076
The X-Axis title appeared twice within the Chart. 24192
User Calculated Column and User Calculated Pivot might get overwritten when user doesn't have permission to see all of the existing list. 23057
When enabling Fit Group to Content, the values in the Group column would still be truncated. 23622
Inside of a Selection Page, when selecting a Date, DateTime or Time from a prompt, it would add quotes causing the validation to throw an error. 23782
Since Version 2023 Release 8, the subscribe popup cannot close automatically after subscribing to the view, dashboard or report. 22931

Formula wizard was throwing an error when the filter references a range that uses the same value for both FROM and TO. 23516

Improve the search box list that did not filter automatically in certain cases. 24600

Since Version 2023 Release 12, upgrading was not possible if you had invalid Source and/or Destination connections. 24287
When Load by Partition is used, the logs were showing the incorrect insert count.24001
When Trim option is enabled, canceling an extraction could be really slow. 24156
When the Trim option is enabled, the Clean Deleted Records would delete all the records in the destination. 24244

Template	Change description
Sage X3	Modified the filters in the X3_ARAP_HIST view so it will include some missing lines that were reported. 23755 Modified the HISTODUDOPEN_CALC stored procedure to include missing lines when there is split payment. 22386 Removed unused VBScripts from the Financial Summary data model in the Sage X3 template.
Sage Intacct	Fixed a bug where the GL Transactions data model was not taking into account the @@FISCALYEAR_START_END global variable