Patch Information Note 12.0.25
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.49.0.zip file

Adxadmin administration server

Adxadmin_93.2.50.zip file

Process server

Runtime_93.2.50.zip file

Syracuse server

SyracuseServer_12.10.0.zip file

Installation of other technical components

Automated Test Platform

Automated Test Platform is a new technical licensed component, intented to create automated tests for Sage X3 products, using Cucumber tools.  

atp-2.2.0-win.zip file

Installation of recommended technical components

Print server 

PrintServer_2.22.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.25.zip file for Sage X3; x3hr-patch-12.0.25.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)

SQL query updates for RNI (Received not invoiced)

In the SQL query tool (GESALQ) function, the queries below have been updated to include partial invoices linked to purchase orders:

Prior to running the queries, you must validate them from the Setup > Usage > ReportsSQL query tool function by clicking Validate.   

Automatic journals STKEO and STKMC improvement

The Production reporting (STKEO) and Material tracking (STKMC) journals have been updated to prevent imbalances when WIP posting is deactivated but Anglo-Saxon stock accounting is activated.

A conditional formula has been added to the following lines to activate Anglo-Saxon stock accounting:

Material tracking (STKMC) has also been enhanced to include work order reintegration with the conditional formula updated to [F:SJT]TRSTYP=19.

Note:

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

Validate the automatic journals in your applicative folder using the Transaction validation (GENMSKTRT) function, and only select the GAU code in the Transactions grid.

Automatic journal STKDB improvement

The Disassembly (STKDB) journal has been updated to prevent imbalances when the standard cost of a component is updated after the assembly is created. 

 The Amount formula has been updated for the following lines: 

The English line descriptions have also been updated to remove the incorrect parent component or component descriptions: 

Note:

Other languages remain unchanged.

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

Validate the automatic journals in your applicative folder using the Transaction validation (GENMSKTRT) function, and only select the GAU code in the Transactions grid.

Automatic journal FXREV improvement

In the FXREV automatic journal for Fixed assets revaluation, the setup of lines 3, 4 and 5 has been updated and new lines (13, 23, 33, 43, 44) have been created:

Note:

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

Validate the automatic journals in your applicative folder using the Transaction validation (GENMSKTRT) function, and only select the GAU code in the Transactions grid.

Database optimization for Costing tables

To improve performances in the functions below, new indexes have been added as options in the Database optimization (GESANX) function:

To activate and use these indexes, set the Active field to Yes.

Advanced event parameters

In the Setup > Fixed Assets > Advanced event parameters (GESPVT) function, the FASREEVAL event type has been updated.

The two fields used to manage the revaluation reversal (RVACRB and RVACRBD) in the Evt - revaluation (EFASREEVAL) Fixed Assets table have been set up for all depreciation plans to be used when posting the revaluation. These fields are defined in the Numeric table.

The associated script can be validated using the Validation action.

Accounting entry types

In the Setup > Fixed Assets > Accounting entry types (GESTPE) function, the FASREEVAL and FASREEVALIAS entry types have been updated.

The following amounts have been added to the Interface section:

These fields are used in the definition of the FXREV automatic journal for posting the revaluation.

The associated script can be validated using the Validation action.

Documents

Readme files