Patch Information Note 12.0.24
Index
« Previous Next »

Note

This patch is a cumulative patch for version V12.0.20 and higher. The minimum version required to apply this patch is V12.0.19.

Installation of mandatory technical components

Configuration console 

Console_2.48.0.zip file

Adxadmin administration server

Adxadmin_93.1.19.zip file

Process server

Runtime_93.1.19.zip file

Syracuse server

SyracuseServer_12.9.1.zip file

Installation of recommended technical components 

MongoDB 

Mongodb_4.2.8.zip file

Note:

The Sage X3 platform is compatible with MongoDB 4.2. If you are using a previous version of MongoDB, it is strongly recommended to update it.

To install the MongoDB 4.2 upgrade, MongoDB 4.0 must be running.

You need to check your MongoDB version and update it to version 4.0, if necessary.

Note that if you're using an Oracle JAVA platform, prerequisites have evolved.

Please refer to the How to upgrade to MongoDB 4.2 documentation for more information.

Elasticsearch 

Elasticsearch is an open-source, distributed real-time search and analytics engine. Sage X3 is compatible with Elasticsearch version 7.9. You can download it from the Elasticsearch website.

Although Sage X3 is still compatible with previous releases, it is strongly recommended to install the latest version of Elasticsearch compatible with your release (to be checked from the Prerequisites overview page), as older versions will no longer be maintained by Elastic.

It is highly recommended to host Elasticsearch on a dedicated server.

Before upgrading Elasticsearch, you must delete the indexes on your current version.

Make sure that you write down the Elasticsearch host name and the corresponding HTTP service port number defined in the elasticsearch.yml file, as you will need to set the same parameters in the nodelocal configuration file (i.e. the hostname and port must match the network.host and http.port of the elasticsearch.yml file).

Note: For network.host, '0.0.0.0' will create a link to all the network interfaces. The value '0' has the same effect as '0.0.0.0'. Please refer to the Elasticsearch Network settings documentation for more information.

To know more about how to set up Elasticsearch, please refer to the Installing Elasticsearch guide and Set up Elasticsearch documentation on prerequisites, available from the Elasticsearch Reference online help. 

Print server 

PrintServer_2.21.0.zip file

Technical manual update (Oracle database 12.1)

If your V12 solution has already been installed with version 12.1 of the Oracle database, you must check the value of the deferred_segment_creation parameter:

 If the value is true, you have to manually set it to false:

Installation of the patch

x3-patch-12.0.24.zip file for Sage X3; x3hr-patch-12.0.24.zip file for Sage X3 HR & Payroll.

The patch must be updated from the Updates function of the Syracuse server (Administration > Utilities > Update > Updates).

The .zip file contains:

Manual actions only for Sage X3 (not Sage X3 HR & Payroll)

Automatic journal STKRE - Improvement and renumbering

The Purchase receipt journal (STKRE) has been updated to improve the posting for Standard cost or Revised standard cost products, as well as products or services containing overheads.

The following lines have been created exclusively for standard or revised standard costs:

A conditional formula has been added to the following lines to exclude standard or revised standard cost products or services:

The posting description has been updated to “Overheads” and the Amount formula includes service overheads on the following line:

 The formula for the Analytical amount has been updated to match the Amount:

To enable customizations or future updates, the lines have been restructured into increments of 10. The following lines have been renumbered:

Note:

Automatic journals are integrated into the X3 parent folder only.
If the automatic journal has been subject to major updates (improvement and renumbering), follow this process:

Automatic journal STKPN - Improvement and renumbering

The Supplier return journal (STKPN) has been updated to improve the posting for Standard cost or Revised standard cost products, as well as products or services containing overheads.

The following lines have been created exclusively for standard or revised standard costs:

A conditional formula has been added to the following lines to exclude standard or revised standard cost products or services:

The posting description has been updated to “Overheads” and the Amount formula includes service overheads on the following line:

The formula for the Analytical amount has been updated to match the Amount:

To enable customizations or future updates, the lines have been restructured into increments of 10. The following lines have been renumbered:

Note:

Automatic journals are integrated into the X3 parent folder only.
If the automatic journal has been subject to major updates (improvement and renumbering), the usual Automatic document comparison (CMPGAU) tool is useless. Follow this process:

Evolution of automatic journal REPAY

Two lines have been added to automatic journal REPAY - Rent: Payments:

The Financial cost column has been added to the Open item schedule grid for the Rent contract type. It represents the interest part of the lease payment (already stored in the existing column Rental amount for each period/month). The Financial cost column is not considered when calculating the current values and rights of use.

This amount is not calculated from the contract characteristics: you need to enter it, or import it.

Reminder:

The REPAY automatic journal is triggered when creating lease payments and posting the Fixed assets entry type (RNTPAYIAS).

Note:

Automatic journals are integrated into the X3 parent folder only.
Before copying them manually to the X3 operating folder from the Automatic journals function (GESGAU), start the Automatic document comparison (CMPGAU) to identify variances.

Documents

Readme files