Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
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,…
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…
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…
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 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
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…
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…
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…
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 into the…
Sage X3
Version 6.5
Patch 29
We have done a server migration.
Installed Sage X3 v 6.5 on new server.
Imported the folders +svg from old server
On the new server when we log on to Sage we get the error message below.
“@X3.TRT/TRTLIC$adx…
Hello guys,
Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ?
I don't find any information here about this subject.
Thanks
Hello all,
When I am in the PILOT folder trying to access Setup> Users, "GESAUS" function, the system presents this error:
Error only on PILOT folder.
I'm using Admin user, this started happening after validating the menu in the function…
I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …