• 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 to…

  • 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?

  • Critical security hotfixes for U9, V11 and V12.

    A security risk within Sage X3 has been discovered that may impact customers using Sage X3, Sage X3 Warehousing and Sage X3 HR & Payroll. The security risk is related to a platform component and has no impact on the Sage X3 application code or customizations…

  • 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.

    1. for JSON format

    <requestConfig xsi:type="xsd:string">adxwss.optreturn=JSON</requestConfig>

    1. For XML return

    <requestConfig xsi:type="xsd:string">…

  • 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 and…

  • 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 or seek advise…

  • 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 as…

  • 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

    1. The file will be located in  …\Syracuse\syracuse\certs_tools\output
    2. Restart the Syracuse service so that it can pickup the…
  • 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…

  • 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 folder…

  • 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.

  • 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))…