Browse By Tags

  • @X3.TRT/GOBJET1$adx (163) Erro 76 : Erro SQL server (Microsoft) [ODBC Driver 17 for SQL Server[SQL Server] Invalid object name

    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?
  • 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?
  • How to automate excel data send with different parameters and emails addresses from external data source

    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…
  • SEI BP Supplier Invoices Data Model BPSINVLIG/A

    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…
  • SEI Subtotal Average Rounding & Incorrect Value

    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…
  • 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…
  • Activate License

    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) …
  • [SEI] central point not found: We have encountered a server side error. Please contact your Administrator.

    When I access SEI Server: We have encountered a server side error. Please contact your Administrator. Unable to load the Login Options
  • INFO: Announcing the availability of Sage Enterprise Intelligence 2022 R1.2

    Sage are pleased to announce the new version of Sage Enterprise Intelligence 2022 R1.2 This release includes bug fixes: - Creating a view with a name containing an accent (such as é, &#xE8 ;, à, etc.), it would be displayed with special characters instead…
  • Sage Enterprise Intelligence Version 2022 R1.2 and related templates are now available for download from Nectari ( KB 116013)

    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…
  • Sage Enterprise Intelligence Version 2022 R1 and related templates are now available for download from Nectari ( KB 116013)

    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…
  • New process for Sage Enterprise Intelligence downloads (KB 116013)

    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…
  • 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…
  • 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…
  • Can't Reset User's Password in SEI

    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…
  • Sage Enterprise Intelligence w/Sage 100 Providex

    Looking for other users that use Sage 100 Std (providex) with Sage Enterprise Intelligence. I'm working with Tangerine and they are having trouble connecting the data sync to my odbc connection.
  • How to setup SAML2 in SEI

    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.
  • Daylight Savings Time shifted Scheduled Reports in SEI

    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…
  • For Pivots, why is the grouping and data staggered?

    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…
  • Copying a View in SEI

    Is it possible? I can copy a process, but not a view?
  • Create a view using week numbers

    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…
  • Sage Enterprise Intelligence V9.3 has been posted (KB 77942)

    To access this download, log into https://support.na.sage.com/ and in the search field type 77942. Click Search. Note that KB 77942 is continually updated with the most current version of Sage Enterprise Intelligence. For a complete list of available…
  • SEI Feature Request: Security Roles Improvement

    Hi, Currently using SEI version 8.2.7. When a user has permission to: rename change owner change publish for This gives them permission to do so for all views/dashboards. Would like them to only have these permissions for views where they…
  • SEI Feature Request: Scheduler to suppress emails when restrictions result in no data

    Hi, This was originally posted on the SEI (Sage Enterprise Intelligence) forum, was informed that it should be posted here. 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…
  • Formula to calculate last week sales in Sage Enterprise Intelligence

    Hello Team, Can anyone help with formula to calculate last week sales in SEI and also compare last year sales and current year sales. Thanks.