• Function not defined for the value given

    After increasing length of DES Data Type to 250 and Validating. After I close X3 and re-open I cannot get into any function. I receive these errors: Function not defined for the value given
  • Date syntax in GMAINT or diagnostic utility

    The correct syntax for the selection criteria for a Sage X3 date field is: [DD/MM/YYYY] Classified as follows "DD=Day", "MM=Month" and "YYYY=Year" Example : Criteria using CREDAT in table for records with a CREDAT less than March 12th, 2020. …
  • Error: "Connection to server failed : X3 engine error: <<masked>>\adxodbc : ini_com:SQL Server Error!(2)"

    Cause : There is failure to communicate with MSSQL server. Fix 1. Ensure SQL services are running 2. Ensure the servers can communicate if the system a multi tier. 3. Check firewall settings
  • Error: "Create session error : X3 engine error: <folder path>\FIL\ACLASSE.fde : File Non-existent"

    Cause: There are various possibilities including a corrupt ACLASSE table or an outstanding folder validation Fix. 1. Try to validate the ACLASSE table through Development > Data and Parameters > tables 2. Test if the above fix fails, perform…