Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
Hello,
I am trying to build a data model based on the LOG_VIEW_USAGE table from the SEI database and I'm getting the error below when trying to add tables in the data model designer :
Nectari.DAL +++: Index was outside the bounds of the array…
What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…
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 All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks
SQL stored procedure call from X3