Version 2023 Release 1 (February)
Web Server Build Number: 23.0.1.10064
Excel Add-in Build Number: 23.0.1.10064
DataSync Build Number: 23.0.1.10064
SEI for Sage 300 Embed Build Number: 23.0.1.10064
February 27, 2023
Excel Add-in Build Number: 23.0.1.10064
DataSync Build Number: 23.0.1.10064
SEI for Sage 300 Embed Build Number: 23.0.1.10064
February 27, 2023
Breaking Changes
important
If you are using SAML2 as single sign-on method, you must reconfigure the Entity ID and the ACS URL after upgrading to Version 2023 Release 1 because these settings have changed.
- For Cloud customers using the Excel Add-in: the service address now uses port 443 instead of 8443. (When installing the Excel Add-in, provide the service address in this format:
xxxxx.sageenterpriseintelligence.com). - As of April 11, 2023, Microsoft Office 2013 is no longer supported by Microsoft or SEI.
- As of October 10, 2023, Windows Server 2012 R2 is no longer supported by Microsoft or SEI.
Improvements
Highlights
For the highlights of this release, see our Product Blog.
Installation
- SAML2 configuration has been added to the Authentication page. You no longer need to have two configurations for Web Client and Excel Add-in; the SAML2 configuration now applies to both. Also, you no longer need to redo the SAML2 configuration every time there is a new upgrade..
- All packages are now digitally signed.
Web Client
- Web Workbook (Preview) improvements:
- Shortcut keys are now available.
- Improved handling of filters passed when using queries.
Note: Workbook will return an error if the data model refers to non-existing parameters.
- Smart Cache improvements: added logging scope with details about Central Point, process ID, and environment.
- Data Model Designer improvements:
- New option to preview and copy the SQL statement.
- Column in Designer view shows field data type.
- Headers always remain visible.
- New Search option to filter columns in the Fields table.
- Central Point Configurator: New Export Resolution option for charts, maps, and dashboards with 5 scaling options to reduce PNG/PDF file size.
Distribution
- Improved performance when executing scheduled jobs for distributing views, dashboards, and reports with distribution filters.
Excel Add-in
- Removed dependency of feature upgrades.
- Improved Excel Add-in logs.
DataSync
- New connector for Azure DevOps Online (Beta).
- Updated NetSuite connector documentation.
Web Client Templates
| Template | Change description |
|---|---|
| Sage 200 UK | - Financial reports reformatted to resemble Sage 200 UK more closely. - Updated installation procedures. |
| Sage 300 | - Web Workbook: Enhanced Balance Sheet and Income Statement filters and formatting. - New workbooks: Finance KPI Dashboard and Business Dashboard. |
| Sage Intacct | - Location and sub-location hierarchy added (up to 9 levels, 3 visible by default). - Web Workbook: Enhanced Balance Sheet and Income Statement filters and formatting. - New workbooks: Finance KPI Dashboard and Business Dashboard. |
| Sage X3 | - Web Workbook: Enhanced Balance Sheet and Income Statement filters and formatting. - New workbooks: Finance KPI Dashboard and Business Dashboard. - Sales, Data Warehouse, Manufacturing, Logistics, Purchasing modules: New views and fields across multiple data models. |
Fixes
Installation
- Uninstalling or upgrading SEI Server no longer triggers errors in Web Client and Scheduler API logs.
Web Client
<Edit Advanced Filter>role restored for versions 2022 R1.5, R1.6, and R1.7.- Copying a data model now correctly copies selection pages.
- Dashboard filtering panel buttons now display correctly for all languages.
- Exporting worksheet to PDF now correctly displays column headers when using Fit To or Zoom.
OLAP Manager
- Fixed error when loading multiple OLAP cubes with Logging enabled: "Index was outside the bounds of the array" or "The tasks argument included a null value".
DataSync
- Sage Intacct and Custom API connectors: Load By Partition now stops if a partition fails.
- Oracle Date/Timestamp fields now correctly synchronized to SQL Server.
- Incremental loads in Sage Intacct now correctly handle time zones.
- SEI Cloud: Sage Intacct multi-dimensional fields now return all dimension values.
Web Client Templates
| Template | Change description |
|---|---|
| Sage 200 UK | Opening Balance calculation adjusted to fix discrepancies when viewing previous years. |