Tag Archives: Database

Powershell error encountered ‘The certificate chain was issued by an authority that is not trusted’ during configuring it in Sage X3 Console

In Sage X3, we may come across this error ‘The certificate chain was issued by an authority that is not trusted’’ while trying to configure Application in the console. This issue occurs when you upgrade runtime to any version 95.2.85 and greater. Cause: Solution: To solve powershell error, follow below steps: Uninstall-module -Name SQLServer -RequiredVersion… Read More »

Database Optimization Function in Sage X3

In sage x3, we have a function called database optimization which is used to track or create custom index. This function help us for easy reapplication when updating or migrating data set. It is useful to create the indexes in order to achieve a specific optimization (for example in a report or to optimize a… Read More »

How to save data in custom fields using Classes Concept in Sage X3

Whenever we add a new field in any screen of the Sage X3, we should keep in mind that the data entered in the field should be saved in the backend, if data is not getting saved in the backend then generally we handle this situation by adding lines of code into the script, but… Read More »

How to link Menu Item to Excel | Sage Enterprise Management

We have come across the requirement where excel data needs to be refreshed on the basis of Sage X3 data. This can be achieved with the below steps. We will need Sage addin available in the Microsoft Excel, this addin will link the data with Sage X3 database. If you will have Sage Addin available, this… Read More »