• Voiding/cancelling a Check in a closed period


    I have a cheque that needs to be voided/accounting cancellation.  The problem is that it is in a closed period, and the entry is finalized.

    The other problem is that this payment relates to a prepayment and needs to go back to the PO so that it…

  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection.  Where can I find the field definitions used in…

  • Question about URL to Sage X3 health check page


    Does Sage X3 have a URL to a health check page?

    Got a request for HA reason and want to know the heartbeat of the Sage X3 at all times to confirm it is just a user connectivity issue over an issue of the service backend.

    I am currently recommending…

  • [X3 console; v12 onwards] Question on SQL Server role for Sage X3 v12 installation.


    This is a question for Sage X3 v12 onwards X3 console. Older console versions I know were inevitable to use `sa` account only.

    Link reference: online-help.sageerpx3.com/.../prerequisites_windows-sql-server.html

    Is `sysadmin` role level required for…

  • SYRACUSE WS Unauthorized error


    I'm trying to use X3 V12 webservices from PHP application, below the code I used to save a new order : 

    $soapclient=new SoapClient($wsdl, $options);
        $callContext = array('codeLang'=>$code_lang, 'codeUser'=>$username, 'password'=>$password, 'poolAlias…
  • About ACTLSPE


    I used this: https://www.sagecity.com/us/sage_x3/b/sageerp_x3_product_support_blog/posts/how-to-determine-if-there-are-any-customization-in-my-installation

    Should I ignore the fatal errors here? The field was added for a very specific need with the…

  • Question: Sage X3 Console password length


    I got requested by a client to enforce 30+ characters password.

    As far as I know, Sage X3 console is crippled at 20 characters only (from Print Server, not sure if changed or not) with the rest truncated or ignored outright.

    How do I resolve this…

  • Does Sage X3 support cold storage?

    As per title, I have received an order to prepare a cold storage purely for long-term archival purpose.

    I am interested in how everyone deals with cold storage order.

    As far as I know, Sage X3 have Archive/Purge folder (which I labbed here: https://www…

  • On-demand scaling of Sage X3 web instance

    Does Sage X3 support scaling of Sage X3 component instances, on demand (which means, things can be automagically discovered and continue as if nothing happened)?

    This was a question posted to me from an AWS provider since the AWS provider is very interested…

  • Error 31: No more memory available, when conversion Sales Order to Delivery.


    As per title.

    Server Type: Single-tier, X3 v12p32 for demo use

    vCPU: 4, Intel Xeon Silver tier

    Memory provided: 16 GB, 8 GB locked to SQL Server.

    SEED folder details (using defaults).

    User list: Assume 10 at peak.

    When doing:

    sales Quote > Pro…

  • Hotfixes that indicate that to integrate them you need to have at least Release 2022 R2 (12.0.30) installed. How do I know from which standard version patch they are included?

    Good afternoon,

    I would be grateful if someone could clarify how we can know if the hotfixes published in the last months are included from which version?

    I give as an example client now updated to:

    And in the Portar Partner there are hotfix releases…

  • Error when unlink physical assets attached with an asset


    I got below issue when unlinking physical assets attached with an asset: "Asset quantity (1) not consistent with the number of physical asset (0)"

    This issue does not allow me to delete a fixed asset:

    Does anybody here know how to…

  • Non-Conformance - help needed to add custom fields

    Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields.  I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…

  • Version Management, MRP and Safety Stock


    can anybody clarify for me how MRP handles the safety stock level on the product-site record where the product is version managed?

    if we have multiple active versions of the product - lets say 3 and we have a safety stock level set at 10. does this…

  • Customized Patch, Patch Integration. SQL Server field's SQL query losing characters after changing folder name externally.


    I am unfamiliar with development quirks so pardon me if I did anything wrong here.

    I created a customized patch from patch creation from an activity code. It is created as a Specific patch.

    There were hardcoded the folder's name (SILP) in one of…

  • [X3 v12p30] Error when implementing syracuse self-signed certificates after a successful certgen and certificates replacement.

    Sage X3 v12p30. All component match requirement.

    I am using certgen in syracuse cert-tools.

    When I am done replacing the certificates, send certificate to runtime, and apply passphrase to the certificate in syracuse certificate folder, I got these errors…

  • SAML2 for Google


    While setting up custom SAML2 for Sage X3 for Google Workspace, I found this issue:

    Checking the docs:

    Checking the custom SAML2 is ok on my account:

    I copied Entity ID directly from Google:

    I have created a user linked directly to my accoun…

  • Locale question in an International company context


    Would like some experienced opinions on using Sage X3 on international scale.

    Assume I have a theoretical international company here which have branches in:

    Nation - User example

    UK (HQ) - Jack

    USA - Bob

    Singapore - Stuart

    Japan - Taku 

    China - L…

  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver.  I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images.
    I know that it is stored in the CBLOB table. In the screen…

  • Sage X3 is losing SSL certificate when the App server restart.

    We are hosting Sage X3 on Amazon server and very time when the sever restart, it's losing the SSL certificate. The external link will not be working, every time this happens, I have to reload the SSL certificate in SageX3 under Administrator. Then after…

  • user does not have any role

    does anyone have an idea what's going on, this is happen with some of users rest of users working normally.  

  • Unscheduled server restart error while VALDICO process after increasing the length of DES and AX3 data type.

    Hello All,

    I have increased the DES and AX3 data type length from Standard 30 Characters to 60 characters, but when I am performing dictionary validation, I am getting an error of Unscheduled Server Restart.

    I tried the same for other data types but didn…

  • How to customize the Sage X3 Mobile Automation for Distribution with data interfacing with Automated Warehouse via external SQL DB tables?

    To whom it may concern,

    We would like to customize Sage X3 Mobile Automation for Distribution for interfacing with automated warehouses and linking with LPN.

    Can 2022R3 or 2023R1 support GraphQL or other API to allow this kind of add-on development?

  • Sage x3 how to add a network printer


    I'm looking for the solution how to send a report directly to a network printer but i dont have an idea how to do that.

    What i found so far, when im connected remotely to a server, where sage x3 configuration console is installed i can add…

  • Inventory Replenishment

    Has anyone out there started using Sage X3 inventory replenishment functions from scratch. We are not using this function in any way at the current time, but we would like to start investigating it. Does anyone have any advice or overall tips to point…