Sage X3

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?

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…

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…

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

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…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

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…

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…