• 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…
  • Calculating "velocity" of stock in a site.

    Hello, We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…
  • 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…
  • Data lost

    Hi, While i'm creating a record due to some issue i lost the data in table maintenance ,can any one help me out to get lost data?