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.
Hello,
After updating to p34, when trying to create a client (GESBPC) the following error appears:
Checking the database, the table in question does not exist:
What do we need to do to adjust this information, is it on the X3 or SEI?
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?
We are trying to create sales reports using a Fiscal Year. I can use the between-date feature to give me the actual dates (Dec - Nov). However, the periods follow the calendar year and not our fiscal year. How do I make it utilize fiscal year instead…
We have customer open sales order report in SEI. It has customer number as a parameter. We want to run this report automatically and send it in email to different customers, using input from another csv file.
For example, I have CSV file
Customer…
Hello,
The usual data model in SEI PINVOICE (PIH) does not pick up any invoices created via AP/AR module in Sage and so I'm trying to create a new data model for these. I can get data from the lines using BPSINVLIG and *A tables, but does anyone know…
I made a copy of the X3 Purchase Orders data model. When I try to create a new view off of that data model (only the copy, not the original), the folders inside of Dimensions and Data Measures are showing in French. Everything in set up is set to english…
Hello dears,
I have installed sage SEI version 2022 with sage 300 ERP and sage CRM and when its open on the website its shown error like this.
Anyone knows what's the issue and how to solve it?
SEI.
I have successfully locked myself out of SEI because I logged in from Sage X3's SEI login from Sage X3 Home Pages using SEI External Link.
How do I kick currently logged-in SEI login so I can login?
Error message from SEI website:
The number…
Hi,
I'm currently looking into some strange behavior in how SEI is subtotaling values. Specifically I have a report where I want to see the Average value of our costs.
Rounding to the Nearest Dollar
For illustrative purposes, I'm going to use our…
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…
Hi,
When i try to move my license from server A to server B, the licence first succesfully released from server A.
I got this error message in SEI after entering the licence key for activiation:
( Value cannot be null. Parameter name: source)
…
Hi Guys,
We have added a new environment in SEI and need to re-run the template scripts and would like to confirm what the parameters should be for the following screen:
Normally when you import templates, you get to map the X3 and BI endpoints…
Hi everyone,
I'm trying to have a SEI view that shows me a week's window of information in a way that the date is variable and not fixed using an specific date in the filter formula. I've tried to use the @@curdate variable is seems is not compatible…
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.
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.