• 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 three…

  • 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…

  • 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 in…

  • 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

  • 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 Only Version…

  • 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:-

  • 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 “User…

  • Deleting Sage X3 folder from database

    Dear Fellows,

    As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

  • Sage X3 V12 on Oracle RDS

    Hi All,

    I installed the Oracle RDS database instead of MS SQL Server.

    The database is on diff. server and location and the challenge are – how to config. this in the below screenshots in Sage X3 Console?

    What are the inputs required to provide here…

  • Accessing data from Sage X3 from a shipping program using ODBC

    Hello,

    I have Fedex Ship Manager software and I am  trying to integrate it with our Sage X3 software using ODBC and SQL. I am only able to see sys tables when trying to link. I even set up a new user in SQL manager with full rights. The Fedex software…

  • Call WS

    Hi!

    I'm trying to call an web service using  Visual Basic in a spreadsheet but it returns me an error:

    xsi:type="xsd:int">0</traceRequestSize></technicalInfos></runReturn></wss:runResponse><multiRef id="id0" soapenc:root="0" soapenv:encodingStyle=…

  • PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

    Hello All,

    Please am having issue with PAYMENTH  description Table not flowing to GACCENTRYD description table.

    I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…

  • X3 V12 Installation Issue - Error in the application

    When configuring the solution, the data server shows active, after setting appropriate paths, then clicking the "Application" button near the top of the screen, I'm getting the error below. I've followed the instruction documents and had no issues with…

  • Data Purge Parameters

    Hi,

    We are a Blending & Packaging plant and have v9 Patch 5.

    We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...)

    We've started to purge out some old data like the ATRACE and investigating…