• Personal information DB federation X3

    Hello, Our Sage X3 instance is located in AWS Frankfurt. We will migrate our Australian Operating Company to Sage X3. However, we know about Australian data protection law. Can we host a personal information db in Australia and federated to the X3…
  • Default Locations

    I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…
  • Sales Order- Credit status to Prepayment

    How do we get the credit status on the sales order to display 'Prepayment'? We have the payment terms configured as prepayment and the parameters in TC, TRS and VEN appear to be set accordingly. Hoping someone can assist. Thanks, Christine
  • Connection to server failed : X3 engine error: The SELECT permission was denied on the object 'APLLCK', database 'x3v12', schema 'DEV'. : ini_com:Variable dimension:!(2)

    Sage X3 v12p34, SQL Server 2022 Standard edition. Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…
  • Import of miscellaneous receipts for inventory

    We are importing inventory receipts into a new warehouse. We are using the import template FTIMSR. It works fine. The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3. If we build a long…
  • 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…