Skip to main content

Version 2025 Release 5 (May)

Web Server Build Number: 25.0.5.10027
Excel Add-in Build Number: 25.0.5.10027
DataSync Build Number: 25.0.5.10027
SEI for Sage 300 Embed Build Number: 25.0.5.10027
May 17, 2025

Improvements​

Web Server​

  • General
    • Improved loading time of visualizations when multiple tabs are open. 33899
  • Workbooks
    • Improved performance of formulas by optimizing the Smart Cache processing and increasing speed. 34202 34187
  • Administration
    • Query logs now include variable declarations to make SQL statements easier to read and reuse for troubleshooting. 34394

Distribution​

  • Added the option to use an SFTP or FTP(S) location when exporting a job to an external location in Distribution. 28789

DataSync​

  • Added support for key pair authentication when using the Flat File connector to connect to an SFTP server. 34273

Web Server Templates​

TemplateChange description
Universal Data Model (UDM)
  • Renamed the predefined Inventory data model UDM_Detailed Manufacuring Order to UDM_Stock Opening Balance Calculation. 34217
  • Improved error handling when invalid parameters are entered in the Generate Week Forecast info page. 34213
Sage X3
  • Added default values for France reporting groups based on demo accounts. 34035
  • Added sequence number to the sales data model. 34213
  • Optimized the stored procedure that calculates opening balances. 34213
  • Introduced a global variable (@@OPENBAL) to choose whether to use opening balances from X3 or a simulated version. 34213
Sage XRT Advanced
  • Improved the stored procedure that refreshes cash balances to optimize performance. 34114
Sage 300

Bug Fixes​

Web Server​

  • Data Models and Views

    • Saving a data model with a calculation on duplicate field names is now blocked, and a validation message guides users to correct the setup. 34263
    • Filtering on columns containing spaces in its name was causing an error. 34405
    • The CSV export of decimals and other data types could have the wrong format (since Version 2024 Release 11 - November). 34244

  • Administration

    • In Manage Template, empty folders would not be deleted after uninstalling reports or workbooks. 12348
    • In Import Template, views that already exist in Central Point were incorrectly shown as Never Installed. 34125

Distribution​

  • Editing a dashboard that was part of a distribution job would remove its association from that job. 34150
  • A job could trigger a "The process cannot access the file" error even though it completed successfully. 34342

Excel Add-in​

  • In Data Extraction, leaving the Order By value empty would cause an error message. 34271
  • In Data Extraction and Pivot Table, global Variables used in filters would trigger an error due to a new way queries were handled. 34272

DataSync​

  • In Oracle, DateTime fields could incorrectly be handled with time zone information (TO_TIMESTAMP_TZ), causing an error during data synchronization. 34221
  • Connections now stay active for 7 days when using the OAuthHeadless mode, preventing scheduled NetSuite extractions from failing. 34223

Web Server Templates​

TemplateChange description
Universal Data Model (UDM)
  • Fiscal Year Adjustment did not work correctly on non-standard fiscal calendars when creating a new ledger. 34213
Acumatica
  • The field Document Number Link in Sales Invoices did not return a valid hyperlink. 34213
  • The customization project prevented service management (FS...) table extractions from working correctly in DataSync. 34213
Sage X3
  • Various global scripts for Oracle connections would not run as expected. 34213
Sage 300
  • The placeholder table for PVT_POPORHO was not created during import, which caused the Purchase Orders data model to fail. 34213
  • The field Contract was used in a view but was not exposed in the Purchase Order Lines data model. 34213
  • The prompt in the Sales History data model was incorrectly configured. 34213