• Error during importing of large Sales Invoice data (@X3.TRT/ASYRSUB$adx (602) Error 50)

    Hi All, I am experiencing an intermittent error when importing large Sales Invoice files. During import the following error will be produced: @X3.TRT/ASYRSUB$adx (602) Error 50 : Function not defined for the value given ERR Thereafter, all…
  • Hyperlink to X3 Function from MS Office

    Hi I am trying to understand why I cannot access an X3 function and (and record) from within a MS Office application. The hyperlink works when typed directly on the browser. It works from within my reporting application (SSRS). But it does not…
  • South Africa: Section 12C Wear & Tear Allowance as 2nd plan for depreciation context

    South African Revenue Services (SARS) grants an accelerated depreciation schedule for: Machinery & plant (new or used) Used directly in manufacturing process Brought into use for the first time by the axpayer For purposes of his trade Write…
  • 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
  • VACBPR : Mandatory Field in Purchase request

    Cause : The field is supposed to default from the supplier master data record. Fix 1. Navigate to supplier 2. Ensure there is a Tax rule in the financial tab. 3. Test after entering the tax rule on the supplier.
  • Run-time error '482': Printer error

    Cause : System cannot find a printer Resolution Assign a functioning printer as default in the system.
  • Important Notice | Sage X3 and Sage X3 People Support Process

    Our support process has changed effective from 1 October 2020 and we are introducing you to our new Sage X3 and Sage X3 People Online Case form to log your support queries. The Online Case Form will allow us to better assist you by getting all the necessary…
  • IMPORTANT SECURITY UPDATE - PLEASE READ

    Dear Customers and Partners, Firstly, we would like to thank you for your continued business through this difficult time for companies around the world. During recent proactive testing we uncovered a potential critical security vulnerability in…
  • Add warning message when license is expiring

    This is a how to on setting up email notification when license is expiring. 1. Set up a notification server (Administration>Administration>Notification server) 2. Setup a notification event (Administration>Collaboration>Notification events)) Nb…