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