Sage X3

The latest version of Sage Enterprise Intelligence (SEI), 2022 R1.3 and related templates are now available for download directly from Nectari. SEI and templates are no longer available through the Sage Knowledgebase. You must be registered to access…

The latest version of Sage Enterprise Intelligence (SEI), 2022 R1.2 and related templates are now available for download directly from Nectari. SEI and templates are no longer available through the Sage Knowledgebase. You must be registered to access…

The latest version of Sage Enterprise Intelligence (SEI), 2022 R1, and related templates are now available for download directly from Nectari. SEI and templates are no longer available through the Sage Knowledgebase. You must be registered to access…

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.

Sage Enterprise Intelligence (SEI) downloads are now available directly from Nectari. The downloads will no longer be available through the Sage Knowledgebase. To obtain SEI downloads: Register for downloads at the Sage Enterprise Intelligence sharefile…

Anyone know how to do that? Looking to figure leadtime as the number of days between order date and ship date. I did a calculated column in the view of ship date minus order date and it retuned zero. Did a calculated column in the design process and it…

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 process basically just using the ORDERS(WIP) table. When there is no value for MRP date, SEI shows '01-01-53'. How can I suppress that and still have a value when there is an MRP date? I've played with the calculation but no avail. Was trying…

Hi, I was wondering if anyone else had a similar issue when building graphical view on SEI. On the screenshot bellow, for each product category on the legend I get duplicates of the column's description. Thanks in advance for your help. Tar…

Good Day I am attempting to create a trial balance that includes opening and closing balances, but I can't seem to locate where those options live in SQL or in X3. Is this something I will have to make a formula for? If so does anyone have any advise…

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…

I get a warning when trying using "show prompt" on a group dimension. I looked at the admin guide and didn't really see how that was done. Would one of the gurus explain how to add that to the process definition? Version 8 here. Thanks in advance.

Received a request from a user that he could no longer access his account nor reset his password. Upon attempting to reset the password myself, I received the error message below: "Cannot reset password for an active directory user" I believe the…

Hi Team, I have created a new dashboard to display the SEI data charts in X3. I'm using Chrome browser, i refer this article to fix the issue but it doesn't work. https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId…

Anyone know how automatically show only the last 30 days data?

Anyone know how to prevent a calculated column total? Would it be better to add the column in Design Process? Version 8 here.

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, It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward. When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…

Hi, Please can someone guide me to setup SAML2 in SEI. Also, after we complete the installation would we be able to login with admin user without using SAML2.

Newbie here. I have a graph built but the labels aren't incrementing the way Id like. It's defaulting by 50,000 but I'd like to increment by 10,000.

I've created a new folder in Favorites. How do I move what's already there into the new folder?

Hello, As the title suggests, my business' reports are now being sent out an hour earlier than they should due to DST. When looking at the admin guide in SEI, it suggests I set a Time Zone for the scheduled job. However, as you can see below the option…