Patch Information Note 12.0.35
Index
« Previous

Note

This patch is a cumulative patch since the Release 2019 R4 (12.0.19).

Installation of mandatory technical components

Configuration console

Console_2.59.0.zip

Administration service(s)

AdxAdmin_96.2.84.zip

Runtime(s)

Runtime_96.2.84.zip

Syracuse server(s)

SyracuseServer_12.20.0.zip

Print server

PrintServer_2.30.0.zip

X3 Services

X3 Services is a component used to manage Automatic Data Collection and APIs

x3-services-41.0.30-win.zip

Installation of other technical components

X3 Services Dev Studio 

X3ServicesDevStudio is a component used by partners to develop or customize X3 APIs or pages using the xTreem framework.

x3-services-dev-studio-41.0.30.zip

Automated Test Platform

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

atp-3.2.0-win.zip

MongoDB

Mongodb_4.4.26.zip

VT Web Server

VTWebServer_2.42.3.zip

Elasticsearch

If you are using Elasticsearch within your Sage X3 solution, Sage will strongly recommend installing the latest version of Elasticsearch (see prerequisites).

Installation of the patch

x3-patch-12.0.35.zip file

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

The .zip file contains:

Manual actions

Required setup to generate UBL electronic invoices

The XSD file setup is used to generate XML identifiers into the XML mapping rules for e-invoicing.

In each child folder where the EINV activity code is activated, perform the following actions:

Download and unzip the XSDFILES-UBL21 file delivered with the patch.

 

Declarations > E-invoicing > Setup > XSD file upload (GESEINVMAPX)

Select each record from UBL21-01 to UBL21-14, click Upload in the Actions menu for each record and select the file from the unzipped list of files corresponding to the same File name description and click OK.

Declarations > E-invoicing > Setup >XML mapping rules (GESEINVMAP)
Select UBL21 and click Generation and then Validation. Perform the same action for UBLINB.

Displaying miscellaneous table 18: UNECE units of measure 

For child folders, to avoid the message "Table is full" when displaying miscellaneous table 18, update the ADI activity code to 2200 and validate the ADI1 screen by performing the following actions:

DevelopmentData and parametersDevelopment setupActivity codes (GESACV) 
Select the ADI activity code and update the screen size field value to 2200 and click Save in the Actions menu.

Development > Script dictionaryScreens > Screens (GESAMK) 

Select the ADI1 screen and click Validation in the Actions menu.

Automatic journals PIHI, PIHI2, PIHI3, and PIHI4 have been updated  

Setup > Financials > Accounting interface > Automatic journals (GESGAU) 

The lines below have been updated in the following automatic journals to take non-stock management into account at product-site level.

PIHI and PIHI2 automatic journals: 

PIHI3 and PIHI4 automatic journals: 

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 function (CMPGAU) to identify your variances. 

The import template CTR has been udpated

Setup > Usage > Imports/ exports > Import/Export templates (GESAOE)

The entire script has been rewritten in Classic X3 instead of Hybrid due to performance issues. 

The CTR import template is used to create a freight container by specifing purchase order lines to ship. It allows the following actions:

The CTR import template is updated and delivered in the X3 main folder only. To benefit from the CTR import template, update your X3 child folders.

The automatic journal SIHI has been updated

Setup > Financials > Accounting interface > Automatic journals (GESGAU)

Line 30 has been updated in SIHI with a new condition.

Lines 32 and 35 (Main tax (VAT) (POR)) have been added to the SIHI automatic journal for Portuguese legislation requirements.

Formula 13 Amount: func TRTX3FNC.GETAMTTAXNOSUBMIT ([F:SID]NUM, [F:SID]SIDLIN, 2, 3,[F:SIH]CUR)

Formula 35 Analytical amount: func TRTX3FNC.GETAMTTAXNOSUBMIT([F:SID]NUM, [F:SID]SIDLIN, 2, 3,[F:SIH]CUR)

Formula 13 Amount: func TRTX3FNC.GETAMTTAXSUBMIT([F:SID]NUM, [F:SID]SIDLIN, 2, 3,[F:SIH]CUR)

Formula 35 Analytical amount: func TRTX3FNC.GETAMTTAXSUBMIT([F:SID]NUM, [F:SID]SIDLIN, 2, 3,[F:SIH]CUR)

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 function (CMPGAU) to identify your variances.

The setup of queries to display on hold and released sales orders in the EXEALH function has been updated

In each child folder, perform the following actions:

Setup > Usage > Reports > SQL query tool (GESALQ)

Documents

Readme files