Browse By Tags

  • Planning work order material import for BOM change

    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…
  • Import/Export - BP Numbers

    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?
  • Correct XML format for I_FILE with AOWSIMPORT?

    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…
  • Having error while using BIS import template to import file

    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…
  • Importing Analytical Dimension for Products

    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…
  • Importing GAS Error: Record Already Exists, but it doesn't

    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…
  • Deleting Sage X3 folder from database

    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…
  • Setup workflow for failed imports

    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…
  • IMPORT AND EXPORT

    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…
  • Recurring tasks stop executing

    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…
  • How to update field table during import

    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!!!
  • Import PYRAGAS template generates error "actual journal exists"

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