Sage X3

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?

I'm trying to create a report and need customer contacts. Does anyone know if there are customer contacts in SEI?

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…

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

When I access SEI Server: We have encountered a server side error. Please contact your Administrator. Unable to load the Login Options

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…

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…

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

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…

I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional…

Is it possible? I can copy a process, but not a view?

Good Morning I have a customer using SEI for Sage x3 (multi-tenant cloud) and still on V8 of SEI. They need to see financial data by week number. Is there a way to add a week number into a process so we can view the data by week instead of just fiscal…

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 would like to know the difference between UDM and normal Finance process,dashboard and reports?

I am trying to create view that shows the number of PO receipts per day. The process owner has requested to see days where no receipts were performed in the data. Since there is no data for those days, it is not represented. I tried pulling in the ZCALENDAR…

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…

Using SEI 8.2.0.38. I can email a worksheet, report etc. when I share it from the Command Center (Sharing>Email). When I schedule the same worksheet, report to email out, I don't receive an email. The Scheduler console shows that it ran and was Successful…

Sage Enterprise Intelligence 8.2.5 for Sage Business Cloud Enterprise Management (formerly Sage X3) has been posted to Sage Knowledgebase article 77942. To access this download, log into https://support.na.sage.com/ . In the search field, enter, 77942…

When adding a new process (nothing fancy, just a test process with one column for ITMREF from the ITMMASTER table) to a new report I get the following error: System.Exception: Error occurred in ResourceDocumentManager.GetResourceDocumentContent…

[SEI v.8] Can I reference a Calculated Column I created in the calculation of another Calculated Column? If so, what is the syntax to refer to a Calculated Column within the SQL Scripts Builder? Usually when referring to to a field within a calculation…

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…