• SAGEX3 WORKFLOW

    I have issue sending request approval to more than one users on sagex3 using office360. the workflow will send mail to the first approval but second approval will not receive any mail to process. Note: client want only dedicated email setup on smtp…
  • SAGEX3 ATTACHMENT DOCUMENT

    Please i need help on sagex3, how can i attach source document to a transaction on sagex3. I observed that sagex3 only allow text and scan image format. How can i attach a pdf format document to a transaction on sage x3.
  • 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
  • Runtime - Adxadmin Hotfix 94.1.14

    Please, We can't find the Runtime - Adxadmin Hotfix 94.1.14 on the Sage FTP site. Where can we find it?
  • BP Customer Situation - Unposted Invoices negative value

    Good day all We have encountered an interesting situation with a client. The client did a fixed asset disposal by way of sale. The BP Customer invoice was created automatically and posted successfully linked to a cash customer. Payments were linked…
  • SIHI Line 30 Legal No Account Found & Rollback Following Error in Transaction

    Hello All, I'm using Sage x3 V5, While posting Invoice, I'm facing an error. Kindly support on below urgently: We are passing only Sales Transactions like Invoices & Credit Note as we stopped using the Finance Module.
  • Product Comparison - X3 vs 300 vs 200

    Hi Sage Community, I am looking for a product comparison between Sage X3, Sage 300 (Accpac) and Sage 200 (Evolution). Where could I find this please?
  • Account Interface Error

    Hi All Can someone please assist me with this error. The error displays when i try to run the stock accounting interface for all sites.
  • Errors after update to v12.0.23, X3

    Hello Everyone, we tried to update X3 to the final version 12.0.23. but just the X3 folder was updated and the other folder was not updated. and now we get errors like this: and most of these source files are not in the TRT folder ??
  • Error : "Next Long" in web services

    Cause : The XML or JSON file is too big. Fix: Remove all defaulted and unnecessary fields from the XML/JSON stream and test.
  • How to have specify xml/json return format on web services call

    adxwss.optreturn option allows for specification of return format. for JSON format <requestConfig xsi:type="xsd:string"> adxwss.optreturn=JSON </requestConfig> For XML return <requestConfig xsi:type="xsd:string"> adxwss.optreturn=XML…
  • Function to create web services pools

    1. Login into the system 2. Navigate to Administration > Administration > Web Services > Classic soap pools configuration 3. Configure your web pools
  • Web service call timeout or "No data to display" message

    Increase the timeout settings by a factor . 1. Navigate to Administration > Administration > Hosts 2. Click edit on you server 3. Increase the Return Request Timeout 4. Test The timeout is in seconds, this value should be increased cautiously…
  • How to terminate a process in MSSQL process

    Sometimes you might need to terminate a process in sql server. 1. Open Sql server management studio 2. Open a new query 3. execute command below, processID is the sql process number kill processID NB. Ensure you terminate a correct process…
  • Error 76 : SQL Server Error [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'AFONCTION'

    Fix. Review sql permissions on roles such as X3_ADX_SYS, compare with a working system. Consult a database administrator for assistance.
  • Error: "[Microsoft][ODBC SQL Server Driver]Communication link failure : SQL Server Error"

    Cause : Disk space could be running out. Fix. Review disk space, investigate SQL server health status.
  • Error : "Too many buttons"

    Cause : The system has a limit on the number of buttons (59) that can be entered on a window. Fix. Review the buttons and combine some if possible. Other options include using icons on the screens.
  • "Error = 3" in migration log file when executing UUMGPRETRC07 migration script

    Cause : A duplicate key has been picked during the migration process Fix. Execute sql script to identify the duplicate keys and fix accordingly.
  • Error: "Create session error: Wrong user or password"

    Cause : Syracuse user is not linked to folder users. Fix 1. Navigate Administration > Users > Users 2. Locate the username 3. Click edit and ensure there is a linked user on the respective folder NB. If the folder has a username that exact…
  • Error: "X3 engine error: Unable to find Server.pem"

    Cause : Missing certificate from ..runtime\keys folder Fix Copy the <ServerNam>.pem file into the ..RUNTIME\keys directory The file will be located in …\Syracuse\syracuse\certs_tools\output Restart the Syracuse service so that it can pickup…
  • 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:"Cannot connect to server xx.server.local:1807; Error connect ETIMEDOUT - Error code : [500]"

    Cause : Services failing to communicate. Fix . 1. Test by using telnet utility 2. If telnet fails, switch off firewall 3. Test NB. All communication ports need to be configured as exceptions on the firewall.
  • 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…
  • Table Access Error ITMMVT "product" "site"

    Cause : Records could be missing in ITMMVT table. Fix 1. Navigate to Stock > Utilities > Stock Resynchronisation & Control 2. Execute for the Product – Site record 3.Test