• How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views? First…
  • INFO: Polish Legislation addon for 2022 R2 now available

    We are pleased to inform you that the Polish legislation package compliant with the 2022 R2 release is now available. The package and also the migration tool from V11 to V12 have been uploaded to our FTP site .
  • INFO : Version 12 : 2022 R2 (12.0.30) is now available

    Sage X3 2022 R2 (12.0.30) is now available. Please refer to the Sage X3 Latest Patches article for more details You can review the Sage X3 12.0.30 Release Notes here. Make sure you check the 'Changes' tab This delivery contains the following new features…
  • What does Elastic Search do anyway?

    Elastic Search seems to be one of those features many people simply don’t understand and so ignore. To be honest, I think any lack of understanding may be partly down to the lack of clear Sage X3 specific documentation available to either the implementor…
  • ALERT: Hotfix is available for the Runtime and Adxadmin component (94.1.14)

    - ONLY for 2021 R3 and 2021 R4 releases - ONLY if you use Java Bridge Server or VT Web Server Please install Runtime 94.1.14 and Adxadmin 94.1.14 to secure the communication between components. Runtime 94.1.14 Adxadmin 94.1.14 Before applying…
  • How can I clone a Sage X3 Server?

    There are several reasons when it could be sensible to consider cloning a Sage X3 server. For example, if you have a LIVE server which you are planning to upgrade and wish to take a clone of the LIVE server so you can run a test upgrade. Cloning allows…
  • Test System Build Diary : 2021 R4 Single Server Installation

    Last Updated: 15th November 2021 Return to Index page: Test system Build Diary index What is a "Build Diary" A Build Diary describes the steps taken by Sage Support to perform a task or tasks on our internal test systems. Build diaries could be…
  • Test system Build Diary: 2021 R4 upgrade from 2021 R3 (Multi-Node)

    Last Updated: 5th November 2021 Return to Index page: Test system Build Diary index ( https://www.sagecity.com/gb/sage-x3-uk/b/sage-x3-uk-support-insights/posts/index-page-build-diaries ) What is a ”Build Diary” A Build Diary simply describes the…
  • Speed up your configuration !

    Did you know that you can pre-populate the Sage X3 management console solution variables using the command line? If not, I’m going to get you started. Hopefully, this blog post will give you some ideas on how you can use this command-line tool to speed…
  • Index page: High Availability with Sage X3

    You are planning to implement a Highly Available (HA) Sage X3 environment, so need to gather together all the information about the various Sage X3 components and how they operate in a HA environment. You may have found the Sage specific HA related documentation…
  • ALERT: **RESOLVED** Mysage Case Management Portal update **RESOLVED**

    Latest Update as of 9AM 17/9/21 The issue has now been resolved and the Case Management Portal is now available. We will no longer be monitoring the [email protected] mailbox . Latest Update as of 12.10 PM: An emergency…
  • ALERT: 2021 R1 Includes External URL Policies Function.

    An Iframe is a block present in a web page that embeds another HTML page hosted by a web server. Sage X3 2021 R1 includes a new function called External URL policies. This function allows declaring URLs that are allowed in Iframes. Any iframe that uses…
  • User sessions unexpectedly timeout or give "Fatal Error"

    There have been several issues raised recently whereby user sessions are giving intermittent "Fatal error" messages or are timing out even though the users are still working within Sage X3. Some of these sorts of issues can be technical, but some may…
  • The Finance Round-Up #5

    Welcome back to the latest edition of the Finance Round-Up blog! NEWS AND ALERTS There have been a couple of significant announcements in this past month; from the HMRC Header Change – which impacts all customers using the Sage X3 MTD feature, to…
  • ALERT: E-commerce VAT in the EU is changing

    As of 1 July 2021, there are changes to VAT rules affecting business to consumers (B2C) transactions in the European Union (EU). The document attached addresses the following questions and impact on Sage X3: Who is affected? How is Sage making…
  • ALERT: Sage X3 Version 12 Patch 26 (2021 R2) is now available.

    Version 12 Patch 26 (2021 R2) is now available. Please refer to the latest Patch article in https://www.sagecity.com/gb/sage-x3-uk/f/sage-x3-uk-announcements-news-and-alerts/147993/sage-x3-latest-patches
  • Reducing the time taken exporting/importing folder data via the X3 Console

    Do you want to reduce the time taken to export and import a folder from the Safe X3 Console ? If yes, then read on! From Version 2.46 of the X3 Console you can utilise a native SQL Bulk Copy Program (BCP) feature. This allows faster download of data…
  • NEWS: 2021 R2 (Version 12.0.26) Release Notes for Finance Module

    Please review the new features available below for the Finance Module on the Release notes for 2021 R2 (Version 12.0.26): Click on the link to Release notes at the bottom of the page. Fixed assets improvements to simulated depreciations In the…
  • Illustrated guide to tracing Web Services

    NOTE: This article is no longer relevant from 2021 R3 (Version 12 Patch 27) as the Engine Tracing functionality changed significantly in this version. See the PDFs attached to KB article " How to run an Engine trace in Sage X3? " for more details on both…
  • Illustrated guide to tracing Imports and Exports

    NOTE: This article is no longer relevant from 2021 R3 (Version 12 Patch 27) as the Engine Tracing functionality changed significantly in this version. See the PDFs attached to KB article " How to run an Engine trace in Sage X3? " for more details on both…
  • Do you need to test Sage X3 email functionality ?

    Testing e-mail functionality can be problematic in some situations. You may not have access to an SMTP server needed to send e-mails from Sage X3 and to receive. The last thing you want to do is to inadvertently e-mail your contacts or get your domain…
  • ALERT: X3 Standard Cost Calculation Error in 2021 R1 - HOTFIX Available

    In 2021 R1 (12.0.25) release, user may experience an error when running the Standard Cost Calculation: Summary of the issue: When 2 components are used in a BOM and these components use the same overhead category, the calculation of standard cost…
  • The Finance Round-Up #3

    Finance Round Up Welcome back to the latest instalment of the Finance round up! UPDATES Firstly, although there are no functional updates this time, its worth noting that there are new versions of Syracuse for V11 and PU9. Please check this Alert…
  • ALERT: X3 Warehousing functions error In 2021 R1 - HOTFIX Available

    In 2021 R1 release, users may experience issues when clicking on some of the fields in Sage X3 / Sage X3 Warehousing functions GESITF, GESBPC, GESBPS or GESREP. The function will be abruptly closed and the session will sometimes be lost. A hotfix…
  • HMRC MTD Issue Reported - UPDATED 18.03.21

    Reported Incident Product / Service Impacted HMRC – MTD Services Reported Impact Customers are receiving an error message stating “Sorry there was an error connecting to HMRC” when creating a new MTD Return Next Steps HMRC hope to have…