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