Version 2024 Release 7 (July)

Web Server Build Number: 24.0.7.10082
Excel Add-in Build Number: 24.0.7.10082
DataSync Build Number: 24.0.7.10082
SEI for Sage 300 Embed Build Number:
July 20, 2024

Improvements

Web Server

• Improved the loading time of a workbook when there was more than one workbook tab open. 29561
• Improved the loading of the workbook when the browser was not active. 29816
• Improved session auto-reconnect for certain elements from the Command Center and Administration after inactivity. 29568
• When selecting a date using the Calendar Picker, the current date is highlighted in blue if no date has been selected. 29634

Distribution

• Workbooks can now be distributed to other users. 36432987
• Workbooks can now be exported as CSV files. 22541
• The Run Now flag has been improved in case of failure, avoiding a loading loop. 28431

Web Server Templates

Template	Change description
Sage X3	- User and User Group migration from Sage X3 to SEI is now possible. 25823 - The Currency Rates data model has been added under Configuration in the Common Data folder. 29298 - The NEC_FXRATE_TABLE, which includes the currency conversion rates, has been added to all data models that have transaction measures, allowing for the equivalent Reporting Currency measures to be created. 29298 - The X3FXRATE cube has been added, which retrieves data from the NEC_FXRATE_TABLE for exchange rates. 29298 - The X3GACCCLS cube has been added for finance-related cube data models. 29298 - The CLSCODE field was added to the Accounts cube (X3GACCOUNT) and the Order Date field was added to the Sales Cube (X3SALESX). 29298 DataSync: Added the following tables for data extractions: WORKLOAD, TABWEEDIA, STOPREH. 29927 Sage X3 Manufacturing - Added Actual Costs to the "Production Report" data model which includes the WIP production costs. 29784
Sage 300	- Added Sage 300 Service Manager tables to DataSync extractions. 29752

Fixes

Web Server

• Updating an existing pivot with new fields in a workbook caused a display issue where the new fields were not functional. 29324
• The function =GetPivotData() did not resolve correctly in certain cultures. 29113
• In the Data Model Designer, global variables used in the Column Group Heading and Column Heading sections were saved with hard-coded values for Version 2024 releases 3–6. 29280
• When entering a global variable in a selection page, the formulas were not always resolved in the workbook. 25302
• For some users, the Formula Wizard was disabled in the Analysis panel when selecting the adjacent column of a data extraction. 29562
• Fixed an issue where users could not log out on certain servers. 29582
• The workbook’s external link did not contain the language set by the user. 29671
• Improved French translations for Pivot and Data Extraction features. 29583
• When exporting a worksheet or report to PDF, Chinese characters were not properly displayed. 28389

DataSync

• If an extraction template failed to be imported, an empty extraction was added rather than importing only valid tables and fields. 29744

OLAP Manager

• Users were sometimes unable to load the OLAP Manager logs. 21430

Distribution

• The jobs list could not be displayed when a condition contained an environment that was deleted. 29553

Excel Add-in

• The Excel Add-in would crash at start-up when using Excel 32 bits. 29626
• User Calculated column was displayed in formula fields when the Formula Wizard was used. 29099

Web Server Templates

Template	Change description
Sage Intacct	- Fixed an issue where debits and credits in the GL Summary data model were incorrect. 29673 - Fixed an issue where opening balances were in periods other than period 1 in the GL Transactions data model. 29673 - Reverted a bug where global variables in the field headers of the GL Transactions data model were overwritten with static values.
Sage X3	- Reverted a bug where global variables in the field headers of the AR/AP Current Aging and AR/AP Historical Aging data models were overwritten with static values.