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?
On MISC RECEIPT screen
SPE:
Subprog AP_LOT(VALEUR) Variable Char VALEUR()
The VALUER variable is empty when I use a import template, but not when I use the UI. Help please
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 want to save the filename of the file being imported. It is disaplyed in the log, but I don't know in what variable it is stored.
It is NOT "FICHIER" or "[M:IMP2]NOMIMP".
I'm trying to work out the correct format for the I_FILE parameter when using AOWSIMPORT to do an import, when the template specified in I_MODIMP is an XML template. I can get it working fine with a flat file structure for I_FILE, but I can't work out…
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…
When importing receipts with a batch traitment, some records can be rejected because the linked purchase order is locked by an user.
(This can happen while importing other X3 objects too, especially when imports are carried out while users are working…
Hi Sage Community!
After struggling with this problem I decided to post it here just in case someone had or is having the same situation as we do.
We have a system that manages the receipts thought import templates and is working just fine in different…
Import templates POH & POHFL does not allow to import open orders and delivery requests. It would be useful to have a standard import template (and associated scripts) for open orders and delivery requests.
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…
