Version 2024 Release 11 (November)

Web Server Build Number: 24.0.11.10076

Excel Add-in Build Number: 24.0.11.10076

DataSync Build Number: 24.0.11.10076

November 15, 2024

Improvements

Web Server

  • In the workbook, a feature to hide rows and/or columns with zeros is now available.

  • A data model parameter pop-up window has been added to the workbook.

  • When the Format Category is set to None in the Data Model Designer on a date/datetime field, the date now has an accurate default DateTime format in the view.

  • Added an error message in the workbook indicating to users that an improperly deleted data extraction or pivot no longer exists.

Distribution

  • A new option has been added to execute stored procedures on views, dashboards and reports if they exist.

  • Hidden sheets are now displayed in the selection for the distribution.

DataSync

  • DataSync & Scheduler have been upgraded to .NET 8.

Web Server Templates

Template Change description
Acumatica

  • Nectari solution is now officially certified by Acumatica for Version 2024 R2.
Sage 100

  • The Financial Transaction Data models are now combined into the two GL Financial Summary and GL Account Transactions data models. The "GL Account Transactions" includes the transactions details compared to the GL Financial summary data model.

  • The opening balance has been added to the main financial data models.

  • Financial report worksheets have been added to the new GL Account Transactions.

  • The IRP module is now available.

  • New financial workbooks have been added for Cash Flow Reports.

  • New financial workbooks have been added for Profit & Loss Reports.

  • New financial workbooks have been added for Balance Sheet Reports.

  • New financial workbooks have been added for Trial Balance Reports.

Fixes

Web Server

  • In the Formula Wizard, the Preview button did not work if there was a date filter applied.

  • Fixed an issue where the Autohide feature broke if a data extraction returned fewer rows than the original range.

  • The one-click filtering option (single selection filtering) for views contained in a dashboard was not being saved when applied to a worksheet.

  • When exporting a view with a date format column to CSV, the date was always formatted as MM/DD/YYYY even if it was formatted differently in the view itself.

  • When filtered using the between operator in a selection page, date columns that were set with a MM/DD/YYYY format were getting switched to a DD/MM/YYYY format.

  • The Info Page could only be created when English was the selected language, and translated versions of the page were not functional.

  • When copying a pivot table to a new sheet and then renaming the copied pivot table in the new sheet, the original table was renamed instead.

  • If users copied a pivot table into a new sheet and then copied that table into another sheet, the third pivot table disappeared from the Pivot Wizard if users clicked out of the cell it was in.

  • If users saved an empty selection when editing or creating a new Global Selection page, the default empty value displayed "null."

  • Users could not modify the prompt on a Global Parameter set as "String" in the Data Type drop-down.

OLAP Manager

  • When creating a cube with no other saved cubes in the OLAP Manager, the cube would not save properly.

Distribution

  • Users were unable to run a job after doing a search for it.

  • When users tried to add a condition to a distribution job that had a workbook added in the Web Views tab, the Conditions pop-up wouldn't open.

  • When a stacked chart was used in a distribution, the formulas resulted in "#Value" rather than the correct result.

DataSync

  • After installing DataSync, users could sometimes see the exception "Unable to obtain configuration from [PII is hidden].".

  • Users were unable to save some existing source connections if they changed the tracking type from None to Date.

  • When upgrading the DataSync database, the process could fail if an existing connection could not be validated.

Web Server Templates

Template Change description
Acumatica

  • Fixed a join on the EPEmployee table from the Employee Hours data model.