Version 2023 Release 13 (November)
Web Server Build Number: 23.0.13.10209
Excel Add-in Build Number: 23.0.13.10206
DataSync Build Number: 23.0.13.10203
SEI for Sage 300 Embed Build Number: 23.0.13.10203
November 18, 2023
Excel Add-in Build Number: 23.0.13.10206
DataSync Build Number: 23.0.13.10203
SEI for Sage 300 Embed Build Number: 23.0.13.10203
November 18, 2023
Breaking Changes
- As of October 10, 2023, Windows Server 2012 R2 will no longer be supported by Microsoft nor by SEI.
- As of the July 2023 release, we no longer support HTML export. Please ensure to edit your distribution jobs settings, the output will be done in a different format.
- For On-Premise customers using a version before the July Release 8, we highly recommend upgrading your Excel Add-In. 20318
Improvements
Installation
- Updated the Oracle dlls included within the Server installation. 23193
Web Client
- Data Extraction Wizard (Preview) is now available in the Web Workbook. 4244
- Improvement to the performance of the formula by loading the data models and environments when opening the workbook instead. 18681
- Improvement to the Search filtering within the Reporting Tree. 22373
- Improve the logging when importing the template. 24405
Excel Add-in
- It is now possible to re-order the selected columns in the Pivot Table Editor. 24166
DataSync
- New connector for GraphQL (Beta version). 19233
- Increase the size of the column DESTINATION_TABLE_NAME on SCH_CHILD_TRIGGERS table to avoid issue when logging on big table name. 24196
Web Client Templates
| Template | Change description |
|---|---|
| Sage 300 | Newly added: - AR Invoice Payments; Data Model combining AR Transactions and Payments |
| Sage X3 | Invoice Analysis (with Kit Margins) and Invoice Analysis without Valuation (with Kit Margins) Data Models now translated in French, Spanish, Portuguese, Chinese and Italian. |
Fixes
Web Client
- Data would not display when filtering in the worksheet with a value that contains special characters. 23602
- Exporting Template would fail when the description of Cubes or Global Scripts contained accents. 24126
- When exporting, indentation in the group was missing when it was set as hyperlink. 24032
- In Dashboard, adding a chart was not working if the Show Specific Title toggle button was disabled. 24076
- The X-Axis title appeared twice within the Chart. 24192
- User Calculated Column and User Calculated Pivot might get overwritten when user doesn't have permission to see all of the existing list. 23057
- When enabling Fit Group to Content, the values in the Group column would still be truncated. 23622
- Inside of a Selection Page, when selecting a Date, DateTime or Time from a prompt, it would add quotes causing the validation to throw an error. 23782
- Since Version 2023 Release 8, the subscribe popup cannot close automatically after subscribing to the view, dashboard or report. 22931
Excel Add-in
- Formula wizard was throwing an error when the filter references a range that uses the same value for both FROM and TO. 23516
OLAP Manager
- Improve the search box list that did not filter automatically in certain cases. 24600
DataSync
- Since Version 2023 Release 12, upgrading was not possible if you had invalid Source and/or Destination connections. 24287
- When Load by Partition is used, the logs were showing the incorrect insert count.24001
- When Trim option is enabled, canceling an extraction could be really slow. 24156
- When the Trim option is enabled, the Clean Deleted Records would delete all the records in the destination. 24244
Web Client Templates
| Template | Change description |
|---|---|
| Sage X3 | - Modified the filters in the X3_ARAP_HIST view so it will include some missing lines that were reported. 23755 - Modified the HISTODUDOPEN_CALC stored procedure to include missing lines when there is split payment. 22386 - Removed unused VBScripts from the Financial Summary data model in the Sage X3 template. |
| Sage Intacct | Fixed a bug where the GL Transactions data model was not taking into account the @@FISCALYEAR_START_END global variable |