Sage X3

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…

Bonjour, Pourriez vous m'aider à automatiser le transfert intersite sur sage X3 en passant par des imports ou autre solutions. merci

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…

When trying to import a csv file into Sage X3 I am getting this error. Any ideas how to resolve?

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

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…

I was trying to do a coverage installation of P21 to upgrade from P16, I did it with my demo environment and kept the snapshot of P16 in my VM. After installed all components and validated the SEED Folder, it ran all right except one thing, ALL MY Syracuse…

Hello, we have the requirement to allow negative NET pricing on certain lines on Sales Orders, Deliveries and Invoices without using the discount fields. I've been able to enter a negative amount on the GROSS price for a line item, but then Sage makes…

Hi All, For one of our customer we have written a sub program based web service in which we have used standard import export template to create the sales order in the system. The reason behind using the import export template is, we have sales kit product…

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…

I am using Sage X3 version 9. I am trying to import a lengthy general journal entry. How do I do this? Thank you for any guidance you may have.