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

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…

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…

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…

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…

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…

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

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…

I have images in jpeg to import for each shipment in X3... Maybe use CBLOB table to store an image for each shipment. Need help in setting up import utility to read data from a text file plus upload image. Thank you, Raj

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…