• Procedure in SEI

    Can anyone briefly explain what the procedure is in SEI? It would be much better if an example could be added. Thanks in advance!
  • @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
  • Object reference not set to an instance of an object

    Hello There; I am facing issue when defining Data Source Definition. Error is prompted as attached. Please help.
  • 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…
  • SEI Kit margins are all showing incorrectly at 100%

    Our customer is starting to analyze margin information at product level. It appears that margins for kits are not reporting correctly. Attached screen shot shows example of a sales kit the customer supplies. Because no cost is associated with it, it is…
  • 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…
  • How to upload a file to mark outstanding transactions?

    Hi there I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper. Do you know if there is any way to upload or mark the 750 outstanding…
  • 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…
  • PO Lines Expected Delivery Date < Today

    Working on an advanced filter to get PO lines past due. Tried global variables @@CURRDATE and @@TODAY with no luck. Any ideas?
  • Excel Addin for Macbook

    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…
  • Tax Determination Rules and Alcohol Volume Tax

    Ok X3 Tax experts. This one is for you! There are now several states that are beginning to charge Alcohol Volume Taxes. The Tax determination rule function appears to be the perfect solution for the following: ABV Tax = Volume * Rate. In addition, the…
  • Can you run Year in Simulation for more than one year

    Can you run Year in Simulation for more than one year in X3 and SEI? For example, could you have 2019 and 2020 open but run year end simulation to have your 2021 balances correct for balance sheet accounts? Thank you. Cindy
  • Pulling Calculated Values from One Report or Data Model Into another for further calculations.

    I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…
  • 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…