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…

Good afternoon, Does anyone have experience importing sales invoices that come from a delivery? We need the delivery data to be transferred to the invoice. I am using STD import models.t Thanks!

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…

We are working with AvidXchange to import payables into X3 and have run into an issue. We are using he standard import process to upload .csv files exported from their system, however Credit Memos are being created by Avid with a negative value. X3 is…

I and working on a web service to create production tracking transactions in X3. The standard X3 object as a web service does not work well, because it causes pop-ups that cause the web service call to fail. So I'm doing import templates from the web…

I need import 101 for dummies as we have never used imports before. Goal - to take an excel file containing supplier invoice information and import it into X3. I am on v12; patch 18. I have read the help from Setup>Usage>Imports/Exports>import/export…

Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…

Hello, I'm trying to build an import template that allows me to create ITMMASTER and ITMFACILIT records at the same time. These are the fields I have listed below. When I attempt to import based on this template, the Product in ITMMASTER is created…

Hi, I am trying to do a misc issue by import the data in. I changed the file type for the import to be delimited and the date formatting, but everything else for the template is the same. Below is the error message i am getting returned when I try to…

Hello Im working on importing Expenses but i get this error although i did make sure of the account nature in account function Can you help me please

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…

Good morning all Does anyone have the Excel template that's used to import 1099 Beginning Balances using the B9B import? Chris

Hi, I am trying to update close flag in work order to Yes through Import.Kindly let us know is there any logic behind it along with impact table and field. Currently am linking MFGOPETRK, MFGOPETRKHEAD, MFGOPE,OPERATION

Update 9 Patch 9; 1. The number of tables (identifiers) in an import / export template is limited to 8. 2. Views cannot be referenced in an import / export template. Please tell me these statements are not true, or practical ways you've worked around…

I'm running X3 Update 9 Patch 9. For an Import/Export template; 1. is it possible to increase the number of tables in the 'Identifier' grid beyond 8? 2. Is it possible to refer to a view (rather than a table) in the 'Identifier' grid? My…

Hello City Slickers! I'm running into issues with template FTISMR while trying to import my initial go-live inventory in Sage EM. My products are version managed and I only use the Major version. after I do a single product import test, Sage gave me…

Hi all, are there any default import export template for the object PJM in Sage X3 v11? I can't find it anywhere in my Sage X3.

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…

Client on Enterprise Management (Sage X3) PU8 Path 5 is having an issue on the template. When they try to import GL templates GAS the system is ignoring the dimension values that are in the template and is using the GL account defaults. What setting…

When using the stock version of the SMO (Miscellaneous Issue) import/export template, you'll notice that it will NOT work with any inventory items that have a coefficient greater than 1 You'll receive an error stating that "the stock to issue has not…

We create multiple entry transaction codes for the SMO (Misc Issue) object. We have auto-journals to create different GL entries based on the entry type code. We have verified that the auto journal works properly when entering a Misc receipt using the…

I have been asked by the Finance team to import budget data into X3 from several CSV files they have created. I am using a slightly modified BUD import template and am able to verify that it is matching all of the data to the right fields using the Test…