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…
Bonjour,
J'utilise dans X3 une requête SQL qui va notamment chercher des données dans un menu local (3101 : plan d'amortissement). Ce menu local est paramétré avec une largeur max de 25 caractères :
Lorsque je génère la requête, à l'écran, le résultat…
Hola muy buenas!
Estoy teniendo problemas añadiendo una entrada de menú con una consulta del peticionario SQL.
Cuando ejecuto el punto de menú me dice que la consulta no existe, aqui adjunto un par de capturas para que veais.
Que puede estarme fallando…
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…
Saudações a todos! Neste post venho explicar sobre como corrigir o erro de chave(index) inexistente em uma determinada tabela.
Antes de tudo, iremos replicar o erro:
Para solucionarmos o problema, primeiramente devemos ir ao nosso dicionário de…
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…
Olá a todos,
Quando estou na pasta PILOT tentando acessar a função Setup> Users, "GESAUS", o sistema apresenta este erro:
Erro apenas na pasta PILOT.
Eu estou acessando como usuário Admin, isso começou a acontecer depois de validar o menu…
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.
