Version 2025 Release 2 (February)

Web Server Build Number: 25.0.2.10043

Excel Add-in Build Number: 25.0.2.10043

DataSync Build Number: 25.0.2.10043

February 15, 2025

Improvements

Installation

  • Application starting time has been improved when starting/restarting Nectari through IIS.

Web Server

  • Workbooks

    • It is now possible to change and refresh the data source for pivots by selecting the Change DataSource and/or Refresh buttons.

    • A menu item has been added to enable/disable subtotal calculations for pivots.

OLAP Manager

  • Logs now include the start time, end time, environment name, and environment ID for jobs.

Excel Add-in

  • Security updates.

Web Server Templates

Template Change description
Sage 100

  • Added Sales Analysis Dashboard.

  • Added AR-AP dashboard.

  • Revised the "Schema for custom objects" global script to be fully adaptable based on our live or DataSync connections and create the necessary "NEC_" tables or views.
Sage 200 Evolution

  • Standardized the default theme for all dashboards.
Sage 300

  • The fact table GLPOST_BAL in the "Detailed Transactions" data model now includes the opening balance amount for Journal Transaction currency. Previously only Source currency amount included the opening balance.
Sage 500

  • The fact table for the Finance cube data model has been replaced and fixed.

Fixes

Installation

  • The Upgrade pop-up was not displayed when there was a duplicate feature in nec-centralpoint.xml.

  • When installing or upgrading to Version 2024 Release 3 or higher, the permissions on the Web Server folder were not set correctly.

Web Server

  • Workbooks

    • Workbooks with pivot filters that had "&" characters did not display correctly after re-opening the workbook.

    • After importing an Excel file with a pivot and a pivot slicer, the workbook did not include a slicer anymore.

  • Dashboards

    • Resolved an issue where multiple selection occasionally did not work correctly in the dashboard filtering panel prompt.

    • When changing a Date Filter that was a Data Model Parameter within the Filtering Panel, it was generating an error in the SQL query.

  • Date, DateTime, and Time

    • Fixed an issue where Date, Time, or DateTime fields could not be added to the Advanced Filter when the operator was set to "IsNull."

    • When users created a Historical Chart view, the DateTime values were not displayed correctly along the x-axis.

    • The DateTime field in the Filter section was incorrectly formatted when exporting a worksheet as a PDF.

    • The Date, Time, and DateTime fields appeared unformatted in the dashboard filtering tile prompt if the operators were set to BETWEEN or NOT BETWEEN.

  • Administration

    • In a rare circumstance, when evaluating a global variable threw an error, it could cause the Web Server to crash.

OLAP Manager

  • After building a cube, the Slices records were not resetting to 0.

Distribution

  • If users tried to distribute a workbook that didn't have a data extraction or pivot, the distribution would fail.

  • The Conditions tab of the Distribution was not working when a workbook was selected as the only item for distribution.

Excel Add-in

  • If the Web Server restarted, users were forced to reauthenticate to use the Excel Add-in.

  • Stored procedures set on an Excel Add-in report were not functioning properly when a parameter of type "from-to" was being used.

  • Fixed an issue where the default language, set by the last language used, was not remembered between logins.

  • Fixed an issue where SEI error logs were occasionally saved in the wrong folder.

DataSync

  • Corrected an issue with the Netsuite connector where table entries were sometimes missing or duplicated.

  • Some tables (REPORTINGAC, REPORTINGACHEADER APADVANCE, and APADVANCEITEM) were not discoverable when using the Sage Intacct connector.

  • Some tables in Sage Intacct had a data type conversion error and were reporting the wrong data types (for example, in the CreditCard table).

Web Server Templates

Template Change description
Sage 100

  • Fixed an issue where global variables were returning multiple results on consolidated databases.
Sage X3

  • Fixed ORACLE Scripts for Sage X3:

    • Stored Procedures: ZREFCNVRATES, X3_FILL_REPORT_MAP_GROUP, X3_GENERATE_ACCOUNTGROUPS

    • Tables: DFTACCGRPDESC, X3_ACCT_TO_ACCGROUP, X3_TEMP_GROUP_SUBGROUP, NCSRECENT