Version 2024 Release 6 (June)

Web Server Build Number: 24.0.6.10121
Excel Add-in Build Number: 24.0.6.10121
DataSync Build Number: 24.0.6.10121
SEI for Sage 300 Embed Build Number:
June 22, 2024

Improvements

Web Server

• Improved workbook performance by over 100% when opening and refreshing a workbook containing a high number of formulas. 28351
• Improved user experience while loading and refreshing workbooks. 28352
• Windows Authentication support has been added for the SQL Server connector. 28107
• The list of cultures in the Format Cells pop-up has been reduced to show only the required ones, improving workbook load times. 28354
• The Pivot Wizard is now available, allowing for easier creation and management of pivots. 28195
• It is now possible to do a drill-down on a data extraction. 28442
• Multiple Selection is now available for the Dashboard Filtering Panel. 28501

DataSync

• A new connector has been added for MongoDB. 28217

Web Server Templates

Template	Change description
Sage X3	- Improved French translations. 28483 - Added the CUBE_ prefix for Sage X3 Cubes data models. 28484 - New separate folders for Cubes and Prompts. 28485 Sage X3 Manufacturing - The Plant Manager Dashboard (formerly the Manufacturing Dashboard) is now available with text, font, and theme improvements. 28486 - The Warehouse Manager Dashboard is now available. 28487 - The Chief Operating Officer (COO) Dashboard is now available. 28488 - A new Stock Location data model has been added to the Logistics folder. 28489 - A new Stock Journal data model has been added to the Logistics folder. 28490 - A new Invoice Elements data model has been added to the Sales folder. 28491 - A new Non-Conformance data model has been added. 28492
Sage 300	- Added opening balance to GL Details data model so it can be used on all reports, allowing users to use drill down effectively. 28493 - Added Transaction Details to the Opening Balance entry. 28494 - New financial workbook reports are now available. 28495
Sage Intacct	Sage Intacct Not-for-Profit (NFP) - The Sage Intacct Not-For-Profit add-on is now available. 28496 - Vertical workbooks with tailored financial reporting are now available. 28497 - Vertical dashboards are now available. 28498
Universal Data Model (UDM)	- Added the UDM_ prefix for UDM data models. 28499

Fixes

Web Server

• When a workbook with a selection page was opened multiple times, the selection page parameter values were all changed to using the last opened workbook’s value. 28301
• The workbook would enter an unresponsive state when copying and pasting a data extraction with default column names that didn’t follow the proper number sequences. 28302
• Users received an error message when a workbook containing a formula created by the Formula Wizard was exported as an Excel file. 28303
• Users drilling down on a data extraction encountered an issue when drilling down on a newly created second profile without first drilling down the first profile. 28304
• The Auto Refresh setting for data extractions was not working when the filters were from the same sheet. 28305
• The Auto Refresh setting for data extractions was ignored when the filter cell was changed, resulting in a refresh of every extraction in the workbook. 28306
• Since Version 2024 Release 3, the NOT operator in the Formula Wizard was not returning the expected result. 28307
• Special characters now copy correctly when doing a Copy Selection or Copy Row on a grid. 28308
• Fixed a bug for Single Sign-On (SSO) users where their last login date was not recorded properly within the database. 28309

Distribution

• When users scheduled a dashboard created from an expanded group in a worksheet, the received file was collapsed instead of expanded. 28310

Excel Add-in

• The Update Data Model Parameter functionality was not working as expected from Version 2024 Release 3 to Version 2024 Release 5. 28311

DataSync

• When changing table elements, the table was invalidated but not the extraction, and in consequence users were not aware that a Validate and Build command was necessary to run the extraction with no errors. 28312
• The status of table extractions was not updated after failure and the error was not logged. 28313
• When users imported a template that would fail, an empty extraction was created with no tables. 28314
• When using the same unique ID in a Consolidation extraction, the Incremental Load failed. 28315

Web Server Templates

Template	Change description
Sage 300	- Fixed issues including fiscal period format, segment filtering, restructuring of balance sheet, and the addition of a drill-down feature. 28510
Universal Data Model (Sage X3)	- Fixed an issue where negative quantities from price adjustments were not being applied to Stock Valuation. 28511