• 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…
  • "LNGDES_0" of table ATABDIV invalid column name in SQL query

    Hello, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…
  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…
  • 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…
  • Upgrade windows server and SQL server from 2008 to 2016 and keeping sage x3 version 6 intact.

    I am running Sage X3 V6 and SQL 2008, on windows server 2008, want to upgrade to windows 2016, with SQL 2016, but keeping version 6 intact. Will there there be any problem? how much will be the cost and time required to perform, how much downtime? any…
  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks
  • EXECUTE STORE PROCEDURE

    Hi. I did a store procedure to explode BOMs up to the leaf level by saving the list of components in a table. The store is obviously recursive (it calls itself). Throwing it from SSMS works properly by exploding the entire BOMs to leaf levels. Launched…
  • Purchase Invoice billable quantity should be "A" status

    Hello Everyone, I want to create a purchase invoice for the receipts which are having only "A" status. For Q and R status receipts system should not allow us to create an Invoice. Just for your reference, I had done the following setups:- Parameter…
  • 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…
  • PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

    Hello All, Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table. I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
  • 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…
  • Table Validation Error PAYMENTH Error No 76

    This error comes up anytime I try to validate any table. Please has anyone encountered this before?
  • @X3.TRT/TRTLIC$adx(223) File nonexistant [Microsoft][SQL Server Native Client 10.0] [SQL Server] Invalid object name ‘X3.AUDITH’

    Sage X3 Version 6.5 Patch 29 We have done a server migration. Installed Sage X3 v 6.5 on new server. Imported the folders +svg from old server On the new server when we log on to Sage we get the error message below. “@X3.TRT/TRTLIC$adx…
  • Consuming external webservice SOAP

    Hello guys, Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ? I don't find any information here about this subject. Thanks
  • 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…
  • SQL Data Report

    I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …