• @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?
  • 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…
  • 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…
  • 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…
  • 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?
  • SEI Subqueries

    How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…
  • What does ZTABCHANGE do and should stored procedure ZREFCNVRATES run on a job?

    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…
  • SEI - Error creating join from X3SalesX.Salesrep to SALESREP.REPNUM_0

    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…