Update | Informations | Sage X3 functions |
1 (1-676) | File : X3_ProductUpdate_11.0.1.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.1.zip.
Console Download file SafeX3_Console_235.zip.
Attention to the integration time of this update on large volumes for tables : ASYSSMDBASSO, ASYSSMEXTERN, ASYSSMINTERN, BOSIMP, BPCUSTOMER, BSIBPRNUM, BSIDUD, BSIFILFMT, BSIIMP, BSIIMPPAR, BSIINVDIO, BSISCT, BSISCTD, BSISEALIS, BSISEALISD, DIETRS, EDICATL, EDITMPDOC, FUP, FUPGRP, GDIE, HDKTRS, JSNX3DET, JSNX3HEAD ... Pay attention to have enough space in Oracle tablespaces. After integration
Module Sales * ELINV (Electronic invoice)Module Manufacturing * POPS (Production Scheduler)
Module Manufacturing * POPSCALEXP (Calendar exception)* POPSMRK (Planner One marker) * POPSPIN (Operation pin type) * POPSTAG (Planner One tag) * POPSWOS (Prod. Scheduler WO suggestions) Module Common Data * JSNX3DET (JSON-X3 transform map detail)* JSNX3HEAD (JSON-X3 transformation mapper) * JSNX3TRAN (JSON-X3 transport) Module Development * BOSIMP (Subcontract BOM)
Module Manufacturing * FUNPSMOPT (Submit for scheduling)* FUNPSSCH (Production Scheduler) * FUNPSVIEW (Production Scheduler viewer) * GESMOD1 (Weighing scale templates) * MMPS (Production Scheduler) * PSOPTFREE (Remove from scheduling)
Chapter CPT (Accounting) * VATLINGNR (VAT line generation)Chapter LOC (Localisations) * RSABODY (Body)* RSACERT (Certificate) * RSADEST (Destination) * RSASIGN (Activate) * RSASMTP (Notification) * RSASUBJECT (Subject) * RSASUBTITL (Subtitle) * RSATHEME (Theme) * RSATITLE (Title) Chapter SUP (Supervisor) * CPYMAXLEN (Max size of company codes)* CPYMINLEN (Min size of company codes) * FCYMAXLEN (Max size of site codes) * FCYMINLEN (Min size of site codes) Chapter TC (Common Data) * PJMOPECST (Operation labor rate priority)* SEPARCODE (Field separator) Chapter TRS (Acc Payable/Acc Receivable) * HEAAMTBPC (Cust. inv. header amt. ctrl)* HEAAMTBPS (Supplier inv. header amt. ctrl) * WRNMSGBPC (Customer inv. warning msg.) * WRNMSGBPS (Supplier invoice warning msg.)
Module Financials * GST (GST detail)Module Common Data * LEGICNDCPY (Invoicing terms)* PIMPLIMP (Chargeable lines) * PJMBUDPRO0 (Budget progress) * PJMBUDPROG (Budget progress) * PJMBUDTREE (Cost structure) * PJMTASTREE (Task planning) * PJMTSKTRCA (Assignments) * PJMTSKTRFUL (Operational data) * PJMTSKTRFULU (Operational data) Module Fixed Assets * FASPHYMVT (Assets with pending element)
Module A/P-A/R accounting * BSIBPRNUM (BP number definition)* BSIFILFMT (Bank import format definition) * BSIIMP (Bank transaction management) * BSIIMPPAR (Bank import settings) * BSIINVDIO (Invoice number definition) * BSISCT (Bank import segment definition) * BSISEAEXD (Excluded terms) * BSISEALIS (Search term list) Module Purchasing * PPRICSEARCHM (Purchase price inquiry)* SHIPMENT (Shipment) Module Manufacturing * POPSENV (Prod. Scheduler environment)* POPSENVUPD (Prod. Scheduler environment) Module Common Data * CCMIMPFOH (Impact analysis-Forecasts)* CCMIMPSOH (Impact analysis-Sales orders) * EDIXMLFILP (EDI XML files) * EDIXSDUPL (EDI XSD file download) * JSNX3HEAD (JSON-X3 transformation mapping) * JSNX3TRAN (JSON-X3 transport mapping) * OPPOR (Project) * TABPAYTERMM (Payment terms) * TCWPOCSIG (Signed open orders) * TCWPOCSIGHIS (Signed open orders history) * TCWPOCSIGM (Signed open orders) * TCWPOCTOSIG (Open orders to be signed) * TCWPOCTOSIGM (Open orders to be signed) * TCWPOHSIG (Signed purchase orders) * TCWPOHSIGHIS (Signed order hist) * TCWPOHSIGM (Signed purchase orders) * TCWPOHTOSIG (Purchase orders to be signed) * TCWPOHTOSIGM (Purchase orders to be signed) * TCWPSHSIG (Signed requests) * TCWPSHSIGHIS (Signed purchase request hist) * TCWPSHSIGM (Signed requests) * TCWPSHTOSIG (Requests to sign) * TCWPSHTOSIGM (Requests to sign) * TCWPXXHIS (Signed document hist) * TCWSOCSIG (Signed open orders) * TCWSOCSIGHIS (Signed open orders history) * TCWSOCSIGM (Signed open orders) * TCWSOCTOSIG (Open orders to be signed) * TCWSOCTOSIGM (Open orders to be signed) * TCWSOHSIG (Signed sales orders) * TCWSOHSIGHIS (Signed order hist) * TCWSOHSIGM (Signed sales orders) * TCWSOHTOSIG (Sales orders to be signed) * TCWSOHTOSIGM (Sales orders to be signed) * TCWSQHSIG (Signed quotes) * TCWSQHSIGHIS (Signed quote hist) * TCWSQHSIGM (Signed quotes) * TCWSQHTOSIG (Quotes to sign) * TCWSQHTOSIGM (Quotes to sign) * TCWSXXHIS (Signed document hist)
* BOMP (Production Bill of Materials) * BOMS (Subcontracting BOM)
Translation corrections have been performed. | New functions : Manufacturing/Production Scheduler/Submit for scheduling Manufacturing/Production Scheduler/Production Scheduler Manufacturing/Production Scheduler/Production Scheduler viewer Common data/Manufacturing tables/Weighing scale templates Manufacturing/Production Scheduler Manufacturing/Production Scheduler/Remove from scheduling |
Update | Informations | Sage X3 functions |
| File : X3_ProductUpdate_11.0.1B.zipMandatory |
Update | Informations | Sage X3 functions |
2 (677-1292) | File : X3_ProductUpdate_11.0.2.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.2.zip.
Console Download file SafeX3_Console_236.zip.
Attention to the integration time of this update on large volumes for tables : AMIGKEY, ATEXTE, AWRKHISMES, AWRKHISSUI, AWRKPAR, AWRKTRND, BCKITOREN, BPCUSTOMER, BSEINQ, BSIFILFMT, BSIFILFMTD, BSISCT, BSISCTD, CONTACTCRM, DCLVATPORP, DMWBPREXC, DMWPAORD, DMWPRODPACKD, DMWPRODPACKH, DMWQTY, DMWQUOTAD, DMWQUOTAH, DMWSCHEME ... Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * DSP (Number of analytical allocation lines)Module Sales * ELINV (Electronic invoice)Module Common data * DMW (Waste disposal management)
Module Financials * BSEINQ (Balance sheet inquiry)* WHTDTL (WHT detail) * WHTHDR (WHT header) Module Common Data * DMWBPREXC (Waste disposal exceptions)* DMWPAORD (Waste disposal management) * DMWPRODPACKD (Product packaging assignment) * DMWPRODPACKH (Product packaging assignment) * DMWQTY (Waste disposal quantity) * DMWQUOTAD (Waste management quota) * DMWQUOTAH (Waste management quota) * DMWSCHEME (Waste disposal scheme) * DMWWEIGHT (Waste disposal weight) * EVCRESULT (EU VAT ID check result) * GACCOUNTA (Accounts (additional table))
Module Financials * CONSBSE (Balance sheet inquiry)* DCLVATPORI (Export / Import declaration) * GESWHT (Withholding tax report) * GESWHTA (Withholding tax report archive) Module Sales * FUNAUTINVSCH (Schedule invoice generation)* GESCRMSFS01 (Sales order) Module Manufacturing * CRERVV (Version revision)Module Common Data * CONSDMWD (Detailed calculation results)* CONSDMWG (Grouped calculation results) * DMWBAT (Waste disposal calculation) * DMWPA (Austria) * EVCBAT (EU VAT ID revalidation) * GESDMWBPREX (Waste disposal exceptions) * GESDMWPAORD (Waste disposal management) * GESDMWPPA (Product packaging assignment) * GESDMWQUOTA (Waste management quota) * GESDMWSC (Waste disposal scheme) * GESPJM (Project management) * GESPSO (Sold product management) * GESSFTTEM (Teams) * GESTEM (Teams) * MDMW (Waste disposal management) * MDMWP (Processings) * MDMWS (Setup) * MOTHD (Other declarations) * MPBD (Payment balance declaration) * MPBDP (Processings) * MPBDS (Setup) * MPJM (Project management) * PJMACTAFCP (Project copy) * PJMFINOV0 (Financial overview) * PJMRPTEXT (Financial report extraction) * PJMSOQSYN (Sales order resynchronization) * PJMTE (Time entry)
Chapter AAS (Fixed assets) * WIPDEP (Amort. en-cours plans libres)Chapter CPT (Accounting) * EVCCOMPANY (EU VAT ID source company)* EVCCONFIRM (EU VAT ID confirmation letter) * EVCSERVICE (Webservice for EU VAT ID check) Chapter LOC (Localisations) * RSABODY (Body)* RSACERT (Certificate) * RSADEST (Destination) * RSASIGN (Activate) * RSASMTP (Notification) * RSASUBJECT (Subject) * RSASUBTITL (Subtitle) * RSATHEME (Theme) * RSATITLE (Title) Chapter TC (Common Data) * PJMAUSCST0 (Allow time entry costs to 0)* SFCRM (Salesforce CRM integration) * SFCRMCAT (Salesforce customer category) Chapter VEN (Sales) * INVCNDFREE (Free item invoicing term)
Module Financials * WHT (WHT detail)Module Common Data * PJMOPPPAF (Assigned projects)* PJMTENT (Time entry)
Module Supervisor * AUTILISINI (User initialization)Module Sales * SINVOICEV (Sales invoice)* SORDER (Orders) * SVCRINVCND (Scheduled invoice) Module Common Data * BPCCATEG (Customer category)* BPCUSTOMER (Customers) * BPCUSTOMERM (Customers) * EDIPURGE (EDI purge) * ITMCATEG (Product category) * ITMMASTER (Products) * ITMSALES (Products - sales) * PJMCOSTCTR (Cost type)
* 903 (Parameter group)
* SFCCN (Salesforce contact number)
* GAC1 (G/L Accounts)
Translation corrections have been performed. | New functions : Financials/Inquiries/Balance sheet inquiry Declarations/Tax management/Portugal/Processings/Export / Import declaration Sales/Invoices/Schedule invoice generation Declarations/Other declarations/Waste disposal management/Processings/Austria/Detailed calculation results Declarations/Other declarations/Waste disposal management/Processings/Austria/Grouped calculation results Declarations/Other declarations/Waste disposal management/Processings/Waste disposal calculation Declarations/Other declarations/Waste disposal management/Processings/Austria Common data/BPs/Utilities/EU VAT ID revalidation Declarations/Other declarations/Waste disposal management/Setup/Waste disposal exceptions Declarations/Other declarations/Waste disposal management/Setup/Waste disposal management Declarations/Other declarations/Waste disposal management/Setup/Product packaging assignment Declarations/Other declarations/Waste disposal management/Setup/Waste management quota Declarations/Other declarations/Waste disposal management/Setup/Waste disposal scheme Project management/Sold product management Common data/Manufacturing tables/Teams Common data/Manufacturing tables/Teams Declarations/Other declarations/Waste disposal management Declarations/Other declarations/Waste disposal management/Processings Declarations/Other declarations/Waste disposal management/Setup Declarations/Other declarations Declarations/Other declarations/Payment balance declaration Declarations/Other declarations/Payment balance declaration/Processings Declarations/Other declarations/Payment balance declaration/Setup Project management/Project copy Project management/Financial overview Project management/Financial report extraction Project management/Sales order resynchronization Project management/Time entry |
Update | Informations | Sage X3 functions |
| File : X3_ProductUpdate_11.0.2B.zipMandatory |
Update | Informations | Sage X3 functions |
3 (1293-1749) | File : X3_ProductUpdate_11.0.3.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.3.zip.
Console Download file SafeX3_Console_239.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : AWRKHISSUI, BALAGEEOY, BSEINQ, DMWSCHEME, EDIBPRPAR, EDICATREF, EDICPYPARD, EDIFLOD, EDITMPDOC, EDIXMLFIL, EDIXMLFILD, EDIXMLFILF, EDIXMLFILP, EDIXMLFILXSD, GLED, MFGITM, OPERATIONS, PARMRP, PINVOICED, PJMTIMEMP, PJMTSK, POPSOBJ, PORDERP ... Pay attention to have enough space in Oracle tablespaces. After integration
Module Sales * ECM (E-commerce)Module Manufacturing * POPSN (Production Scheduler)
Module Financials * BALAGEEOY (EOFY aged overdue invoice list)Module Manufacturing * POPSOBJ (Objects in PS)Module Common Data * TIMEADJUST (Daylight saving time)* TIMETRANS (Change to daylight saving time) * TIMEZONEINFO (Time zones)
Module Financials * CONSRSA (Recapitulative statement)* CONSTRA (VAT declaration) * DCLVATAUT3 (Recapitulative statem. param.) * DCLVATAUT4 (VAT declaration parameter) * DCLVATAUT5 (Report line definitions) * MAUTP (Processings) * MAUTS (Setup) Module Common Data * CONSDMWDD (Detailed calculation results)* CONSDMWGD (Grouped calculation results) * DMWPD (Germany)
Chapter LOC (Localisations) * FACTURAE (Facturae format)Chapter SUP (Supervisor) * DUPCNTNAME (Duplicate contact authorized)
Module Common Data * PJMOPPAUS (Assigned projects)
Module Financials * PROJET (Project )Module Manufacturing * TABWRKCTR (Work center groups)* WORKSTATIO (Work centers) Module Common Data * EDIBPRPAR (EDI partners by BP)* EDICPYPAR (EDI partners by company) * EDIFIL (Files) * EDIFLO (Flow) * EDIMSG (Message mapping) * EDIPIHFACE (Purchase invoice) * EDISIHFACE (Sales invoices) * EDIXMLFIL (EDI XML files) * EDIXMLFILDUP (EDI XML files) * TIMEADJUST (Daylight saving time) * TIMETRANS (Change to daylight saving time) * TIMEZONEINFO (Time zones)
* POCSIGNOT (Signature notification) * POCSIGREJ (Contract rejection) * POCSIGVAL (Contract signature) * POHSIG (Order signatures management) * POHSIGNOT (Signature notification) * POHSIGREJ (Order rejection) * POHSIGVAL (Order signature) * PSDSIG (PR line signatures management) * PSDSIGNOT (PR line signature notification) * PSDSIGREJ (PR line rejection) * PSDSIGVAL (PR line signature) * PSHSIG (PR signatures management) * PSHSIGNOT (PR signature notification) * PSHSIGREJ (PR rejection) * PSHSIGVAL (PR signature) * SOCSIG (Open order signature mgmt) * SOCSIGNOT (Signature notification) * SOCSIGREJ (Open order rejection) * SOCSIGVAL (Open order signature) * SOHSIG (Order signature mgmt) * SOHSIGNOT (Signature notification) * SOHSIGREJ (Order rejection) * SOHSIGVAL (Order signature) * SQHSIG (Quote signature mgmt) * SQHSIGNOT (Signature notification) * SQHSIGREJ (Quote rejection) * SQHSIGVAL (Quote signature)
* 317 (Tax stamp)
* BPCIN (Customer Invoice- A/R) * SIHI (Customer Invoice (sales)) * SIHI2 (Customer Invoice Increase Line) * SIHI3 (Customer Inv with footer & ana) * WIP (Work in Progress) These journals are integrated to the X3 folder.
Translation corrections have been performed. | New functions : Declarations/Tax management/Austria/Processings/Recapitulative statement Declarations/Tax management/Austria/Processings/VAT declaration Declarations/Tax management/Austria/Setup/Recapitulative statem. param. Declarations/Tax management/Austria/Setup/VAT declaration parameter Declarations/Tax management/Austria/Setup/Report line definitions Declarations/Tax management/Austria/Processings Declarations/Tax management/Austria/Setup Setup/Declarations/Declarations Setup/Setup Declarations/Other declarations/Waste disposal management/Processings/Germany/Detailed calculation results Declarations/Other declarations/Waste disposal management/Processings/Germany/Grouped calculation results Declarations/Other declarations/Waste disposal management/Processings/Germany |
Update | Informations | Sage X3 functions |
4 (1750-1960) | File : X3_ProductUpdate_11.0.4.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.4.zip.
Production scheduler Installation : Download file SafeX3ProductionScheduler-11.004.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : BALAGEEOY, CACCEDEF, OPPORCRM, OPPORPJM, PJMSALITMD, POPSPIN Pay attention to have enough space in Oracle tablespaces. After integration
Module Development * TABINVCNDSIM (Simulation)Module Fixed Assets * PHYELT (Physical assets)* PHYLCT (Location)
* STKUV (No Absorbed Value after update) These journals are integrated to the X3 folder.
Translation corrections have been performed. |
Update | Informations | Sage X3 functions |
5 (1961-2235) | File : X3_ProductUpdate_11.0.5.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.5.zip. Some tables are modified; mind the integration time for this update on large volumes for tables : BALAGEEOY, BSIELTMAP, BSIELTMAPD, BSIFILFMT, BSIFILFMTD, BSIIMPD, BSIIMPDS, BSIIMPPAR, BSISCT, BSISCTD, BSISEALISD, GLED, KPYIMPTRAN, MACHINES, PJMAUS, POPSCALEXP, POPSCUSFLDS, POPSCUSVALS, POPSMRK, POPSOBJ, POPSPIN, POPSTAG, SFTTXN, SFTTXNH ... Pay attention to have enough space in Oracle tablespaces. After integration
Module A/P-A/R accounting * BSIELTMAP (Camt element mapping detail)* BSIELTMAPD (Camt element mapping) * BSIIMPDS (Bank statement imp. sub-detail) Module Manufacturing * POPSCUSFLDS (Prod. Sched. custom fields)* POPSCUSVALS (Prod. Sched. custom values)
Module Financials * GESGST (GST report)* GESGSTA (GST report archive) * MAUS (Australia) * MAUSG (GST report) * MAUSW (Withholding tax report) Module Manufacturing * GESPOPSCV (Prod. Sched. custom values)Module Common Data * PJMBUDTRQ (Financial overview queries)* PJMBUDTRS (Financial overview structure)
Module A/P-A/R accounting * BSIBPRNUMDUP (BP number definition)* BSIELTMAP (Camt element mapping) * BSIELTMAPDUP (Camt element mapping) * BSIFILFMTDUP (Bank import format definition) * BSIIMPPARDUP (Bank import settings) * BSIINVDIODUP (Invoice number definition) * BSISCTDUP (Bank import segment) * BSISEALISDUP (Search term list) Module Common Data * EDIXMLFILD (EDI XML files)* PJMBUDTRQ (Financial overview queries) * PJMBUDTRS (Financial overview structure)
* ROU (Routes)
* STKCN (Sales Credit note) * STKDB (Disassembly) * STKEN (Misc. Receipt) * STKEO (Production reporting) * STKHD (Customer Service consumption) * STKIN (Stock Count) * STKIS (Misc. Issue) * STKMC (Material tracking) * STKPN (Supplier return) * STKRC (Material consumpt SC receipt) * STKSC (Inter-site transfer) * STKSD (Sales delivery) * STKSI (Sales invoice) * STKSR (Customer return) * STKUV (No Absorbed Value after update) These journals are integrated to the X3 folder.
Translation corrections have been performed. | New functions : Declarations/Tax management/Australia/GST report/GST report Declarations/Tax management/Australia/GST report/GST report archive Declarations/Tax management/Australia Declarations/Tax management/Australia/GST report Declarations/Tax management/Australia/Withholding tax report Manufacturing/Production Scheduler/Prod. Sched. custom values |
Update | Informations | Sage X3 functions |
6 (2236-2637) | File : X3_ProductUpdate_11.0.6.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.6.zip. Some tables are modified; mind the integration time for this update on large volumes for tables : ABLOB, ACLOB, BPADDRESS, BSIIMP, BSIIMPPAR, CASHPAYSPA, DCLVATPORH, DCLVATPORL, EDIXMLFILD, EDIXSDUPLLOB, ELOFCIM, GSTDTL, GSTHDR, OPPORSTA, OPPORSTB, PAREVT, PAREVTD, PJMAFF, PJMAUS, PJMBUD, PJMBUDLIG, PJMBUDTRQ, PJMBUDTRS, PJMCLOB, PJMCOSTCTR ... Pay attention to have enough space in Oracle tablespaces.
Production scheduler Print server EDT.213 After integration
Module Common Data * DATEV (DATEV)
Module Financials * CONSVCI (VAT code inconsistency)* FUNPNH (Credits to receive) * FUNPTH (Invoice receivables) Module A/P-A/R accounting * BSIRAPBAN (Bank statement reconciliation)* CONSCAA (Counter account analysis) Module Manufacturing * FUNPSFDMAUPD (Recalculate work order FDMA)Module Common Data * EDIXMLFIL (XML file)* EDIXSDUPL (EDI upload XSD file) * TRACKTPL (Logistical tracking template)
Chapter CPT (Accounting) * LOWMTCGEN (Exch rate var / low matching)Chapter EXAPP (External applications) Chapter LOC (Localisations) * GERDATDIS (DATEV)* GERDATLEN (DATEV)
Module Financials * UKPAYPRACST3 (UK Payment practices)* UKPAYPRACTI (UK Payment practices) Module Common Data * DESPJMTSKOPE (Operation description)
Module Common Data * EDIRUNISS (EDI issues generation)* EDIRUNREC (EDI receipts generation) * TRACKTPL (Logistical tracking template)
* PHYAE (Physical assets AE)
These journals are integrated to the X3 folder.
Translation corrections have been performed.
For users of EDI module who need to receive or send EDI messages in XML format, it is recommended to install the patch 'V11_EDI_NewFeaturesP6.dat' delivered within DIVEDI directory. As for others EDI messages, EDIX3 activity code must be active. This patch contains : After this patch installation, it is mandatory to access to EDI setup functions to save it in Mongo data base before using them. | New functions : Financials/Interfaces/DATEV/VAT code inconsistency Financials/Closing processings/Credits to receive Financials/Closing processings/Invoice receivables Financials/Interfaces/DATEV/Counter account analysis Manufacturing/Production Scheduler/Recalculate work order FDMA |
Update | Informations | Sage X3 functions |
 7 (2638-3052) | File : X3_ProductUpdate_11.0.7.zipThe integration of this patch will trigger a validation of all X3 requests. The time of integration can be lengthened according to the number of requests present in the folders Before integration
Syracuse server Download file SafeX3_Syracuse_11.7.zip.Unzip the file and follow instructions in file named SAFEX3SYRACUSE_11.7_ENG.htm. After updating the Syracuse server : empty your Internet browser cache before logging in. Some tables are modified; mind the integration time for this update on large volumes for tables : CASHPAYSPA, DATEVTAX, DKSKEY, DPRMOD, ECCVAL, GDPDUDUD, PJMTSKITM, RPLWST, TABPAM, TEXCPT Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * GDPDUDUD (Open items)
Module Financials * BUDGET (Budget entry)
Chapter VEN (Sales) * SDHTYPNINV (Nonbillable delivery type)
Module Common Data * VCONTIME4 (Service contract)
Module Sales * EDISOHEM (Sales order)Module Common Data * EDIPTCDUP (Protocol)
* GDPDU0201 (GDPDU Customer accounting data) * GDPDU0202 (GDPDU Customer header data) * GDPDU0301 (GDPDU Supplier accounting data) * GDPDU0302 (GDPDU Supplier header data) * GDPDU04 (GDPDU Open items) * GDPDU06 (GDPDU Journal entries header) * GDPDU07 (GDPDU Tax codes) * GDPDU0701 (GDPDU Tax rates) * GDPDU08 (GDPDU Hist. open items cust.) * GDPDU09 (GDPDU Hist. open items suppl.) * GDPDU10 (GDPDU Accounting entry lines) * GDPDU11 (GDPDU Receipt type) * GDPDU12 (GDPDU Line code) * GDPDU20 (GDPDU Analytical entries line) * GDPDU21 (GDPDU Sectors) * GDPDU22 (GDPDU Dimensions) * GDPDU23 (GDPDU Anayltical natures) * GDPDUADD (GDPDU Address data) * GDPDUCOA (GDPDU Account plans) * GDPDULED (GDPDU Legders) * SDH (Shipments) * SDHFL (Full shipments) * OPPCRM (CRM Projects) * GDPDU44 (GDPDU Financial Assets) * GDPDU45 (GDPDU Depreciation methods) * GDPDU46 (GDPDU Depreciation rates) * GDPDU47 (GDPDU Depreciation charges) * GDPDU48 (GDPDU Physical elements)
These journals are integrated to the X3 folder.
Translation corrections have been performed.
To use nonbillable delivery, it is recommended to install patch 'V11_NonBillableDeliveries.dat' delivered in DIVSDN directory. It contains:
| New functions : Financials/Budgets/Budget entry |
Update | Informations | Sage X3 functions |
8 (3053-3331) | File : X3_ProductUpdate_11.0.8.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.8.zip. Runtime Download file SafeX3_Runtime_R080.003.zip. Some tables are modified; mind the integration time for this update on large volumes for tables : AGDPRMAI, AGDPRPHONE, AGDPRSETTING, AGDPRVCR, ALISTER, CONTACT, DKSDATA, ELEAACTU, ELEACNL, ELEACRT, ELEAEND, ELEAPAY, ELEARPU, ELEATRM, ITMFACILIT, LEABILBOOK, LEASE, MFGTRS, TMPARPT, TMPSRPT Pay attention to have enough space in Oracle tablespaces. After integration
Module Sales * SDL (No. of lot detail lines)
Module Supervisor * AGDPRSETTING (GDPR setup)* AGDPRVCR (GDPR search)
Module Supervisor * AGDPRMAI (List of email data)* AGDPRPDATA (List of personal data) * AGDPRPHONE (List of phone data) * AGDPRSEA (GDPR search) * ALISTDPOCPY (Contrôle société pour DPD) * GESAGS (GDPR setup) * MGDPR (GDPR) Module A/P-A/R accounting * BSIIMPORT (Bank transactions import)
Chapter SUP (Supervisor) * MAXSPEACV (Specific ACV limit)
* PIHI2 (Supplier Invoice Increase Line) * PIHI3 (Supplier Inv Distrib Line Elt) These journals are integrated to the X3 folder.
Translation corrections have been performed.
For Financial data extraction usage, it is recommended to install patch “V11_TXS_BALSITCT.dat” delivered in DIVTXS directory. it contains: The setup of the BALSITCT financial data extraction with the following modification: Changes on line 123. Accounts 485 and 568 already indicated on line 131.
Entreprise Management V11 and Entreprise Management HR V12 can be installed on the same site as separate solutions, sharing the same Syracuse server. The Syracuse server must be in the last version (V12). To avoid disfunction related to links definition, or authoring, you can install an additional patch. X3_ProductUpdate_Resources_11.0.8.zip This patch contains the sitemap (navigation page), menu entries, home pages and authoring. | New functions : Usage /GDPR/List of email data Usage /GDPR/List of personal data Usage /GDPR/List of phone data Usage /GDPR/GDPR search Usage /GDPR/Contrôle société pour DPD Usage /GDPR/GDPR setup Usage /GDPR A/P-A/R accounting/Reconciliation/Advanced bank statement/Bank transactions import |
Update | Informations | Sage X3 functions |
9 (3332-3702) | File : X3_ProductUpdate_11.0.9.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.10.zip. Some tables are modified; mind the integration time for this update on large volumes for tables : ABATGRP, ABATRQT, APLLCK, COSTSTCD, DCLVATBOXDBD, DCLVATBOXH, DCLVATBOXPYD, EDIBPRPAR, EDIFLOA, EDIFLOAP, EDIPTCM, EFASACT, EFASAFFAGE, EFASCCNAGE, EFASCCNCNL, EFASCCNISS, EFASCFS, EFASCHGIMP, EFASCHGPPL, EFASCNL, EFASCRT, EFASIML, EFASISS ... Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * VATBX (VAT boxes management)Module A/P-A/R accounting * BSINB (Bank statement import)
Module Financials * GSTGRP (GST group header)* GSTGRPD (GST group details) * GSTPER (GST reporting period header) * GSTPERD (GST reporting period details) Module Common Data * EDIFLOA (Attachment)* EDIFLOAP (Parameters) * EDIPTCM (Protocol detail)
Module Supervisor * ABIUPDSTA (Flag update)Module Financials * DCLVATAUS (Australian GST)* GESGSTGRP (GST Groupings) * GESGSTPER (GST reporting periods) * GESVTB (VAT boxes) * MOTH (Others) * RFI6B (Print/group/acct ) * RPT6F (Print/group/acct ) Module Fixed Assets * GESPVT (Advanced event parameters)* MNTPVT (Event maintenance)
Chapter CPT (Accounting) * BLAMAXCPY (Dimension balance inquiry max)Chapter LOC (Localisations) * AUSGSTASOF (As of date)* AUSTMPBLK (Blocking on temporary journals) * AUSVAT (Australian GST) Chapter TC (Common Data) * CMMPERCTL (Commitment period control)* PJMLOGFIL (Project technical log file) * TASCLOORD (Closing with WIP authorized)
Module Supervisor * ASYRREQ (List of queries)Module Sales * EDISIHEM (Sales invoice)* EDISIHTR (Sales invoice) Module Common Data * EDIPTC (Protocol)* EDISEQFIL (Sequential file) * EDISTO (Temp storage space)
* ABNGER (Bank sort codes [GER+AUT]) * CRY (Dimensions groups)
Entreprise Management V11 and Entreprise Management HR V12 can be installed on the same site as separate solutions, sharing the same Syracuse server. The Syracuse server must be in the last version (V12). To avoid disfunction related to links definition, or authoring, you can install an additional patch. X3_ProductUpdate_Resources_11.0.9.zip This patch contains the sitemap (navigation page), menu entries, home pages and authoring. | New functions : Declarations/Tax management/Australia/GST report/GST Groupings Declarations/Tax management/Australia/GST report/GST reporting periods Declarations/Tax management/Others/Setup/VAT boxes Declarations/Tax management/Others |
Update | Informations | Sage X3 functions |
10 (3703-4066) | File : X3_ProductUpdate_11.0.10.zipBefore integration
MongoDb database server Download file SafeX3_Mongodb_3.4.16.zip. Syracuse server Download file SafeX3_Syracuse_11.11.zip. Client Weighing : The Ilog connector includes a new weighing DLL. It is necessary to reinstall the ILOG connector you will find from the Syracuse menu : Administration/Utilities/Installation/Ilog connector.
Production scheduler New installation : Download file SafeX3ProductionScheduler-11.0.10.zip. Update : Download file PlannerOne.SAGE.6.0.1829.zip. For an update, version 6.0.1829 installation is mandatory Some tables are modified; mind the integration time for this update on large volumes for tables : BOMRET, BSIIMP, BSIIMPTC, BSIITCD, CBNDET, DKSDATAFRA, GAUTRCTMP, GAUTRCVCR, ITCNAT, MFCNAT, MFGITMTRK, MFGMAT, PDPDET, PJMDE, PJMTIMEMP, PJMTSKITM, POPSMRK, POPSPIN, PWRKPOC, TABMAT, VATENTFRM, VATENTFRMD, VATFRMENT, VATFRMENTD Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * DSFR (French electronic signature)
Module Financials * VATENTFRM (VAT form (definition))* VATENTFRMD (VAT form detail (definition)) * VATFRMENT (VAT form (values)) * VATFRMENTD (VAT form detail (values)) Module A/P-A/R accounting * BSIIMPTC (Bank import type codes)* BSIITCD (Bank import type codes) Module Common Data * DKSDATAFRA (Electronic signatures)
Module Financials * GESVEF (VAT form)* GESVFE (VAT form entry) Module Common Data * FRADSICTL (Digital signature control)* MAFRA (France) * PJMACTBUD (Project budgets) * PJMACTTAS (Project tasks)
Chapter LOC (Localisations) * DSFRAGL (GL digital signature)* DSFRAINV (Invoices electronic signature) * MTDENV (VAT form) Chapter TC (Common Data) * PJMDEFSTA (Project default status)
Module Financials * SELVATRQTSWI (VAT query selection)
Module Supervisor * APSADX (User monitor)Module A/P-A/R accounting * BANACO (BANK)* BSIIMPTC (Bank import type codes) * BSIIMPTCDUP (Bank import type codes)
* STKRE (Purchase receipt) These journals are integrated to the X3 folder.
Print server EDT.215 Web services server WEB.236 Java server JAV.223
Entreprise Management V11 and Entreprise Management HR V12 can be installed on the same site as separate solutions, sharing the same Syracuse server. The Syracuse server must be in the last version (V12). To avoid disfunction related to links definition, or authoring, you can install an additional patch, if Entreprise Management HR V12 is available for your location. X3_ProductUpdate_Resources_11.0.10.zip This patch contains the sitemap (navigation page), menu entries, home pages and authoring. | New functions : Declarations/Tax management/Others/Setup/VAT form Declarations/Tax management/Others/Processings/VAT form entry Usage /Audit/France/Digital signature control Usage /Audit/France |
Update | Informations | Sage X3 functions |
11 (4067-4398) | File : X3_ProductUpdate_11.0.11.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.13.zip.
Production scheduler New installation : Download file SafeX3ProductionScheduler-11.0.11.zip. Update : Download file PlannerOne.SAGE.6.0.1842.zip. For an update, version 6.0.1842 installation is mandatory
Some tables are modified; mind the integration time for this update on large volumes for tables : DCLVATPORT, EDIFLOD, EDIXMLFILD, EDIXMLFILP, KCOEF, SVATCTL, TABSIVTYP, VATEXEREA Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * SVATCTL (Control SVAT rules)
Chapter CPT (Accounting) * MTCAMT (Matching by company amount)* MTCCUR (Currency matching) * MTCSOL1 (Account balance search matching) Chapter GPA (Manufacturing) * RELSTRDAT (Level on WO start date change)Chapter LOC (Localisations) * SIVTYPCVAT (Invoice type for cash vat)
Module Sales * CHORUS (Sales invoice)* EDISOHTR (Sales order) Module Common Data * EDIPARTNER (EDI partners)
The Syracuse server contains an update of Office's Addins. To install or update it, go to Syracuse menu : Administration/Utilities/Installation/Install addins for Office
The Ilog connector includes a new weighing DLL. It is necessary to reinstall the ILOG connector you will find from the Syracuse menu : Administration/Utilities/Installation/Ilog connector.
· Additional patch : An update of all standard reports for POL language (Polish) is available in the DIVRPT directory, file “POLREPORTV11.zip”.
Get connected to the VAT boxes management (Declarations > Tax management > Others > Setup > GESVTB function), check if you already have the VAT boxes pre-setting for BRI declaration DCLVATBRI (VATFNC field). If you get it, do not install the patch of presetting delivered within DIVVTB directory. If the setting does not exist, integrate the patch V11_VTB_DCLVATBRI delivered in the directory DIVVTB, via the "classic " function PATCH (Development > Utilities > Patches > Patch integration), selecting the folders on which the patch should be Integrated. After integration : Declarations module · VAT boxes: * DCLVATBRI declaration & BRI legislation : update the VAT boxes presetting depending on the customer context (account setup & tax codes).
Check existence of import/export template CTR that aims at import & export of containers (Purchase shipments). If this template already exists on your folder, do not integrate the patch delivered within DIVAOE directory. If the setting does not exist, integrate the patch V11_AOE_CTR.dat delivered in the directory DIVAOE, via the "classic " function PATCH (Development > Utilities > Patches > Patch integration), selecting the folders on which the patch should be Integrated | : |
Update | Informations | Sage X3 functions |
12 (4399-4878) | File : X3_ProductUpdate_11.0.12.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.14.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : CASHPAYSPA, CBNWRK, CFGQST, ELEAACTU, LEASE, ROUOPE, SCOITM, SVATCTL, TMPSRPTDET, VATFRMENT, VATFRMENTA, VATFRMENTC, VATFRMENTD, VATFRMENTN Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * VATFRMENTA (VAT form)* VATFRMENTC (VAT form by company) * VATFRMENTN (VAT form queries) Module Sales * TMPSRPTDET (Temporary print key table)
Module Financials * DCLVATOTH (Preparatory VAT declaration)
Chapter CPT (Accounting) * VFEUTI (Migration )Chapter LOC (Localisations) * MTDURL (VAT submission environment)
Module Financials * BPS1099PAYAR (1099 activity)
* 950 (Regions) * 951 (Airport/Seaport Intrastat)
* STKSD (Sales delivery) * REACT (Rent : Update) * RECNL (Rent : Deletion) * RECRT (Rent : Validation) * REDPR (Rent : Depreciation) * REIML (Rent : Impairment) * REISS (Rent : Sale / Disposal) * REPAY (Rent : Payments) * REREV (Rent : Revaluation) * RETRA (Rent : Analytical transfer) * RETRF (Rent : Account transfer) These journals are integrated to the X3 folder.
The Ilog connector includes a new weighing DLL. It is necessary to reinstall the ILOG connector you will find from the Syracuse menu : Administration/Utilities/Installation/Ilog connector.
· Additional patch : In the DIVPOL directory of this patch list, you get some updates of the Polish language (review & complement) in the visual processes and few related items, namely: - Patch “V11_APR_POL1.dat” & “V11_APR_POL2.dat” for Visual processes (GESAPR) ; - Patch “V11_ALH-ALT_POL.dat” for queries (GESALH) and graphical queries (GESALT) ; - Patch “V11_PS2_POL.dat” for statistical parameters (GESPS2).
· Additional patch : The patch for the SOHSIG worflow rule is to apply if the setup regarding the sales orders signature process is defined as below : - General parameter VEN/APP/APPSOH Order signature management = Yes mandatory - General parameter VEN/APP/SOHAPPALL Allocation on unsigned order = No Before the fix, with this setup, if a sales order was totally signed and allocated, the sales order modification didn’t deallocate the sales order if this one was not totally signed after the modification. This patch is delivered within directory DIVAWA, file “V11_AWA_SOHSIG.dat”.
· Additional patch : New combinations of tax codes and accounts (VAT Management & Tax allocation) have been added for some tax boxes. The Detail tab now has 112 rows Get connected to the VAT boxes management, check if you already have the VAT boxes pre-setting for BRI declaration DCLVATBRI (VATFNC field). - If you do not have any settings, it is necessary to integrate the patch delivered in the directory DIVVTB (integrate it using PATCH function). - If you already have a setup, it is recommended to integrate the patch (using PATCH function) in a folder containing no setup for declaration DCLVATBRI + legislation BRI in order to enter manually or via the import/export template (VATBOXD) the additions of the detail lines in the existing setup. - If you use accounts and tax codes specific to your context (not delivered as Standard), it is necessary to update the template for setting VAT boxes according to these codes. Note: if you have already generated your VAT return based on the setting of the boxes (GESVTB) and that there were missing combinations of tax codes and accounts, they would be erroneous in the log associated with DCLVATBRI and you could have then made the necessary additions. This presetting is delivered within directory DIVVTB, file “WX_11.0.12_VTB_DCLVATBRI.dat”.
On purchase invoice posting, with an invoicing element distributed on lines and having a product tax rule, an error can occur with the automatic journal PIHI2. The automatic journal PIHI2 has been updated on line 220 by replacing the formula in 'Amount' and 'Analytical amount' headings with: [F:PID]AMTNOTLIN+sigma(I=1,9,evalue("[F:PID]DISCRGAMT"+num$(I))*([F:PIV]INVDTAVAT2(I-1)="")) If you have an Anglo-Saxon stock accounting (ACCDETSTK general parameter equal to Yes) you can be concerned by this issue. To install this fix on your folder, once the patch list integrated, you have to: - Copy manually the automatic journal PIHI2 from the mother folder to your applicative folder by using the ‘Copy’ option in the Automatic journals function (GESGAU)”
The identifiers on the SCMAUT (Components Subcontract), SCIAUT(Released product Subcontract) and SCSAUT(Service subcontract) default dimension codes have been all updated to be used in the subcontract order generation functions. To install this fix on your folder, once the patch list integrated, you have to: - Copy manually the default dimensions SCMAUT, SCIAUT & SCSAUT from the mother folder to your applicative folder by using the ‘Copy’ option in the Default dimensions journal function (GESCDE). Only the Identifier setup will be copied.
The identifiers on the SCM (Components Subcontract ) default dimension code have been all updated to be used in the subcontract order function. To install this fix on your folder, once the patch list integrated, you have to: - Copy manually the default dimension SCM from the mother folder to your applicative folder by using the ‘Copy’ option in the Default dimensions journal function (GESCDE).
This release contains an updated version of miscellaneous tables 950 (Regions) and 951 (harbor/airport). For installation where Portuguese legislation is deployed and Intrastat file is issued, it is recommended to review the setup of Delivery modes (GESTMD) and revisit the region codes entered. | New functions : Declarations / Tax management / Others / Processings / Preparatory VAT declaration |
Update | Informations | Sage X3 functions |
13 (4879-5316) | File : X3_ProductUpdate_11.0.13.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.16.zip. Some tables are modified; mind the integration time for this update on large volumes for tables : BSIIMP, DEB, DEBREGNAT, EDIXSDUPLLOB, FAMPBREP, ITMFACILIT, ITMMASTER, MFGITMTRK, PARMRP, PJMTSKITM, SALTRS, SINVOICEV, SORDER, SQUOTE, TABCOUNTRY, TABFILTDS, TABSIVTYP, TABSOHTYP, TABSQHTYP Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * DEB (EU exchange declaration)* DEBR (Intrastat state/region)
Module Stock * GESMDL (Planning workbench)* GESMGL (Enterprise planning) * GESMRL (Grouping) * GESORZ (Demand forecasts) Module Common Data * GESMFC (Production cost inquiry)
These journals are integrated to the X3 folder.
The Syracuse server contains an update of Office's Addins. To install or update it, go to Syracuse menu : Administration/Utilities/Installation/Install addins for Office
The Ilog connector includes a new weighing DLL. It is necessary to reinstall the ILOG connector you will find from the Syracuse menu : Administration/Utilities/Installation/Ilog connector.
The document identifier on the STKHDT (Service Requests Consumption) default dimension code has been updated to be used in Service response function (GESITN). To install this fix on your folder, once the patch list integrated, you have to: - Copy manually the default dimension STKHDT from the mother folder to your applicative folder by using the ‘Copy’ option in the Default dimensions journal function (GESCDE). Only the Identifier setup will be copied.
The document identifier on the STKSOF (Work order Material Issue) default dimension code has been updated to be used in the reintegration plan function. To install this fix on your folder, once the patch list integrated, you have to: - Copy manually the default dimension STKSOF from the mother folder to your applicative folder by using the ‘Copy’ option in the Default dimensions journal function (GESCDE). Only the Identifier setup will be copied. | New functions : Setup/Manufacturing/Production entry transactions/Planning workbench Setup/Manufacturing/Production entry transactions/Enterprise planning Setup/Manufacturing/Production entry transactions/Grouping Manufacturing/Planning/Demand forecasts Costing/Production costs/Production cost inquiry |
Update | Informations | Sage X3 functions |
14 (5317-5753) | File : X3_ProductUpdate_11.0.14.zipBefore integration
MongoDb database server If your current version of MongoDb isn't version 3.4.16 it is strongly recommended to install this component, that contains security improvements. Syracuse server Download file SafeX3_Syracuse_11.17.zip.
Console Download file Console_2.43.0.zip. Print server EDT.218 Download file Printserver_2.18.0.zip. Elasticsearch X3 is now compatible with Elasticsearch version 6.4. You can download it from the Elasticsearch website. X3 is still compatible with the previous releases, but it is strongly recommended to upgrade to version 6.4, as Elasticsearch 2.4.4 is no longer maintained by Elastic. It is highly recommended to host Elasticsearch on a dedicated server. Make sure that you write down the Elasticsearch host name and its corresponding HTTP service port number defined in the elasticsearch.yml file as you will need to set these same parameters in the nodelocal configuration file (i.e. the hostname and port must match the network.host and http.port of the elasticsearch.yml file). Note: For network.host, '0.0.0.0' will create a link to all the network interfaces. The value '0' has the same effect as '0.0.0.0'. For further information, please refer to the Elasticsearch network settings documentation. For further information on the Elasticsearch setup, refer to the Installation guide available in the Elasticsearch Online help. Client Weighing The Ilog connector includes a new weighing DLL. It is necessary to reinstall the ILOG connector you will find from the Syracuse menu : Administration/Utilities/Installation/Ilog connector.
Some tables are modified; mind the integration time for this update on large volumes for tables : DCLVATBOXH, DEB, DKSDATA, MFCWST, PARMRP, PAYVAT, PJMSOLITMH, SINVOICEV, SORDER, SQUOTE, TMPSRPT, TMPSRPTDET, VATFRMENT, VATFRMENTA, VATGRP, VATGRPD Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * VATGRP (VAT entity header)* VATGRPD (VAT entity details)
Module Financials * GESVATGRP (VAT entities)Module Sales * FUNCFMPRO (Mass change)* FUNCFMSOH (Order electronic signature) * FUNCFMSQH (Quote electronic signature) Module Purchasing * GESSCO (Subcontract orders)
* STKPN (Supplier return) * STKRE (Purchase receipt) These journals are integrated to the X3 folder.
Service supplier function In the Service supplier function (GESPRV), the Federal ID code ('Code INSEE' in French), which displays the country code, is now managed according to the following rules:
The associated presetting has been modified in the following functions:
In the 'TDSBI' file + 'Fee lines' record type + Position 266 The existing formula has been replaced with: string$([F:PRV]CRYCOD="FR", [F:PRV]POSCOD)+ string$([F:PRV]CRYCOD<>"FR",[F:TCY]CINSEE)
In the 'DADSUN4DS' group + Line 82 The existing formula has been replaced with: string$[F:TCY]ISO="FR", [F:PRV]POSCOD)+ string$([F:PRV]POSCOD<>"FR",[F:TCY]CINSEE) Line 85: string$([F:TCY]ISO<>"FR",[F:TCY]CIN To benefit from this enhancement, please install the hotfixes delivered with this patch list in the DIVDAS directory. You must perform the integration from the Patch integration (PATCH) function. | New functions : Declarations/Tax management/Others/Setup/VAT entities Sales/Invoices/Mass change Sales/Orders/Order electronic signature Sales/Quotes/Quote electronic signature Purchasing/Subcontract/Subcontract orders |
Update | Informations | Sage X3 functions |
15 (5754-6081) | File : X3_ProductUpdate_11.0.15.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.19.zip. MongoDb database server The Sage X3 platform is compatible with MongoDB 3.6. You need to update MongoDB because the previous versions are no longer maintained.You must be running MongoDB 3.4 to upgrade to MongoDB 3.6.Before the upgrade, you will have to check your MongoDB compatibility version and update it to version to 3.4 if necessary. Please consult the how-to-upgrade-to-MongoDB documentation for more information. To update download file Mongodb_3.6.14.zip.
Console Download file Console_2.44.0.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : BANK, BILLLADWRK, BSIIMPDS, DKSDATAPOR, INVENTD, MFCWST, PARMRP, PAYMENTH, PAYMENTPORD, PAYMENTPORH, STOALL, SWIQRC, TABPAYTYP, TMPARPTDET, TMPSRPT Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * TDS (Electronic signature)
Module A/P-A/R accounting * PAYMENTPORD (Payment lines)* PAYMENTPORH (Payment header) * SWIQRC (Swiss QR-data) * TMPARPTDET (Temporary print key table) Module Common Data * DKSDATAPOR (Electronic signatures)
Module Financials * UTICLOCHE (Accounting closing check)
Chapter LOC (Localisations) * PORADS (GL electronic signature)* PORBKP (Backup) * SAFTANADIE (SAF-T analytical dimension type) * SWICUSQRC (QR code entry) * SWIPAYQR (Control of Swiss QR payments) * SWIPURQRC (QR code entry) Chapter TC (Common Data) * SIVNULL (Lines set to zero prohibited)
Module Supervisor * APSADXCPU (User monitor)
* 399 (Credit card transaction type) * 403 (Credit card response codes)
| New functions : Financials/Utilities/Closing utilities/Accounting closing check |
Update | Informations | Sage X3 functions |
16 (6082-6422) | File : X3_ProductUpdate_11.0.16.zipBefore integration
Runtime Download file SafeX3_Runtime_R081.004.zip. Syracuse server Download file SafeX3_Syracuse_11.20.zip.
Console Download file Console_2.45.0.zip. Print server Download file Printserver_2.18.1.zip. VT Web server Download file SafeX3V2_WebServices237.zip. Elasticsearch X3 is now compatible with Elasticsearch version 6.8. You can download it from the Elasticsearch website. X3 is still compatible with the previous releases, but it is strongly recommended to upgrade to version 6.8, as Elasticsearch 2.4.4 is no longer maintained by Elastic. It is highly recommended to host Elasticsearch on a dedicated server. Make sure that you write down the Elasticsearch host name and its corresponding HTTP service port number defined in the elasticsearch.yml file as you will need to set these same parameters in the nodelocal configuration file (i.e. the hostname and port must match the network.host and http.port of the elasticsearch.yml file). Note: For network.host, '0.0.0.0' will create a link to all the network interfaces. The value '0' has the same effect as '0.0.0.0'. For further information, please refer to the Elasticsearch network settings documentation. For further information on the Elasticsearch setup, refer to the Installation guide available in the Elasticsearch Online help.
Some tables are modified; mind the integration time for this update on large volumes for tables : BPSUPPLIER, CCMCRNOTES, EECBIDWL, MGTWASTE, PJMBUDLIG, PJMSALITMD, PJMSOLITMD, PJMSOLITMO, SCHGH, SINVOICE, SVATCTL, TABVACITM, TABWRKCTR, WORKSTATIO Pay attention to have enough space in Oracle tablespaces. After integration
Module Stock * SHWIP (No. shipment lines)
Module Common Data * EECBIDWL (WL)* MGTWASTE (Waste management)
Module Common Data * GESMGTW (Waste management)
Chapter AAS (Fixed assets) * INTCOMCLO ( Intermediate commits closing)
Module Common Data * CCMCHGREQ (Change request)* CCMCHGREQF1 (Change requests for approval) * CCMCHGREQF2 (Change Requests to plan) * CCMCHGREQF3 (Change requests to manage) * CCMCHGREQF4 (Change requests created)
* GDPDU0201 (GDPDU Customer accounting data) * GDPDU0202 (GDPDU Customer header data) * GDPDU0301 (GDPDU Supplier accounting data) * GDPDU0302 (GDPDU Supplier header data) * GDPDU04 (GDPDU Open items) * GDPDU06 (GDPDU Journal entries header) * GDPDU07 (GDPDU Tax codes) * GDPDU0701 (GDPDU Tax rates) * GDPDU08 (GDPDU Hist. open items cust.) * GDPDU09 (GDPDU Hist. open items suppl.) * GDPDU10 (GDPDU Accounting entry lines) * GDPDU11 (GDPDU Receipt type) * GDPDU12 (GDPDU Line code) * GDPDU20 (GDPDU Analytical entries line) * GDPDU21 (GDPDU Sectors) * GDPDU22 (GDPDU Dimensions) * GDPDU23 (GDPDU Anayltical natures) * GDPDUADD (GDPDU Address data) * GDPDUCOA (GDPDU Account plans) * GDPDULED (GDPDU Legders) * MESMKM (Material tracking import) * GDPDU44 (GDPDU Financial Assets) * GDPDU45 (GDPDU Depreciation methods) * GDPDU46 (GDPDU Depreciation rates) * GDPDU47 (GDPDU Depreciation charges) * GDPDU48 (GDPDU Physical elements)
These journals are integrated to the X3 folder.
| New functions : Common data/Common tables/Waste management |
Update | Informations | Sage X3 functions |
17 (6423-6732) | File : X3_ProductUpdate_11.0.17.zipBefore integration
Runtime Download file SafeX3_Runtime_R081.004.809.zip Syracuse server Download file SafeX3_Syracuse_11.22.zip.
Production scheduler New installation : Download file SafeX3ProductionScheduler-6.0.2014.zip. Update : Download file PlannerOne.SAGE.6.0.2014.zip. For an update, version 6.0.2014 installation is mandatory
Console Download file Console_2.46.0.zip. Print server Download file Printserver_2.19.0.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : CTSWSP, DCLVATPORH, SINVOICE, SORDER, SQUOTE, TMPARPT, TMPSRPT Pay attention to have enough space in Oracle tablespaces. After integration
Module Manufacturing * MFLIN (Number of lines)Module Common Data * CTSW (Control system)
Module Common Data * CTSWSP (Control system)
Module Financials * CTSW (Control system)Module Common Data * CONSCTSW (Control system)
Chapter CRM (Customer Relation) * AUSCRMG (Full time)* AUSCRMH (Fixed weekly structure) Chapter LOC (Localisations) * CTSWCPY (Control system)* CTSWCPYCER (Company certificate) * CTSWPROXY (Communicating with proxy) * DEVSERIAL (Device serial number) * TERDECSP (Territory of declaration)
* PTFNL (Final number)
For users of VIRINT03 Bank file definition, function GESTFB The VIRINT03 bank file has been updated at the “Detail” record type level, to delete a carriage return in the <InstdAmt> tag. The <InstdAmt> tag formula has been modified as follows: func FICMAG.SET_PARAM_VALUE ([F:PYH]CUR,[F:PYH]AMTCUR,":") The bank file update is managed through a maintenance, dropped in the specific directory DIVTFB. It is not automatically integrated. If wished, integration must be done manually from the Patch integration (PATCH) function. Required modification :
Sequence number “PTFNL” (final number) for POR legislation For users of Portuguese companies, a new sequence number structure (GESANM) is delivered, code "PTFNL". This sequence number is intended to control the document sequentially, using the final field number in the general ledger entries. It is defined as follows: Company -> 3 digits Complent -> 6 digits Month -> 2 digits Year -> 2 digits Constant -> 1 digit Sequence number -> 6 digits
This sequence number must be defined at the "Company" and "Monthly" level It must also be set with "Chronological control" and "Reset to zero" active. This configuration can truncate the company because we are only using 3 digits for the component type code. If the user has no more than 9999 monthly documents for each type of entry, the user can change the company to 5 digits and reduce the sequence number to 4. In GESTCA, this sequence number is assigned to “Financial” module and “POR” legislation. It will be applied in document type line “Final number”.
| New functions : Declarations/Tax management/Spain/Control system Declarations/Tax management/Spain/Control system/Control system |
Update | Informations | Sage X3 functions |
18 (6733-6968) | File : X3_ProductUpdate_11.0.18.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.23.zip. MongoDb database server The Sage X3 platform is compatible with MongoDB 4.0. If you are using a previous version of MongoDB, it is strongly recommended to update it. In order to install the MongoDB 4.0 upgrade, MongoDB 3.6 must be running. You need to check your MongoDB version and update it to version 3.6 if necessary. Note that if you use an Oracle JAVA pltform, prerequisites have evolved. Please refer to the how-to-upgrade-to-MongoDB-4.0 documentation for more information. To update, download file Mongodb_4.0.18.zip.
Console Download file Console_2.47.0.zip. Print server Download file Printserver_2.20.0.zip. VT Web server Download file VTWebServer_2.38.10.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : CTSWSP, DCLVATPORH, ITMFACILIT, SALTRS, SPAMOD111, SPAMOD123, SPAMOD190, SPAMOD1901, SPAMOD193, SPAMOD1931, SPAMOD1932, SPAMOD216, SPAMOD296, SPAMOD2961, SPAMODCPY, SPAMODELS, TMPGACCENTRD, TMPGACCENTRY Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * SPAMOD111 (Spanish form 111)* SPAMOD123 (Spanish form 123) * SPAMOD190 (Spanish form 190) * SPAMOD1901 (Spanish form 190 details) * SPAMOD193 (Spanish form 193) * SPAMOD1931 (Spanish form 193_1) * SPAMOD1932 (Spanish form 193_2) * SPAMOD216 (Spanish form 216) * SPAMOD296 (Spanish form 296) * SPAMOD2961 (Spanish form 296_1) * SPAMODCPY (Spanish forms by company) * SPAMODELS (Spanish forms) * TMPGACCENTRD (Accounting entry lines) * TMPGACCENTRY (Accounting entries)
Module Financials * GESSPAMOD (Spanish forms)* GESSPAMODC (Spanish forms by company) * GESSPAMODG (Spanish forms generation) * GESSPAMODM (Spanish form management) * SPMOD (Spanish forms)
* REPAY (Rent : Payments) These journals are integrated to the X3 folder.
Automatic journal STKRE, improvement & renumbering The Purchase receipt journal (STKRE) is modified to improve the postings for Standard cost or Revised standard cost products as well as products or services containing Overhead. The following lines are created exclusively for Standard or Revised standard cost: · Line 80 Standard/Revised standard GRNI credit · Line 100 Purchase price variance · Line 120 Standard/Revised standard overhead credit · Line 130 Standard/Revised standard overhead debit
A conditional formula is added to the following lines to exclude Standard or Revised standard cost products or services: · Line 70 GRNI credit · Line 90 Stock increase adjustment · Line 110 Overhead credit
The posting description is updated to “Overheads” and the Amount formula includes Service overhead on the following line: · Line 110 Overhead credit
The formula for the Analytical amount is updated to match the Amount: · Line 70 GRNI credit · Line 110 Overhead credit
To allow for customizations or future updates, the lines have been restructured into increments of 10. The following lines are renumbered: · Line 90 Stock increase adjustment – formerly line 80 · Line 110 Overhead credit – formerly line 85 · Line 140 In-transit inventory (USA BRI) – formerly line 90 · Line 150 Stock increase subcontract – formerly line 100 · Line 160 Increase adjustment subcontract – formerly line 110 · Line 170 Goods and materials receipt – formerly line 120 (RUS legislation only) · Line 180 Goods and materials receipt – formerly line 130 (RUS legislation only) · Line 190 Cost without VAT for TAX – formerly line 140 (RUS legislation only) · Line 200 Cost without VAT for TAX – formerly line 150 (RUS legislation only) · Line 210 Landed costs Debit stock line – formerly line 160 · Line 220 Landed costs Stock variation – formerly line 170 · Line 230 Landed costs Stock adjustment – formerly line 180 · Line 240 Landed costs Variation adjust – formerly line 190 · Line 250 Landed costs – formerly line 75
Automatic journals are integrated into the X3 parent folder only. - In your operating folder, in former STKRE automatic journal, delete lines 75 & 85; - You may run the usual tool of Automatic document comparison (CMPGAU), but caution, you will get a huge number of differences. - Once identified & saved your personalization (if you did some), copy STKRE from parent folder to operating folder using the Automatic journals function (GESGAU). Evolution of automatic journal REPAY Two new lines have been added to the auto-journal REPAY ‘Rent: Payments’: · Line 23 ‘Interest charge – IAS’ will debit a cost account with the interest amount. · Line 24 ‘Accrued interest – IAS’ will credit a liability account with the interest amount. The column ‘Financial cost‘ has been added to the grid of the open item schedule for the contract type rent. It represents the interest part of the lease payment amount (already stored in the existing column ‘Rental amount’ for each period/month. The financial cost column is not taken in account when calculating the present values and rights of use. This amount is not calculated from the contract characteristics and needs to be entered or imported by the user. Reminder: the auto-journal REPAY is triggered by the creation of the lease payments and the posting of the fixed assets entry type RNTPAYIAS. Automatic journals are integrated into the X3 parent folder only.
| New functions : Declarations/Tax management/Spain/Spanish forms/Spanish forms Declarations/Tax management/Spain/Spanish forms/Spanish forms by company Declarations/Tax management/Spain/Spanish forms/Spanish forms generation Declarations/Tax management/Spain/Spanish forms/Spanish form management Declarations/Tax management/Spain/Spanish forms |
Update | Informations | Sage X3 functions |
19 (6969-7156) | File : X3_ProductUpdate_11.0.19.zipBefore integration
Syracuse server Download file SafeX3_Syracuse_11.25.zip. MongoDb database server 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. Note that if you're using an Oracle JAVA platform, prerequisites have evolved. Please refer to the how-to-upgrade-to-MongoDB-4.2 documentation for more information. To update, download file Mongodb_4.2.8.zip.
Console Download file Console_2.49.0.zip. Print server Download file Printserver_2.22.0.zip. Elasticsearch Elasticsearch is an open-source, distributed real-time search and analytics engine. Sage X3 is compatible with Elasticsearch version 7.9. You can download it from the Elasticsearch website. Although Sage X3 is still compatible with previous releases, it is strongly recommended to install the latest version of ElasticSearch compatible with your release (to be checked from the Prerequisite overview page), as older versions will not be longer maintained by Elastic. It is highly recommended to host Elasticsearch on a dedicated server. Before upgrading to Elasticsearch, you must delete the indexes on your current version. Make sure that you write down the Elasticsearch host name and its corresponding HTTP service port number defined in the elasticsearch.yml file as you will need to set these same parameters in the nodelocal configuration file (i.e. the hostname and port must match the network.host and http.port of the elasticsearch.yml file). Note: For network.host, '0.0.0.0' will create a link to all the network interfaces. The value '0' has the same effect as '0.0.0.0'. Please refer to the Elasticsearch network settings documentation for more information. To know more about how to set up Elasticsearch, please refer to the Installing Elasticsearch guide and Set up Elasticsearch documentation on prerequisites, available from Elasticsearch Reference online help.
Some tables are modified; mind the integration time for this update on large volumes for tables : DCLVATSPA, EFASREEVAL, KPYIMPTRAN, MGTATCUD, PINVOICE, PJMTIMEMP, PJMTIMEMPI, PORQRC, SPAMOD115, SPAMOD303, SPAMOD349, SPAMOD349D Pay attention to have enough space in Oracle tablespaces. After integration
Module Financials * SPAMOD115 (Spanish form 115)* SPAMOD303 (Spanish form 303) * SPAMOD349 (Spanish form 349) * SPAMOD349D (Spanish 349 form detail) Module Common Data * MGTATCUD (ATCUD management)* PJMTIMEMPI (Time summary) * PORQRC (Portuguese QR-data)
Module Financials * CONSSPMOD (Spanish form management)* GESSPMOD (Spanish forms) * GESSPMODC (Spanish forms by company) * GESSPMODG (Spanish forms generation) Module Common Data * APORC (ATCUD management)* GESATCUD (ATCUD management)
Chapter LOC (Localisations) * EFATCERTNA (Certificate)Chapter TC (Common Data) * PJMTIMNEG (Allow time entries negative qt)
* 320 (Epigraph IAE)
* STKEO (Production reporting) * STKMC (Material tracking) * STKPN (Supplier return) * FXREV (FA : Revaluation) These journals are integrated to the X3 folder.
Advanced event parameters In the Setup > Fixed Assets > Advanced event parameters (GESPVT) function, the FASREEVAL event type has been updated. The two fields managing revaluation reversal (RVACRB and RVACRB) added to table EFASREEVAL (Revaluation event on Fixed assets) have been setup for all depreciation plans to be used in the posting of the revaluation. These fields are defined in the numeric grid. The associated script can be validated with the Validation button/action. Accounting entry types In the Setup > Fixed Assets > Accounting entry types (GESTPE) function, the FASREEVAL and FASREEVALIAS entry types have been updated. In the Interface section the following amounts have been added: · 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 automatic journal FXREV for the posting of the revaluation. The associated script can be validated with the Validation button/action. Database optimization for Costing tables As an option to improve the performance in the following functions, new indexes are available in Database optimization (GESANX):
Database optimization is integrated into the X3 parent folder only. To utilize the indexes, copy to your operating folder and enable them by changing Active to Yes. Automatic journal STKEO & STKMC improvement The Production reporting (STKEO) and Material tracking (STKMC) journals are modified to correct an out-of-balance from occurring when WIP posting is disabled with Anglo-Saxon stock accounting activated. A conditional formula is added to the following lines to allow for Anglo-Saxon stock accounting:
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 (CMPGAU) to identify your variances. Automatic journal STKDB improvement The Disassembly (STKDB) journal is modified to correct an out-of-balance from occurring when the Standard cost of a component has been updated after the Assembly creation. The Amount formula is updated for the following lines:
The ENG line descriptions are also updated to remove the incorrect parent or component designations:
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 (CMPGAU) to identify your variances. 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:
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 (CMPGAU) to identify your variances. Automatic journal STKPN, improvement and renumbering The Supplier return journal (STKPN) is modified to improve the postings for Standard cost or Revised standard cost products as well as products or services containing Overhead. The following lines are created exclusively for Standard or Revised standard cost:
A conditional formula is added to the following lines to exclude Standard or Revised standard cost products or services:
The posting description is updated to “Overheads” and the Amount formula includes Service overhead on the following line:
The formula for the Analytical amount is updated to match the Amount:
To allow for customizations or future updates, the lines have been restructured into increments of 10. The following lines are renumbered:
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 (CMPGAU) to identify your variances. | New functions : Declarations/Tax management/Spain/Spanish forms/Spanish form management Declarations/Tax management/Spain/Spanish forms/Spanish forms Declarations/Tax management/Spain/Spanish forms/Spanish forms by company Declarations/Tax management/Spain/Spanish forms/Spanish forms generation Declarations/Audit/Portugal/ATCUD management Declarations/Audit/Portugal/ATCUD management/ATCUD management |
Update | Informations | Sage X3 functions |
20 (7157-7200) | File : X3_ProductUpdate_11.0.20.zipBefore integration
Console Download file Console_2.50.1.zip. Adxadmin administration server Download file Adxadmin_93.2.53.zip. Runtime Download file SafeX3_Runtime_R081.004.811.zip. Syracuse server Download file SafeX3_Syracuse_11.27.zip. Print server Download file Printserver_2.23.1.zip. VT Webserver Download file VTWEBServer_2.39.1.zip.
MongoDb database server Download file Mongodb_4.2.12.zip.
Some tables are modified; mind the integration time for this update on large volumes for tables : CTSWSP, DCLVATSPA, PINVOICE, SINVOICE Pay attention to have enough space in Oracle tablespaces. After integration
Chapter LOC (Localisations) * CTSWREST2 (REST Navarre)* CTSWREST4 (REST Gipuzkoa) * CTSWREST5 (REST Alava)
| : |
Update | Informations | Sage X3 functions |
21 (7201-7307) | File : X3_ProductUpdate_11.0.21.zipBefore integration
Console Download file Console_2.52.1.zip. Syracuse server Download file SafeX3_Syracuse_11.29.zip.
Print server Download file Printserver_2.24.0.zip. VT Webserver Download file VTWEBServer_2.39.3.zip. 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.
Some tables are modified; mind the integration time for this update on large volumes for tables : DCLROE, DCLVATSPA, DKSDATA, MGTATCUD, SPAMOD180, SPAMOD1801, SPAMOD303, TABVAT Pay attention to have enough space in Oracle tablespaces. After integration
Module Common Data * DLROE (240 Spanish form)* SIILI (Number of lines)
Module Financials * SPAMOD180 (Spanish form 180)* SPAMOD1801 (Spanish form 180) Module Common Data * DCLROE (240 Spanish form)
Module Sales * CONSCSE (SAFE account management)Module Common Data * CONSDLROE (LROE monitor)* GESMGTATCUD (ATCUD management)
Chapter LOC (Localisations) * BATUZFCY (BATUZ by site)* EFATSAFESG (SAFE signature) * EFATSAFETM (Test mode) * SIIABTYP (Credit memo type) * SIIDVSR (Resynchronization) * SIIEXTAP (External) * SIIFECSII (Closing date) * SIIFGAS (Accounting date) * SIINBFAC (Number of invoices)
Module Sales * EDISDHEM (Delivery)
* IDES (IDES Intrastat export template)
| New functions : Usage /SAFE account management Declarations/Tax management/Spain/Control system/LROE monitor |