Sage X3

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…

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

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…

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…

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?

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…

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…

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…

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…

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…

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…

hi is it possible to delete one item from a stock inter site Transfer thanks in advance

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…

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

Why cant sage handle LIKE in the views? Has anybody found a way around this?

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…

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

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…

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

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…

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…

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…

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

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…