Patch Information Note 12.0.25
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.
- To install the patch: This cumulative patch will update your solution to the current patch in a single step.
- To install the technical components and perform manual actions: Check the documents from the previous releases. Depending on your current version, you may need to install other components or perform other manual actions to complete this update.
See the other documents from the Index or Previous / Next links.
Installation of mandatory technical components
Configuration console
Console_2.49.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named CONSOLE_2.49.0_ENG.htm or CONSOLE_2.49.0_FRA.htm.
Adxadmin administration server
Adxadmin_93.2.50.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named ADXADMIN_93.2.50_ENG.htm or ADXADMIN_93.2.50_FRA.htm.
Process server
Runtime_93.2.50.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named RUNTIME_93.2.50_ENG.htm or RUNTIME_93.2.50_FRA.htm.
Syracuse server
SyracuseServer_12.10.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named SYRACUSESERVER_12.10.0_ENG.htm or SYRACUSESERVER_12.10.0_FRA.htm.
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
- Download the file.
- Unzip the file and follow the instructions provided in the file named ATP_2.2.0_ENG.htm or ATP_2.2.0_FRA.htm.
Installation of recommended technical components
Print server
PrintServer_2.22.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named PRINTSERVER_2.22.0_ENG.htm or PRINTSERVER_2.22.0_FRA.htm.
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:
- Enter the following command: show parameter deferred_segment_creation
If the value is true, you have to manually set it to false:
- Launch a system connection with sqlplus: rlwrap sqlplus system/...
- Modify the system by changing the spfile init file: alter system set deferred_segment_creation=FALSE scope=spfile.
- Restart the database.
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:
- DELIVERY: for externalized resources
- DIVPAT_Pxx: for presettings (Pxx related to the patch)
- FILES: for standard patches
- INDPAT_Pxx: for additional translations (Pxx related to the patch)
- LAN: for standard patch translations except FRA-ENG
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:
- RNISQL – Received not invoiced (SQL)
- RNIORA – Received not invoiced (Oracle)
Prior to running the queries, you must validate them from the Setup > Usage > Reports > SQL 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:
- STKEO – Line 2: Stock variation line
- STKMC – Line 2: Stock variation line
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:
- Line 7: WIP Debit
- Line 8: WIP Credit
The English line descriptions have also been updated to remove the incorrect parent component or component descriptions:
- Line 1: Stock line - Receipt
- Line 3: Stock line - Issue
- Line 7: WIP Debit
- Line 8: WIP Credit
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:
- Line 1: Balance sheet value (setup unchanged). Line amount = asset value after revaluation - value before revaluation
- Line 2: Accumulated depreciation for a revaluation at FY or period start (setup unchanged). Line amount = accumulated depreciation value after revaluation - value before revaluation
- Line 3: Revaluation difference (updated) for a positive revaluation with no profit or loss. Line amount = net value after revaluation - net value before revaluation
- Line 4: Loss on negative revaluation (updated) at FY end. Line amount = loss value - revaluation reversal
- Line 5: Profit on positive revaluation (updated). Line amount = profit value
- Line 6: Deferred tax at 25% for Portugal (setup unchanged). Line amount = (net value after revaluation - net value before revaluation - profit/loss amount) * 25%
- Line 7: Deferred tax at 25% for Portugal (setup unchanged). Line amount = (net value after revaluation - net value before revaluation - profit/loss amount) * 25%
- Line 8: Accumulated depreciation for a revaluation at FY end (setup unchanged). Line amount = accumulated depreciation value after revaluation - value before revaluation
- Line 13: Revaluation difference (new line) on a positive revaluation with a profit amount. Line amount = net value after revaluation - net value before revaluation - profit amount
- Line 23: Revaluation difference (new line) on a negative revaluation with a profit amount. Line amount = net value after revaluation - net value before revaluation
- Line 33: Revaluation difference (new line) on a negative revaluation at FY end with a loss. Line amount = net values difference - loss + revaluation reversal
- Line 43: Revaluation difference (new line) on a negative revaluation at FY or Period start with a loss. Line amount = net values difference - loss
- Line 44: Loss on negative revaluation (new line) on a negative revaluation at FY or Period start with a loss. Line amount = loss
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:
- Financial Overview (PJM): SPE_WIP1 for WIPCOST
- Work order (creation and deletion): SPE_MCC0 for MFCMAT and SPE_MCW0 for MFCWST
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:
- AMT 12: EXERVADEV = Revaluation surplus at FY start
- AMT 13: PERRVADEV = Revaluation reversal on closed periods
- AMT 14: RVACRB = Origin revaluation reversal
- AMT 15: RVACRBD = Destination revaluation reversal
- AMT 16: RVATYP = Revaluation type (1-FY start, 2-Period start, 3-FY end)
- AMT 17: PERCLOCUMO = Origin accumulated depreciation on closed periods
- AMT 18: PERCLOCUMD = Destination accumulated depreciation on closed periods
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
- For technical components: Readme-Components-ENG-12.0.25.txt
- For the application patch: Readme-X3-X3HR-ENG-12.0.25.txt