Sage X3

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.

is there a way to formt the date so it show 190531 so that would mean May 31, 2019? I need it formatted this way since the import template is storing the date in this format. Thanks, Chris

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.

We are on version 11 patch 9 I created a table and a custom import template: The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…

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…

Hi All, I have 2 problems both to do with imports in V11. 1. Importing product images. My client has 10,000 products with images how can they import them, en masse? 2. Importing comments against objects. My client wants to import the comments that…

I am trying to setup a workflow for failed import but can't find the correct condition. I managed to trigger my workflow for each import (event type Import/export and Operation IF) but I can't find the correct condition to trigger the workflow only…

Hi, I'm trying to create projects (GESOPP) through REST Webservice.. I can create into OPPOR table but when I try to create for OPPORCRM (needed to be visible in GESOPP function) get the error message: "A Pre-sales or After-sales step must be…

Hi, Anyone can provide an example on how to skip a specific row while using import model? We tested a script where we set the GREP="" in the IMPORT action if we do not want to import the current row. After some testing this approach it's only working…

I am trying to update a journal entry, that has wrong date to the right dates. When I export the information and change the information and re import the file, its giving me an error that the record already exist. I am using the JAS2 Template, I am…

Hi, We have a customer on PU8 patch 6 and we are currently experiencing a problem with recurring tasks not continuing to execute. Some more information: The tasks are set up to start at a particular time each day, say 04:30. Taking one of the…

Hi, i'm using an import model that work on two tables... during (or after) the import process i need to update a field of a third table. Ho can i do? Thanks a lot!!!

We're using X3 V6.5. When using the PYRAGAS template, doing an export and then an import with the same data creates the error: actual journal already exists. Any solutions/ideas? I'm trying to get to the point where I have a working template to…

Good day everyone, We are working with out connector under a client that have the versión 8.5 of X3. Just for doing an small introduction we have a software embebbed inside x3 that using the import system template of X3 allows us to create the deliveries…

Hi, How do I use IMPORTSIL in V7 classes and representations style coding? "Call IMPORTSIL("YBPP", WNOMFIC) From GIMPOBJ" doesnt work anymore. Best Regards

I'm interested to know if it's possible, and if so, if anyone has any examples on setting up a template for importing an intersite transfer. The function I'm referring to is GESSIS. It looks like intersite transfers are fairly similar to internal stock…

I am calling an import template from code. 1) The first issue I am having is, I want to suppress the error that pops up if the import fails or is successful. I don't want any message to pop up - i just want to handle the result in code. 2) The second…

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…

Hi, i need to schedule an import module. How can i do? Best regards.

Hi everyone, I have an import template that uses the tables SDELIVERY,SDELIVERYD and STOJOU for importing to x3 the delivery notes from an external system, this delivery notes are SALES delivery notes not purchases. Is working properly creating the…

Hi, We are using AVC valucation method for the raw material.. To calculate the standard cost, we are try to upload the standard cost.. but I got error "multi cost error" when i try to upload (ITC import template) the stand cost for the new product…