Browse By Tags

  • Finding Lot numbers on Unconfirmed Deliveries

    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…
  • Pasar consulta SQL en punto de menú

    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…
  • 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…
  • Error: "[Microsoft][ODBC SQL Server Driver]Communication link failure : SQL Server Error"

    Cause : Disk space could be running out. Fix. Review disk space, investigate SQL server health status.
  • 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…
  • 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 into the…
  • Error on Setup > User - Pilot FOLDER

    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…