• Can you execute a stored procedure in the Sage X3 SQL Query Tool?

    I am trying to execute a SQL stored procedure using the SQL query tool in X3.  I am not getting a validation error but nothing returns when I run it.  I do get results when executing the stored procedure in SSMS.

  • Issue when cloning a crystal report to different folder.

    Currently, we are trying to copy/clone an existing report from a current folder to a new folder. Everything works well except for the SQL Server Stored Procedure that is used to query the data. Inside this stored procedure, we must declare a schema…
  • Sort piciking ticket lines by location in new ADC

    In old VXABP function, there is an entry point allow you sort picking ticket by location first. Is there any thing similar that we can sort picking ticket line by location in new ADC function?

    SORT_PREP: Used to sort the table containing the lines to…

  • Adding custom header and footer lines to an exported file generated using an export template


    In the past, I remember adding custom header lines to an export file when using export templates via specific script processing. I believe it was done using wrseq once the file was opened in the background by Sage to write to the export file. I no…

  • Issue with ALIMSKSOH entry point in TRTVENISOC

    I am trying to populate a field on an intersite sales order when created automatically from an intersite purchase order.

    I have identified the ALIMSKSOH entry point in TRTVENISOC which should allow me to do this. Unfortunately the field that I wish to populate…

  • new field to have multiple selections

    We are at V11- Is there a way where we can create a new field that uses the local menu but can allow multiple selections from the local menu?   We have a list of 14 items that we need on the product but instead of creating 14 different fields with check…

  • PO report displaying customer details

    Is there a standard Sage report that would display customer details (name/ quantity/ that was shipped from a given PO?  I need to create such report and I'm just looking for a simple way to go about.  Basically all the customer details for what PO's…

  • Trolley Build Function Sage

    I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…

  • Modify Background Image - New Syracuse

    Good morning,

    Does anyone know if the background image can be modified when entering Sage X3 with the latest version of Syracuse?

    Before this update we could do it by following these steps:


  • Invoice Inquiry: Pull Source Document vs Order No

    Is there a way to have the Invoice field pull from the Source Document vs the Sage-assigned Order No?

    By the time I know the Order No, I'm already sitting on the invoice I'm looking for.

  • Price Search function not able to search two products ?

    Dear Sage Community,

    After searching one price for a combination SKU/Customer (click on Apply and it works), I was trying to search a second price for another SKU for the same customer (SKU2/Customer).

    But the APPLY button does nothing for the second search…

  • SageX3 - Selection List

    Hi, in a custom selection script like this:

    GSELFAC = 1 : # campo che deve ritornare

    Filter [F:YPROD]
    CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'"

    NBCOL = 0

  • Restrict\Prevent Users from selecting 'Default' page layout

    Hi Guys,

    X3 - V12 2022 R2

    Currently the page authoring is quite powerful in that it allows a power user to hide/enable field on screens to suit their process and make it easier for users generally. Another useful technique is to hid sensitive information…



    We are planning on upgrading our system from V11 to V12 P29. One thing I noticed is that sage is not able to detect a new line when reading the trace file. When I read the trace file, sage thinks that everything is in 1 line when it is not. Is anybody…

  • GESECS - Version Management Import Template

    Hi everyone,

    I have a customer that is planning to go live with X3 Version 12. They make tech modules and have complex BOMs which require version management (Major Versions Only). They have many historical BOMs that they need to have in the system and…

  • Block invoice posting if Custom field is not populated

    Hello everyone,

    I have a few custom fields on the SIH0 screen.  If these fields are not set by the user I would like to add a message box (Yes / No) when they post the invoice.  Basically to inform the user that they are empty and if they continue to post…

  • Product Description disappeared

    In Sage X3, PU9, Common data Module>Products>Products(GESITM)

    whenever I create a new product or modify the existing product, the data in description 2 and description 3 disappeared. ironically, the previous data in the same field for certain products…

  • Default value in UDF when Invoicing a delivery

    Hello everyone,

    I have a custom field on the SINVOICEV table.  I've added this field to the SIH0 screen and put a default to "2" (it is a yes/no).  If I create an invoice directly from the SIH0 screen the default works fine.  When I generate…

  • I want to invoke New button

    I want to invoke the "+" (new) button programmatically so I can star a new page when I call a window through code.

    Can somebody help me?

  • Is there any instruction with 4GL to change column width of a grid table

    I need to be able to reduce the width of the columns of a grid, through 4gl programming

    Thanks !!

  • Sales Invoice option missing from menu.

    Today for some unknown reason the Invoices module is not displaying on anyone's menu today.  There was no issue yesterday but would anyone know how to correct?  

  • Transfer custom fields from SalesHeader / Detail to Invoice

    Hi Everyone,

    I have 3 custom fields on the sales header (SORDER) and sales lines (SORDERP).  I also have the same fields on the invoice tables.  When the order is invoiced I would like to transfer the values of these fields from the order to the corresponding…

  • Set Column Titles Dynamically

    Is there a way to dynamically set column titles for a grid on a screen?  I can do this: 

    But I want to make it more dynamic, like this, but X3 doesn't like it.

  • Update Transaction

    Good afternoon

    I am trying to move data from one field to another.  Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field.  I believe I…

  • How do I open a non-object window like IPREP (Preparation Plans) via code with full functionality

    I've tried a couple of different ways of opening the IPREP window (Preparation Plan) from another screen - via code using SAISIE_CHAR subprog, and also via a custom Action. Both launch the window, but it doesn't behave the same as when you open it…