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.
Console_2.52.0.zip file
Adxadmin_94.1.9.zip file
Runtime_94.1.9.zip file
SyracuseServer_12.13.0.zip file
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.
X3 Services is a new component used to manage Automatic Data Collection.
x3-services-11.0.43-win.zip file
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
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:
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:
- 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
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.
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.
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.
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.
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:
Setup > Fixed Assets > Accounting 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).
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.