Skip to main content

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
SEI for Sage 300 Embed Build Number:
February 15, 2025

Improvements

Installation

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

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

OLAP Manager

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

Excel Add-in

  • Security updates. 33095

Web Server Templates

TemplateChange description
Sage 100
  • Added Sales Analysis Dashboard. 31998
  • Added AR-AP dashboard. 32009
  • Revised the "Schema for custom objects" global script to be fully adaptable based on live or DataSync connections and create necessary "NEC_" tables or views. 33057
Sage 200 Evolution
  • Standardized the default theme for all dashboards. 33047
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. 32978
Sage 500
  • The fact table for the Finance cube data model has been replaced and fixed. 33047

Fixes

Installation

  • The Upgrade pop-up was not displayed when there was a duplicate feature in nec-centralpoint.xml. 33049
  • When installing or upgrading to Version 2024 Release 3 or higher, the permissions on the Web Server folder were not set correctly. 27654

Web Server

  • Workbooks
    • Workbooks with pivot filters that had "&" characters did not display correctly after re-opening the workbook. 32362
    • After importing an Excel file with a pivot and a pivot slicer, the workbook did not include a slicer anymore. 31188
  • Dashboards
    • Resolved an issue where multiple selection occasionally did not work correctly in the dashboard filtering panel prompt. 32407
    • When changing a Date Filter that was a Data Model Parameter within the Filtering Panel, it was generating an error in the SQL query. 33159
  • 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". 31930
    • Historical Chart view: DateTime values were not displayed correctly along the x-axis. 31989
    • DateTime field in the Filter section was incorrectly formatted when exporting a worksheet as a PDF. 32022
    • Date, Time, and DateTime fields appeared unformatted in the dashboard filtering tile prompt if the operators were set to BETWEEN or NOT BETWEEN. 32031
  • Administration
    • Rare error evaluating a global variable could cause the Web Server to crash. 33222

OLAP Manager

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

Distribution

  • Distribution would fail if a workbook didn't have a data extraction or pivot. 33292
  • The Conditions tab of the Distribution was not working when a workbook was selected as the only item. 32600

Excel Add-in

  • Users were forced to reauthenticate if the Web Server restarted. 32466
  • Stored procedures set on a report were not functioning properly when using a "from-to" parameter. 33147
  • Default language not remembered between logins. 32288
  • SEI error logs occasionally saved in the wrong folder. 32646

DataSync

  • Corrected an issue with the Netsuite connector where table entries were sometimes missing or duplicated. 32398
  • Some tables (REPORTINGAC, REPORTINGACHEADER, APADVANCE, APADVANCEITEM) were not discoverable when using Sage Intacct connector. 32632
  • Data type conversion errors in Sage Intacct tables, e.g., CreditCard table. 32290

Web Server Templates

TemplateChange description
Sage 100
  • Fixed an issue where global variables were returning multiple results on consolidated databases. 33047
Sage X3
  • Fixed ORACLE Scripts for Sage X3: 30482
  • Stored Procedures: ZREFCNVRATES, X3_FILL_REPORT_MAP_GROUP, X3_GENERATE_ACCOUNTGROUPS
  • Tables: DFTACCGRPDESC, X3_ACCT_TO_ACCGROUP, X3_TEMP_GROUP_SUBGROUP, NCSRECENT