I set up a data model based on a view in Sage. Then I created a worksheet view and everything works well including the ability to filter based on columns within the data model. I noticed that when I went to set up a distribution job, I didn't have the…
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…
We have created a report using the trees - which works
Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc
Non organic 12,18,32,etc
How can I drag all the trees into…
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)
…
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 é, è ;, à, etc.), it would be displayed with special characters instead…
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…
I've tried all of google about this error on excel about report designer license required sage Intelligence.
Anyone please help me.
Sage 300 2022 Premium with Connector, designer, viewer and manager license.
Microsoft excel 64 bit 365 office version…
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…