Patch Information Note 12.0.26
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 using the Index or Previous/Next links. Depending on your current version, you may need to install other components or perform other manual actions to complete this update.
Installation of mandatory technical components
Configuration console
Console_2.50.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named CONSOLE_2.50.0_ENG.htm or CONSOLE_2.50.0_FRA.htm.
Adxadmin administration server
Adxadmin_93.2.56.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named ADXADMIN_93.2.56_ENG.htm or ADXADMIN_93.2.56_FRA.htm.
Process server
Runtime_93.2.56.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named RUNTIME_93.2.56_ENG.htm or RUNTIME_93.2.56_FRA.htm.
Syracuse server
SyracuseServer_12.11.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named SYRACUSESERVER_12.11.0_ENG.htm or SYRACUSESERVER_12.11.0_FRA.htm.
Print server
PrintServer_2.23.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named PRINTSERVER_2.23.0_ENG.htm or PRINTSERVER_2.23.0_FRA.htm.
VT web server
VTWebServer_2.39.1.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named VTWEBSERVER_2.39.1_ENG.htm or VTWEBSERVER_2.39.1_FRA.htm.
Installation of other technical components
X3 Services (only for Sage X3 ,not Sage X3 HR & Payroll)
X3 Services is a new component to manage Automatic Data Collection.
x3-service-5.0.47-win.zip file
- Download the file.
- Unzip the file and follow the instructions provided here in the online help.
Automated Test Platform
The Automated Test Platform is a technical licensed component intended to create automated tests for Sage X3 products, using Cucumber tools.
atp-2.3.0-win.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named ATP_2.3.0_ENG.htm or ATP_2.3.0_FRA.htm.
Installation of recommended technical components
MongoDB
Mongodb_4.2.12.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named MONGODB_4.2.12_ENG.htm or MONGODB_4.2.12_FRA.htm.
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.
- If you're using an Oracle JAVA platform, please note that the prerequisites have evolved. Please refer to the How to upgrade to MongoDB 4.2 documentation for more information.
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.26.zip file for Sage X3; x3hr-patch-12.0.26.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)
Matching the automatic journals MTE, MTP & MTR
In the Setup > Financials > Accounting interface > Automatic journals (GESGAU) function, the MTE, MTP, and MTR automatic journals have been updated at the formula level.
This change applies to the status formula to take the FRADGI parameter into account.
The description of these automatic journals has been updated as follows:
Line 2: The new formula is: "(func AFNC.PARAM("FRADGI",[F:MTU]FCY)="2")*2 + (func AFNC.PARAM("FRADGI",[F:MTU]FCY)<>"2")"
Line 2: The new formula is:"(func AFNC.PARAM("FRADGI",[F:HAE]FCY)="2")*2 + (func AFNC.PARAM("FRADGI",[F:HAE]FCY)<>"2")"
Note:
- Automatic journals have been 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.
Project management (PJM)
Credit memos displayed in financial overviews
Customer credit memos are now displayed in the Revenue section of the project financial status, replacing the Total revenue field.
This improvement is available for new customers.
To make sure that this update will not overwrite any existing setup, existing customers who want to enable this improvement will have to manually update the setup of the financial overview structure and queries:
- In the Financial overview structure (GESPJS) function, the title of sequence 062 must be set to “Credit memos” instead of “Total revenue” and the associated data type must be set to “Amount”.
- In the Financial overview queries (GESPJQ) function, sequences 053 and 054 must be set to “Subcol1. calculation”.
Accounting entry type DEPRECIAS
In the Setup > Fixed Assets > Accounting entry types (GESTPE) function, the DEPRECIAS accounting entry type has been updated with "AMT" set to 6 instead of 3 and the "RVACRBDEV" source field.
For revaluated assets, complementary tax depreciation lines used to be generated instead of revaluation reversal lines.
Note:
The entry type is directly installed on the application folder. You can validate it from the Accounting entry types (GESTPE) function by clicking the Validation action.
Automatic journal FXISS
In the Setup > Financials > Accounting interface > Automatic journals (GESGAU) function, lines 8 and 9 have been removed from the FXISS automatic journal used for fixed asset disposal:
If a valuated asset disposal is canceled, the revaluation surplus and the revaluation reversal were not correctly posted as this was also managed by the depreciation entry. From now on, the entry of these amounts is managed from the FXDPR automatic journal.
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.
Bad debt management
The following automatic journals have been defined for the American (USA), Spanish (SPA), and Portuguese (POR) legislations:
- BDDBR - Doubtful receivables Bad Debts
- BDIMP - Impairments Bad Debts
- BDWO - Write off - Bad Debts
These automatic journals will be used in the bad debt process to create the corresponding journal entries.
They must be set in the Parameter values (ADPVAL) function in the CPT chapter, CLO group:
- GAUBDTDOU - Bad debts - Doubtful debts
- GAUBDTDWO - Bad debts - Write-off
- GAUBDTIPR - Bad debts - Impairment
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 (if you applied customizations).
Documents
Readme files
- For technical components: Readme-Components-ENG-12.0.26.html
- For the application patch: Readme-X3-X3HR-ENG-12.0.26.html