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