Sage X3

I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…

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…

Good morning, we make a call to a WS WSIMPORT (SSH) from .net and in X3 we have a SPEIMPSDHS that records the trace using the function ECR_TRACE and it is returned by the WS in WW_MESS, well, sometimes it does not work, that is, the WW_MESS variable…

Good day We have a customer that wants all data (including the attached supporting documents.) from Oracle migrated to Sage. We proposed Using Sage Import template but they insisted they prefer using a data migration tool( for efficiency and data integrity…

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…

Hello everyone, I'm trying to import multiple files thanks to a reccuring task but the task gets stuck after the 1rst import. Here is the import part of the script I made for my task: Call LISFIC(YOS,YMACHINE,YDOSFIC,YNBRFIC,YLISTFIC) From SELFICREP…

we are trying to do an import of AP invoices and the import is automatically checking the below field. What is this field? I can't find any help on what it does. And seems need to go into open items screen to uncheck it. thanks c

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!

Hi All, I am trying to export data of supplier using xml in Http Request in .Net with direct credentials not SSO One On calling the below xml i am getting response of Cannot read property 'GRP' of undefined Can anyone kindly guide how to get…

Hi, I need to convert a string from base64, I use the function YLEN=b64Decode(YB64RES, YBLOB). Then I would have to convert the BlbFile back to a ClbFile or Char (I need to parse it) but I wouldn't want to have to write YBLOB to the filesystem and then…

Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…

Hello Sage Community, I hope everyone is doing well. I'm reaching out to discuss and seek advice on an issue we've been facing related to Excel exports, specifically for account extracts, from Sage X3. I am working on the v12 implementation in a company…

We're working on a remittance import template for our client and are looking for a way to link the PAYFRM and PAYMENTH tables. Currently when adding FRMNUM to the link column, we encounter a warning stating that the link does not appear coherent. The…

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, When trying to update a product using the import Web Service AOWSIMPORT with a template containing the UPC code field EANCOD, I always get the error Field EANCOD (12345) : Value already exists. Bu the only product with UPC code 12345 is the one…

Hi, I am trying to import different sales invoices (Credit memo, Standard Entry) using SIH template. Template is creating the invoice starting with invoice number as INV but for credit Memo, it has to be SCM. The template is not recognizing the Type…

Hi Sage X3 v12p30 When using Sage X3 Console, when I try to import a new folder, this loading of folders is taking a very long time.

Hi, I am trying to Import Supplier information using a Text file. But I keep getting errors for suppliers with Canadian Postal codes. I checked the Postal Codes table and they do exist in the table. I am getting below incorrect format error. …

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…

Hi Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. I can not seem to get any assistance on this as Sage mainly deal with the MT940 files. Do clients actually…

Hi I'd like to import email contacts under this contact function for about 1000 BP's. I have my list of BP's and the email address. I will flag them all with code being their BPCNUM followed by _STA. All fields will be the same such as language, country…

Hello please should be informed that when i tried to import SEED Folder to console management all steps pass OK unless the last step it give error the impacted envirenement WIndows 2019 server SQL SERVER 2014 SAGE X3 V11 can you help plea…

hi, I am importing a file from another system into X3 and getting an error as in subject line and screenshot below. I checked the template configurations in Setup and go into BPAPAY line and couldnt find anything really to change so I have not clue…

For example, if folder name is: PRD. ``` X3 Console, folder import: Error while running _lstfilseqprd.bat in folder to import : NOK (LibAdm.GenScriptsImportFolderNT) The system cannot find the file specified. ``` Cause: One of the required sequence…

Hi, In 4GL, I know for silent import, there is IMPORTSIL (From GIMPOBJ). How about, in 4GL, the silent export function with filter option? I know I can do a manual file write inside the 4GL script but it is very annoying to maintain. Web service…