• Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…
  • BPSUPPLIER SCREEN (X3) - CONTACT default field KCNTFLG not in MSSQL database tables - CONTACT or CONTRACTCRM

    October 25th, 2020 Hello Teams, Need your help. :) BPSUPPLIER-->CONTACT-->CONTACTCRM Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables. Goal - I am looking for where the CNTFLG field is stored…
  • Foreign keys

    Hello, I would like to draw links between tables (automatically). But I didn't find any foreign key in INFORMATION_SCHEMA.TABLE_CONSTRAINTS. I checked other tables without success. Could you please help me? Best regards, Nicolas
  • Accessing data from Sage X3 from a shipping program using ODBC

    Hello, I have Fedex Ship Manager software and I am trying to integrate it with our Sage X3 software using ODBC and SQL. I am only able to see sys tables when trying to link. I even set up a new user in SQL manager with full rights. The Fedex software…
  • X3 V12 Installation Issue - Error in the application

    When configuring the solution, the data server shows active, after setting appropriate paths, then clicking the "Application" button near the top of the screen, I'm getting the error below. I've followed the instruction documents and had no issues with…
  • Data Purge Parameters

    Hi, We are a Blending & Packaging plant and have v9 Patch 5. We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...) We've started to purge out some old data like the ATRACE and investigating into the…
  • Table Validation Error PAYMENTH Error No 76

    This error comes up anytime I try to validate any table. Please has anyone encountered this before?
  • installation Error

    Hello, i have an error when installing EM 29/03/2019 00:30:31 : ERROR - Error lauching sql file for storage checking. NOK (LibAdmAdonix.RunVerifSchemaBaseSqlServer) Le chemin d'accès spécifié est introuvable. with this parameter software.adonix…
  • Error on Setup > User - Pilot FOLDER

    Hello all, When I am in the PILOT folder trying to access Setup> Users, "GESAUS" function, the system presents this error: Error only on PILOT folder. I'm using Admin user, this started happening after validating the menu in the function…
  • What are the steps and documentation required for a post implementation support of a SAGE X3 ERP?

    Hello Guys, I am just a newbie here in this forum and hoping to get along with you all. Moreover, I am about to support a newly implemented ERP system in-house through a post implementation phase and am just wondering what are the proper steps and…