• @X3.TRT/GACTION$adx (1342) Erreur 39

    hello every one I get this error when I try to validate delivery is there a way to fix it?
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Report parameters : How to filter the value of the selection ?

    Hi, We use a report to create a label for quality control, printing the report some fields are automatically filled to save time like QC Number / Product Code as unique in the Quality control. Is it possible when several data are possible to select…
  • Pricing Software Add Ons

    Is there a third party that integrates with Sage X3 for different pricing models? For example, we would like the pricing to be based on the shipping address. However, I recently found out through a phone call with Sage, that this is not a standard feature…
  • Signature Management Workflow for a Sales Order created by Import

    Is it possible to have a signature workflow created for a sales order that is created through the import/ export function?
  • Change file name when printing list

    Hello, Is it possible to change the name of the file when printing using output type preview? I tried with AIMP3 entry point, with GPOINT PARAM but nothing works. JOBID didn't update the name ExportFile parameter neither thanks for you…
  • Configuration Options on View

    Hi Everyone, We would like to create a view with schemabinding option. Anybody Knows if it is possible to do with the .cfg file? Create View xxxxxx with schemabinding As SELECT .... Release: 2022R2 Thanks!
  • DOSINTEG (Data Integrate): (Application server time) Who is sending this error message?) (11001)

    Hi, Sage X3 version: X3 v12 Patch 33, hotfixed with Syracuse latest version. Was doing a folder data integration through batch, got canceled. Checking the logs: 06-14-23 13:38:19 (Application server time) Query terminated with error (Who is…
  • For signature workflow, how to enforce public name address only rather than based on user's web browser address used to enter Sage X3 for first signature circuit?

    Hi, Sage X3 version: v12 Patch 33. Question: For signature workflow , how to enforce public name address only rather than based on user's web browser address used to enter Sage X3 for first signature circuit ? Second approval onwards I remember…
  • Multi-level BOM report with costs

    I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…
  • Voiding/cancelling a Check in a closed period

    Hello, 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…
  • 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…
  • Question about URL to Sage X3 health check page

    Hi, 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.

    Hi, 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…
  • SYRACUSE WS Unauthorized error

    Hi 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, …
  • About ACTLSPE

    Hi, 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…
  • Question: Sage X3 Console password length

    Hi, 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…
  • 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…
  • 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.

    Hi, 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: …
  • 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

    Hello, 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 resolve…
  • 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

    Hi 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…
  • Customized Patch, Patch Integration. SQL Server field's SQL query losing characters after changing folder name externally.

    Hi, 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…