• 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…
  • Where is Sales Delivery line LOC field stored in database?

    From the screen I can see the value for LOC, but not in database, the value is empty.
  • 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…
  • The Database is not Started

    Can someone please assist me with the following. Production Management Console. So this issue is also the cause of our current situation on a Clients UAT environment. This issue occurs either when I try to click on the Customisations and…
  • 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?
  • SQL disaster recovery support

    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…
  • Entry Batch is Full

    FormerMember
    FormerMember
    We came across and incident where we were printing out checks and then received an error stating that the Entry Batch is full. She went in and posted the checks that she had then tried closing out and re-entering the function but continues to receive…
  • Syracuse Failing to install

    Prepare folders ... Grant rights on bin directory ... Successfully processed 12742 files; Failed processing 0 files Create rel directory ... 11175 File(s) copied Create temp directory ... 11175 File(s) copied 1 dir(s) moved. Grant rights on temp directory…
  • Data Loading Into Database Error

    Dear Experts, This is my first installation of Sage ERP X3. I followed installation document and installed everything accordingly. But in console application server Sage ERP X3 is not getting activated. Status is showing IDLE. It is running up to database…
  • Sage X3 Installation Rationalization.

    Hi, I am looking from advices on your X3 experience. I have inherited from an IT system mainly based on Sage X3. The company is multi-sites / countries but the X3 deployment is not transversal. I was expecting one central X3 installation configured…