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.
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?
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…
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…
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.
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 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
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…
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…
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,
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…
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…
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…
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…
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…
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…
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.…
Hi,
Can anyone advise how to increase a limit of row level permissions (Parameters --> Users --> Users --> Organisation) in user setup? It is set to 10 in my organisation and I need to be able to add more to some users.
Thanks
Ania