Sage X3

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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…

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

Hi All, I installed the Oracle RDS database instead of MS SQL Server. The database is on diff. server and location and the challenge are – how to config. this in the below screenshots in Sage X3 Console? What are the inputs required to provide here…

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

I have a client with this table growing at a rate of 15G per day and its already over 300G There is no documentation as to what this table does can we truncate this table using a batch task is there any implications?

I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …

Hi All, I'm trying to write an SQL query that links to the Description field of a product stat group on an Item Record. Its a miscellaneous table (22) which I have found in the ATABDIV table, just cant work out which table that links to for the Code's…