Sage X3

Hello, After verification, I found in a worksheet of Data Model and View, it lacks the data of one day from Sage X3. The specific is: In a purchasing worksheet in SEI, it only displays the data of February 1, 5, 13 and 27 from Sage X3. However,…

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've set up a view from a data model and it comes out fine within the view. When I try to export the view as csv/xlsx, any special characters such as / or & are converted to their hex values. Is there any way I can export it correctly with SEI converting…

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: 2021 R1.1, License server. Reading: https://onlinehelp.sageenterpriseintelligence.com/Latest/en/Installation/packages/bi-license.htm and: https://support1.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=77158&sliceId=1&isLoadPublishedVer…

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 Guys, We have added a new environment in SEI and need to re-run the template scripts and would like to confirm what the parameters should be for the following screen: Normally when you import templates, you get to map the X3 and BI endpoints…

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, With Sage X3 v11 & SEI, I'm trying to join the SINVOICED table with STOJOU using SOHNUM_0 and VCRNUMORI_0 to get the product lot number for each invoice. The only issue is that 1 sales order can have multiple stock journal entries but only 1 invoice…

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

Hello, It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward. When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…

In prior versions of SEI for X3, I could create a new process using the PINVOICE table and BPSINVLIG and BPSINVLIGA tables to see the details of BP supplier invoices. Version 9 of SEI does not include the BPSINVLIG and BPSINVLIGA tables. Any ideas on…

Hello All, We have implemented SEI UDM(Universal Data Model) in our company, we notice the below measures are not showing are data in the SEI and SEI Cube table in the database. 1. Ending Balance 2. Ending Balance LY SEI Version: Version…

Hello, I run SVG all nigths at 21.00. When the proccess DOSSVG arrive to AUDITL table show this message: \AUDITL.dat can`t delete. And the proccess SVG is locked. Any idea or suggestion? Thanks!!

Is it advisable NOT to use certain special characters (e.g. @,#,$,%, etc...) when creating setting up product IDs and their descriptions ? Especially keeping the import/ export templates in mind.

Hi, One of our client is planning to setup a strong failover system for Sage EM, and we are planning to set up SQL clustering to achieve it. But I am not sure how Sage EM is configured to consider the SQL clustering. I would appreciate to have a guidelines…

Does anyone know the best practice for SEI such as maintenance plans? Our SQL server database transaction log file it is huge. 487321216 KB. I also noticed that the initial database file for the log is 475900 MB. That answers why the file size will reset…

Hi All, How can i clear a MONGODB DATABASE, because some collection like fs.chunks are very bulky. Thanks

Hi All, We are planning to upgrade from v7 PU8 to V11.Does anyone have any helpful hints or tips about migration of mongoDB ?

I'm building a report in Excel w/ SEI add-in where product lines are the columns, and days of the month (dates) are the rows to report on daily sales. Using the Invoices process as the basis for the data. When using the formula wizard, I get the above…

Hello, Is there any way to do a backup of desinged process in Sei Enterprise Intelligence? Thanks

Recently I ran into an issue where the our newly created fiscal year was not showing up in the GL Transaction Detail with Year-End Simulation. After some digging it was determined that the GL Transaction Detail with Year-End Simulation process had the…

Hello, Just started evaluating the product and when clicked on Design Process - Sales Analysis (cube), get the following error. SEI - Error creating join from X3SalesX.Salesrep to SALESREP.REPNUM_0 Does this has anything to do with SEI license…