• Question on validating SVG folder

    Hi, Context: - Migration work. - Sage X3 pu9p5, Sage X3 v11p22, and Sage X3 v12p34 (destination version; do note I haven't test to bring v12 console to lower versions for multi-threading SVG backup work). - SQL Server 2022 Standard Edition on…
  • WW_MESS error import SDH

    Good morning, we make a call to a WS WSIMPORT (SSH) from .net and in X3 we have a SPEIMPSDHS that records the trace using the function ECR_TRACE and it is returned by the WS in WW_MESS, well, sometimes it does not work, that is, the WW_MESS variable…
  • Data Migration from Oracle to Sage

    Good day We have a customer that wants all data (including the attached supporting documents.) from Oracle migrated to Sage. We proposed Using Sage Import template but they insisted they prefer using a data migration tool( for efficiency and data integrity…
  • Invoice Matching Data

    Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. Regards, Dave
  • Balance Update column in Accounting Tasks

    We are seeing a value in the "Balance Update" column in Accounting Tasks and we can't get rid of it no matter how many times we run the resynchronization functions. When we try to run the "Account Balances resynchronization, we get this error which also…
  • Planning work order material import for BOM change

    What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…
  • Import multiple files with reccuring task

    Hello everyone, I'm trying to import multiple files thanks to a reccuring task but the task gets stuck after the 1rst import. Here is the import part of the script I made for my task: Call LISFIC(YOS,YMACHINE,YDOSFIC,YNBRFIC,YLISTFIC) From SELFICREP…
  • add Invoice header text after posted

    Is there a way to add Invoice header text after the invoice has been posted? I'm looking in the tables and there is a code but where is the actual text placed? any help appreciated. thanks.
  • SAGE ERP on DBCS OCI

    Hi all, It looks SAGE ERP is compatible only with Non-CDB Oracle DB. So this will create problems if we would adopt DBCS as SAGE ERP DB, correct? Any similar experience on SAGE to share? Is there any workaround you can suggest in order to make…
  • About attachment folder when archiving records to archive folder

    Let's take an example, in SEED folder, I have a Purchase Request record dated 2018. This purchase request record has two attachment in ATT folder of the SEED endpoint. I will run an archive procedure for Purchase Request with shelf life of 2 years now…
  • Does anyone know what this Statement field on Supplier invoice mean?

    we are trying to do an import of AP invoices and the import is automatically checking the below field. What is this field? I can't find any help on what it does. And seems need to go into open items screen to uncheck it. thanks c
  • Payment is not posted in PAYCUR

    Hello everyone, I have encountered an issue while processing payments in All > A/P - A/R accounting > Payment. Here are the details: Open Item: AMTCUR = 20,100 1st Payment: 6,030 2nd Payment: 10,050 Upon making the payments,…
  • Product is in stock with 0 quantity, location shows a quantity with no product

    Hi there. There seems to be a de-synchronization between the product and its location. The product shows null quantity in the location. The location shows a quantity (59) but a null product and is "empty" Misc. issue and receipt is also messed…
  • Folder Export in Console using Bulk Copy (BCP)

    I have folder that i want to take svg for to refresh into the UAT enviroenmnet. However the SVG process takes very long time to export because of the size of the data~ 2TB Database. Now i am trying to use the BCP option to see if it can speed up the process…
  • Seeking Guidance on Managing Permissions and Data Differentiation in Multiple Sage X3 Folders

    How can I manage multiple folders in Sage X3, where I need to add users, adjust permissions globally, but ensure that data (such as products and orders) remains distinct for each folder?
  • Question about folder importing Sage X3 database from a SQL Server 2022 instance to SQL Server 2016 instance (higher version to lower version)

    Hi, Question: Can I import Sage X3 folder which was taken from a server using newer version of SQL Server to an older version SQL Server? Second question: Can I import Sage X3 folder which was taken from Oracle database to a SQL Server database? …
  • Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • Import Sales Invoices with deliveries

    Good afternoon, Does anyone have experience importing sales invoices that come from a delivery? We need the delivery data to be transferred to the invoice. I am using STD import models.t Thanks!
  • Error while exporting supplier data Cannot read property 'GRP' of undefined

    Hi All, I am trying to export data of supplier using xml in Http Request in .Net with direct credentials not SSO One On calling the below xml i am getting response of Cannot read property 'GRP' of undefined Can anyone kindly guide how to get…
  • SafeX3 - 4GL - BlbFile conversion

    Hi, I need to convert a string from base64, I use the function YLEN=b64Decode(YB64RES, YBLOB). Then I would have to convert the BlbFile back to a ClbFile or Char (I need to parse it) but I wouldn't want to have to write YBLOB to the filesystem and then…
  • Product Line Details

    Looking to see if anyone can direct me to a table that houses the details from Product Line entries on ITMMASTER.
  • Restricted Characters for Imports and Exports

    Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…
  • Seeking Advice on Excel Exports and XML Transformations from Sage X3

    Hello Sage Community, I hope everyone is doing well. I'm reaching out to discuss and seek advice on an issue we've been facing related to Excel exports, specifically for account extracts, from Sage X3. I am working on the v12 implementation in a company…
  • Remittance Import Template - Can't Link PAYFRM and PAYMENTH Tables

    We're working on a remittance import template for our client and are looking for a way to link the PAYFRM and PAYMENTH tables. Currently when adding FRMNUM to the link column, we encounter a warning stating that the link does not appear coherent. The…
  • Sage X3 - Consistency Errorrs

    We currently run Sage X3- multiple Versions including V12. SQL Server 2019 and X3 running on the same machine SQL database Collation is Latin1_General_BIN VMWARE 7.0.3n Starwind vSAN Two servers for failover We have noticed that we are getting…