Sage X3

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

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…

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 am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

Hello Sage City, As a Sage partner, I have heard numerous horror stories about the "PURGE" function in older v5, v6 and v7 versions of Sage X3. A customer of mine will be migrating to v12 shortly and asked about purging old data from the database…

Hi, h ow can I make the equivalent Del *.* or Del *.txt command execute with the DelFile statement? It seems that it only accepts paths with precise filename indications, such as [xxx]/abc/123.txt and instead [xxx]/abc/*.txt fails. Roberto

Hi, Found a situation here: When I observed the Console import, it can import fine. It clears 1.1k tables import like a champ with 100% clear When it comes to Console validation, the tables are hit with warnings. ``` <0001 Erreur en…

I am having problem while import using BIS import template, there is error on DUDDAT field. But when using import simulation, DUDDAT can get the value from my import file. Is anyone facing this problem or anyone can advise me on this? The attachment below…

Hi, I need advice and pointers to identify the root cause of the import failure issue. Sage X3: v12 Patch 31 (latest patch by time of writing) Database: SQL Server 2019 Standard All components are updated to match Sage X3 v12p31 requirements. On…

From the screen I can see the value for LOC, but not in database, the value is empty.

Hello, I am pretty new into X3. I am wondering how can I import translations. After reading several articles, I have no doubts that ATEXTRA table holds the translations. However when I get into the table, I cannot see any translation. I read about…

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Products have analytical dimension PRO defined and I'm importing them using an import/export template with field CCE(0). This works fine for part of the products, but many are rejected with the error message Field CCE : Analytical dimensions : 001PPINSC0…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

My understanding is that STOWIPW table shows the users who are in the process of selecting stock. And when we runs "Quantities entered resync" (FUNSTOWIPW), the system will check STOWIPW records and correct the CUMWIPQTY and CUMWIPQTYA fields on the STOCK…

Hi everyone, If I were to extract supplier master data for active suppliers including addresses etc. which tables should I export the data from? We use Sage X3 v7. Thanks, Matt K

Hi, Sqlserver2018 Sage database, who used the “notification query” function? does it create problems for Sage's normal work? Sage X3 Version 11.12 ALTER DATABASE NAME_DATABASE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE; CREATE QUEUE PortalNotificationQueue…

Sage X3 ERP v7 Patch 8 I'm trying to figure out how to import Journal Entries to alleviate the time spent by our Accounting Dept. I know the data I'm inputting is accurate because I'm just re-importing data exported from the Production server (excluding…

Is it possible to import purchase orders and assign the PO number at the time of import. These PO's are coming over from the retired system and we do not want to use the sequence as part of the import. Looking at KB 95260 it implies this is not possible…

Is there a definitive list for what is considered a special character?

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

A stock movement ran into an error and it made the quantity stuck in the CUMWIPQTY column. How do I get the product to be released from this column?