Patch Information Note 12.0.28
Index
« Previous Next »

Note

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

Installation of mandatory technical components

Configuration console 

Console_2.52.0.zip file

Adxadmin administration server

Adxadmin_94.1.9.zip file

Process server

Runtime_94.1.9.zip file

Syracuse server

SyracuseServer_12.13.0.zip file

Installation of recommended technical components

Elasticsearch

You can use Elasticsearch 7.13 with Sage X3.

Although Sage X3 is still compatible with previous releases, Sage strongly recommends you install this new version.

Installation of other technical components 

X3 Services (only for Sage X3, not Sage X3 HR & Payroll)

X3 Services is a new component used to manage Automatic Data Collection.  

x3-services-11.0.43-win.zip file

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-2.5.0-win.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.28.zip file for Sage X3; x3hr-patch-12.0.28.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)

PIHI2 automatic journal 

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

For a company using the Portuguese legislation, the invoicing elements were counted twice when posting a purchase credit note from a purchase return with an invoicing element. In that context, the PIHI2 - Supplier Invoice Increase Line automatic journal is triggered.

To fix the unbalanced journal issue, the setup of line 25 - Item line credit note (POR) has been updated with the following formula in the Amount field (line 13), to exclude the invoicing element already included in line 120: [F:PID]AMTNOTLIN+sigma(I=1,9,evalue("[F:PID]DISCRGAMT"+num$(I))*([F:PIV]INVDTAVAT2(I-1)=""))

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.

VAT automatic journal evolution

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

In the VAT - VAT return automatic journal for VAT return posting, line 30 - VAT adjustment balance has been created. This line calculates and posts the VAT adjustment balance, if any, and if the calculation is set up in the VAT form.
This line uses a new accounting code line available in the site and company accounting codes.

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.

CIUS-PT EDI setup (Portugal) 

The CIUS-PT EDI setup has been introduced to generate electronic invoices using the new UBL 2.1 format required by the Portuguese public administration.

This setup patch contains the CIUSPTUBL message mapping, the list of XSD files (CIUSPTUBL to CIUSPTUBL8), the setup of the XML CIUSPTUBL file, and the CIUSPTUBL flow.

Swiss VAT declaration

From version 2021 R4 (V12.0.28) and higher, the Swiss VAT declaration has been included in the VAT framework. 
The previous Swiss VAT declaration function has been deprecated.

This new function provides a default setup for the new DCLVATSWI VAT box in the VAT boxes (GESVTB) function and the new DCLVATSWI  form in the VAT form (GESVEF) function for existing users. The default setup is based on the standard VAT setup for the Swiss legislation (VAT codes, etc.).
To use this new declaration, it is mandatory to review and adapt these settings according to your VAT configuration.
You will find further documentation on the basics of the VAT framework in the online help and in the Swiss legislation guide.

PSRPR automatic journal update 

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

The PSRPR - Provisions: Depreciation automatic journal for renewal tax provisions posting has been updated.

Modification of line 3 - Depreciation Renewal Tax

Modification of line 4 - Renewal Provision Tax

Addition of line 5 - Reversal Renewal Tax

Addition of line 6 - Renewal Provision Tax

Important

To install these fixes on your folder, once the patch list has been integrated, you need to:

CCNRPR accounting entry type update

Setup > Fixed AssetsAccounting entry types (GESTPE)

The CCNRPR - Renewal provisions - Deprec accounting entry type for provisions for renewal (concessions) has been updated in the Interface section.

Reminder

Addition

Important

The entry type is installed directly in the applicative folder. 
Click the Validation action to validate the entry type in this function (GESTPE).

VAT date utility: Important note for VAT framework users

If you are using the Sage X3 VAT framework, you need to launch a utility before processing your next declaration. 

This utility populates a new field, the VAT date, in the Accounting entries (GACCENTRY) table for all existing journal entries:

Recommendations

How to launch the utility

Note:

To ensure the accuracy of the declaration, a message has been added to warn you that you have to launch the utility before trying to launch a declaration extraction. It also mentions which utility code you need to run.

Documents

Readme files