• 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…
  • Procedure in SEI

    Can anyone briefly explain what the procedure is in SEI? It would be much better if an example could be added. Thanks in advance!
  • is it possible to hide 'Column Group Heading' form worksheet?

    is it possible to hide ' Column Group Heading' form worksheet?
  • Grouping in excel

    Is there a way to utilize grouping in Excel inside of an sei add in report? For example, sales by customer and product, group by customer with the option to expand to see the products?
  • Are there Customer Contacts in SEI

    I'm trying to create a report and need customer contacts. Does anyone know if there are customer contacts in SEI?
  • Building a data model based on the LOG_VIEW_USAGE to monitor views usage in SEI

    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…
  • Dynamic field names in SEI

    Is there any way to have the fields/columns in an SEI report to have dynamic names controlled by a formula? My guess is "no", but thought I would ask. In my specific instance, I have fields like "Month 0" "Month+1" "Month+2" etc (the data is taken from…
  • How to fix "Index was outside the bounds of the array." error?

    We are trying to make a pie chart off a data model using the "New View" option. We are getting an error message, "Index was outside the bounds of the array.". Have you seen this message and how do I correct it? Screen shot below.
  • 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…
  • Adding current Date to an SEI Dashboard

    Hi Everyone, I am trying to add a current date widget to an SEI dashboard. I have tried to add a KPI view with a calculated column containing @@CURDATE without success. Best regards, Tarik
  • SEI count of entries in a worksheet

    I have a list of suggested and firm workorders in an SEI worksheet coming from the ORDERS table. Very straightforward. What is stumping me is I'm trying to make a column that counts the number of work orders that have the same product as the current record…
  • Excel Addin for Macbook

    Can some one please help me where can i get excel add-in for MacBook. If the answer is CSV , than let me elaborate there are few additionally added field those data are not getting captured properly in CSV Format. DO we have any work around for this or…
  • 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?
  • Copying a View in SEI

    Is it possible? I can copy a process, but not a view?
  • 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…
  • Feature Request: Scheduler to suppress emails when restrictions result in no data

    Hi, My first time posting something here, so I apologize if this is the wrong place for this. Here is the situation. We are using SEI version 8.2.7. When using the scheduler to email out reports, we have a report with multiple users, each with different…
  • V12 Custom Table/Class joined to ITMMASTER

    I have created a custom table and class and would like to join this to the ITMMASTER class. However, in the mapping section of the ITMMASTER class, on Table Joins, I cannot enter the a reference for the custom table. How can I make the table available…
  • 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…
  • Issue Embedding SEI Dashboard into a Sage X3 Home Page.

    I have an SEI Dashboard that I have embedded into a Sage X3 Home Page by creating a Menu item (Gadget). The problem I am having is that the SEI server is refusing the connection when the URL is executed. I'm assuming SEI is looking for credentials but…
  • How you can extend the long object ITM object from 30 to 80 characters.

    How you can extend the long object ITM object from 30 to 80 characters.
  • How to perform a user audit in SAGE X3?

    We have a customer that needs to audit the activity of one user under SOX compliance. Is this possibel in SAGE X3? We have the Audit trace on tables and fields but this is decreasing performance and growing the database (almost higher than the actual…
  • Factory ID in MenuItem

    How can we create menusitems, etc, with a specific Factory ID for our ISV?
  • Dynamically creating where clause

    I am dynamically creating a where clause for a choose statement. The problem occurs when there is more than 2 lots. It will loop through correctly (say 3 times), but only adds the first 2 lots to my where clause (CRITERE). Is there a limitation on how…
  • 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…