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.
I am reading that in order to add a lot number of what shipped/invoiced to my query I need to add the STOJOU table in the graphical query tool. I cannot figure out how to link the STOJOU table to anything. I am VERY new to altering queries.
I set up a data model based on a view in Sage. Then I created a worksheet view and everything works well including the ability to filter based on columns within the data model. I noticed that when I went to set up a distribution job, I didn't have the…
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…
Hi all! Trying to build a worksheet for top 100 customer revenue YTD. I have the customer name as a group and the measures as columns. Any idea on how to get it to sort descending on revenue instead only at the group?
Hello,
We are facing issue on graphical query tool like the graphical query screen just blanks out the editing box when we click on it. We are using sage X3 version 12 patch 22. Kindly check below screenshot for the same.
In the above screen shot…
Hi,
After installing template for Sage X3 on SEI, our customer try to select year in popup filter but list is empty.
Is there a script or action available on administration to populate this list ?
I try to add manually one record on the ZCALENDAR…
We have a representation of purchase documents, and in the list we want that by default we appear ordered by date in descending order.
How can we do it?
Hi,
I'm new in development for X3 and I need to execute a SQL Query using 4GL.
I found this link https://www.greytrix.com/blogs/sagex3/2013/11/22/executing-a-sql-query-using-4gl-language/ but I don't know where and how to create de function GETDBTYP…
I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…