Sage X3

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…

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?

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…

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…

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…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

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

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…

Is it possible to import multiple companies and sites?

Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…

Can sage send data to a webhook? If so, could you elaborate on the process for this? Thanks, Chris

We created our own custom table, and we want to import data to it. There is no function code for this table so we cant use the import/export templates. Anybody got any ideas?

What would be the safest way to mass update the pricing for all the product in the system. On the product site- Under the cost tab I want to update Standard cost for all the products.

Can somebody tell me what table the values for quantity qualified PAC, quantitity qualified STK, warehouse, etc is being stored in? There is no reference tables on the screen level.... The screen code is STOQUA

I am trying to update a journal entry, that has wrong date to the right dates. When I export the information and change the information and re import the file, its giving me an error that the record already exist. I am using the JAS2 Template, I am…

Hi, i'm using an import model that work on two tables... during (or after) the import process i need to update a field of a third table. Ho can i do? Thanks a lot!!!

We're using X3 V6.5. When using the PYRAGAS template, doing an export and then an import with the same data creates the error: actual journal already exists. Any solutions/ideas? I'm trying to get to the point where I have a working template to…

One of the department is hoping to update Boms in relation to a particular field. That field is scrap on the BOM. I have access to SQL. But Before I do anything I wanted to know how others have done it or what would be the best practice.