Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
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 would like to add additional costing components to existing product BOMs in Sage X3 (v11). When using the import template BOMPD, it requires a field for the BOM component sequence (BOMSEQ), however, each BOM has a different number of existing components…
Hi,
Sage X3 version: X3 v12 Patch 33, hotfixed with Syracuse latest version.
Was doing a folder data integration through batch, got canceled.
Checking the logs:
06-14-23 13:38:19 (Application server time) Query terminated with error (Who is…
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?
Use Sales Delivery as example:
I want to click new, fill in the site and customer
Then import the detail information like product etc from a file
Upon completion create the transaction.
Possible?
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…
Hello all, Our company is currently running Sage X3 and we are looking to build a small B2B WooCommerce website for about 30 products for our customers to purchase through. Woocommerce, with the help of some plug ins, can generate spreadsheets/csv's in…
The Import job which was setup several years ago has been working like a charm and kicks off about 4 am. Lately, it's been failing once or twice a week.
The job has been setup as a Group of Tasks starting with the Import of Visa/MC, Amex, Disc,PayPal…
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,
I want to do delete many partner after a bad import. Do you know, how can i import into ADELETED any data ?
When i fill the ADELETED s grid, i need to enter only OBJ et CLE but for the import it doesnt work with this two fields only.
Thanks…
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…
I was unable to find any other posts regarding this pre-loaded import template. My company does not utilize ADCs in our Production process so I wanted to utilize the MKI import template. I exported sample data read the Sage Online Help Center guide on…
I am attempting to import sales orders where the ship-to address is not already defined in the customer record. I added the following fields to the standard SOH import template: BPDADDLIG, ADDLIN2, BPDCTY, BPDSAT, BPDPOSCOD, BPDCRY. I expected that the…
We are on version 11 patch 9 I created a table and a custom import template:
The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…
Hi,
Im trying to import some Sales Quotes (SQH) files through IMPORTSIL code.
If I use the IMPORTSIL code in GESOPP function I get this error:
If I use the exactly same code, with the exactly same file anywhere outside the GESOPP it works…
Hi All,
I have 2 problems both to do with imports in V11.
1. Importing product images. My client has 10,000 products with images how can they import them, en masse?
2. Importing comments against objects. My client wants to import the comments that…
Hi,
I'm trying to create projects (GESOPP) through REST Webservice..
I can create into OPPOR table but when I try to create for OPPORCRM (needed to be visible in GESOPP function) get the error message: "A Pre-sales or After-sales step must be…
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…
Good day everyone,
We are working with out connector under a client that have the versión 8.5 of X3. Just for doing an small introduction we have a software embebbed inside x3 that using the import system template of X3 allows us to create the deliveries…