• 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…
  • Lack of data in Data Model and Views

    Hello, After verification, I found in a worksheet of Data Model and View, it lacks the data of one day from Sage X3. The specific is: In a purchasing worksheet in SEI, it only displays the data of February 1, 5, 13 and 27 from Sage X3. However,…
  • 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…
  • @X3.TRT/GOBJET1$adx (163) Erro 76 : Erro SQL server (Microsoft) [ODBC Driver 17 for SQL Server[SQL Server] Invalid object name

    Hello, After updating to p34, when trying to create a client (GESBPC) the following error appears: Checking the database, the table in question does not exist: What do we need to do to adjust this information, is it on the X3 or SEI?
  • 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…
  • SEI - Export to CSV/XLSX with special characters

    I've set up a view from a data model and it comes out fine within the view. When I try to export the view as csv/xlsx, any special characters such as / or & are converted to their hex values. Is there any way I can export it correctly with SEI converting…
  • Understanding date in STOJOU table

    I am only looking to find specific inventory movements in the STOJOU table and need a way to determine the Type of the Transaction I see the TRSTYP_0 field but cannot find the definition of what those values represent. Can anyone help?
  • 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.