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.

Improvements

Installation

  • Updated the Oracle dlls included within the Server installation.

Web Client

  • Data Extraction Wizard (Preview) is now available in the Web Workbook.

  • Improvement to the performance of the formula by loading the data models and environments when opening the workbook instead.

  • Improvement to the Search filtering within the Reporting Tree.

  • Improve the logging when importing the template.

Excel Add-in

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

DataSync

  • New connector for GraphQL (Beta version).

  • Increase the size of the column DESTINATION_TABLE_NAME on SCH_CHILD_TRIGGERS table to avoid issue when logging on big table name.

Web Client Templates

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.

Fixes

Web Client

  • Data would not display when filtering in the worksheet with a value that contains special characters.

  • Exporting Template would fail when the description of Cubes or Global Scripts contained accents.

  • When exporting, indentation in the group was missing when it was set as hyperlink.

  • In Dashboard, adding a chart was not working if the Show Specific Title toggle button was disabled.

  • The X-Axis title appeared twice within the Chart.

  • User Calculated Column and User Calculated Pivot might get overwritten when user doesn't have permission to see all of the existing list.

  • When enabling Fit Group to Content, the values in the Group column would still be truncated.

  • 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.

  • Since Version 2023 Release 8, the subscribe popup cannot close automatically after subscribing to the view, dashboard or report.

Excel Add-in

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

OLAP Manager

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

DataSync

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

Web Client Templates

Template Change description
Sage X3
  • Modified the filters in the X3_ARAP_HIST view so it will include some missing lines that were reported.

  • Modified the HISTODUDOPEN_CALC stored procedure to include missing lines when there is split payment.

  • 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