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…
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 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…
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…
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…
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…
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…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
I am getting the following error on the CLOPER REPORT:
I am doing the following on SQL
select distinCt IPTDAT_0, VCRNUMORI_0, * FROM PROD.STOJOU where AGGIFAFLG_0 = 1 AND IPTDAT_0 <= '01/31/2018'
I get 25 results. What do I need to do from this…
I have the following Graphical query, the two tables are BPCUST AND SINVOICE.
How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018.
When I search for this its outputting all the invoices and duplicating…
Hello Guys,
I am just a newbie here in this forum and hoping to get along with you all.
Moreover, I am about to support a newly implemented ERP system in-house through a post implementation phase and am just wondering what are the proper steps and…
Hello Sagers,
I was trying to connect Sage x3 to a virtual database ( always on ) and this virtual SQL database is pointing to two other Physical SQL database instances this to have online hot swappable database recovery.
But the console is not seeing…
It would be useful to be able to change the SQL schema password from the console at the time of install. This would help to minimise the security risk from having the same generic password fro all x3 folders and databases.