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.
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…
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…
Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only.
PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…
Hello,
I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…
I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components.
I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…
Hi
I have a customer with a v12 installation with multiple folders (SEED, PILOT, X3). Every folder is somehow pointed to the PILOT data. I have checked SQL, and the normal SEED data is present,. If I add record in any folder, it is reflected in all…
I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
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…
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…
I need to update the SO and PO tables on a daily basis to test an automation customization I am working on. Has anyone used the Microsoft SQL Import / Export Wizard to create an SSIS package to copy data from PRODUCTION to PILOT? Does that work? If so…
Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB.
I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text.
This works fine in SQL, but when I try in the SQL Requester…
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…
I am running Sage X3 V6 and SQL 2008, on windows server 2008, want to upgrade to windows 2016, with SQL 2016, but keeping version 6 intact. Will there there be any problem?
how much will be the cost and time required to perform, how much downtime? any…
Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report…
Hi guys,
I need help!
My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis
Please how can this be achieved?
Hoping to get a positive response
Thanks
Hi. I did a store procedure to explode BOMs up to the leaf level by saving the list of components in a table. The store is obviously recursive (it calls itself). Throwing it from SSMS works properly by exploding the entire BOMs to leaf levels. Launched…
we need to allocate specific version of products to order.
2 Active versions
Ex SKU1 qty 1 version A in stock
SKU2 qty 1 Version B in stock
If I placed a customer order for SKU1 Version A for qty 2 , in any case I would like Sage to allocate…
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
We have setup sql 2016 on v11 p15 with the high availability option which in the end uses a "listener" which is a virtual server with static ip to connect to. if the primary node goes down the secondary becomes primary. So the current std setup has X3…
Hello Everyone,
I want to create a purchase invoice for the receipts which are having only "A" status.
For Q and R status receipts system should not allow us to create an Invoice.
Just for your reference, I had done the following setups:-
Parameter…
Sage X3 SQL User creation error
We are having an issue with Sage X3 V12 PU15 installation where the client has complex password policy on their windows domain.
The challenge we are having is that SQL is inheriting these policies and we are getting…