• Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • 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…
  • ALERT: SQL Server PowerShell module

    Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…
  • "LNGDES_0" of table ATABDIV invalid column name in SQL query

    Hello, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…
  • Relationship between Sales Kit and component products in SINVOICED table

    I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components. I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…
  • Multiple Folders pointing to single SQL database

    Hi I have a customer with a v12 installation with multiple folders (SEED, PILOT, X3). Every folder is somehow pointed to the PILOT data. I have checked SQL, and the normal SEED data is present,. If I add record in any folder, it is reflected in all…
  • Graphical Query Tool executed query

    I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…
  • 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…
  • Is it possible to use the SQL Import / Export Wizard to copy from PRODUCTION to PILOT?

    I need to update the SO and PO tables on a daily basis to test an automation customization I am working on. Has anyone used the Microsoft SQL Import / Export Wizard to create an SSIS package to copy data from PRODUCTION to PILOT? Does that work? If so…
  • Using SQL Function in SQL Requester

    Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…
  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…
  • BPSUPPLIER SCREEN (X3) - CONTACT default field KCNTFLG not in MSSQL database tables - CONTACT or CONTRACTCRM

    October 25th, 2020 Hello Teams, Need your help. :) BPSUPPLIER-->CONTACT-->CONTACTCRM Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables. Goal - I am looking for where the CNTFLG field is stored…
  • Upgrade windows server and SQL server from 2008 to 2016 and keeping sage x3 version 6 intact.

    I am running Sage X3 V6 and SQL 2008, on windows server 2008, want to upgrade to windows 2016, with SQL 2016, but keeping version 6 intact. Will there there be any problem? how much will be the cost and time required to perform, how much downtime? any…
  • stock inter site transfert

    hi is it possible to delete one item from a stock inter site Transfer thanks in advance
  • Sage X3 on Multicore VM

    Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report…
  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks
  • EXECUTE STORE PROCEDURE

    Hi. I did a store procedure to explode BOMs up to the leaf level by saving the list of components in a table. The store is obviously recursive (it calls itself). Throwing it from SSMS works properly by exploding the entire BOMs to leaf levels. Launched…
  • Views wont accept like statement

    Why cant sage handle LIKE in the views? Has anybody found a way around this?
  • allocating inventory based on version

    we need to allocate specific version of products to order. 2 Active versions Ex SKU1 qty 1 version A in stock SKU2 qty 1 Version B in stock If I placed a customer order for SKU1 Version A for qty 2 , in any case I would like Sage to allocate…
  • Foreign keys

    Hello, I would like to draw links between tables (automatically). But I didn't find any foreign key in INFORMATION_SCHEMA.TABLE_CONSTRAINTS. I checked other tables without success. Could you please help me? Best regards, Nicolas
  • SQL cluster, availability group setup for x3 to connect to listener

    We have setup sql 2016 on v11 p15 with the high availability option which in the end uses a "listener" which is a virtual server with static ip to connect to. if the primary node goes down the secondary becomes primary. So the current std setup has X3…
  • Purchase Invoice billable quantity should be "A" status

    Hello Everyone, I want to create a purchase invoice for the receipts which are having only "A" status. For Q and R status receipts system should not allow us to create an Invoice. Just for your reference, I had done the following setups:- Parameter…
  • Sage X3 Application Server Configuration Error (Complex Password Policy Domain)

    Sage X3 SQL User creation error We are having an issue with Sage X3 V12 PU15 installation where the client has complex password policy on their windows domain. The challenge we are having is that SQL is inheriting these policies and we are getting…