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…
I am facing an issue while connecting the DBMS tools installation path, although I get the path automatically but when I select that I see the error (attached below) .
I have added the version and sql path in the solutions.xml file but still no luck…
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…
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…
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…
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
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…
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…
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…
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…
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…
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…