Sage X3

which field would link an item to a location or many locations ?

Hi There, We have a test environment called TEST 2024, does anyone have the steps to deactivate it? It's interfering with another connection that we have. Thanks, Julie

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…

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…

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

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'…

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…

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…

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…

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…

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

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…

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…

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…

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.

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…

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…

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

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,…

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…

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…

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?

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? …

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…

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!