x Want to participate? Join the group to interact

  • Trying to add lot shipped to a custom invoicing report.

    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.

  • Anyway to filter a view when creating a Distribution job in SEI?

    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…

  • Querying the SEI database directly

    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…

  • Top 100 Customers

    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?

  • Issue with graphical query tool screen

    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…

  • SEI Year selection

    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…

  • How can we prefix the order of a list in the representation?

    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?

  • How to execute a SQL Query using 4GL?

    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…

  • How to do a select distinct in Query tool

    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.…

*Community Hub is the new name for Sage City