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

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


  • 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

  • Inquiry Screen Custom Fields Missing on Export

    I added a new column to an inquiry screen. Since the field is from a table not included in the inquiry, I used SPE code to populate the field in the inquiry.  This works fine, but when I export it via Excel, that field isn't populated.  Does anybody…

  • Reversal Journal Entry - Line Description to Capture Original Journal Line Description

    The client would like to request for a change in the logic of the Line Description of the reversals

    In Journal entry function (GESGAS), while clicking reversal from the right side button, the system will create reversal journal. In that Journal the client…

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

  • Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?

  • Product image on other screens

    What I would like to accomplish is that ability to tunnel quickly to what a product looks like without sending our users to the Product screen. The screen I would like to implement changes is the Sales Order entry screen. Initially I was thinking that…

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

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

  • SAVE button ACTION


    I need to know the $ACTION name associated to SAVE button event.

    Moreover, into my program I have an action called FIN_PICK: is this action a standard action?

    Or FIN_PICK is a custom action? In this last case, how can I find the object or event…

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

  • How to CHGSTL for the row not field?

    The default background color of a non-highlighted row in a sales order, purchase etc is BACKGREY. When a user is adding a new line to the order we want all other lines to have something like yellow or red...something other than grey. How can I change…

  • Affzo not working without mask abbreviation?


    When I use the following line of code

    Affzo [M]ITMDES2(NLIG)

    I get the following exception

    According to the documentation at https://online-help.sageerpx3.com/erp/12/staticpost/affzo/ this should be working

    If I check the value of the field on that…

  • 4GL Left list picking - number of selected items

    Hi folks

    I'm looking for a possibility to get information about how many items are selected in a picking left list on action $PICKE and $DEPICK. My goal is to allow the user to only select one item and show an exception message if he tries to select another…

  • Duplicate Line in Sales Order

    I was wondering if anyone knows how to use 4GL to copy a line and duplicate it? I can certainly specify every single field in the SOH4 mask for the current line and use it to populate a new line, but I thought perhaps there might be a simpler way. Just…

  • RTF Pasting adds many carriage returns

    Just upgraded to V12 P27 and when we copy to clipboard from an outlook email in rich text format, when we paste it into a comment box in any screen (customer, supplier, sales or purchase order etc), it is adding _many_ carriage returns after each sentence…

  • Workflow Rules message by Criteria

    In the message text area in workflow rules, I was wondering if we can display text in a email dynamically based on a criteria. 

    This is my attempt, but doesnt work:

    |[F:PSD1]ITMDES<> '',chr$(13)+chr$(10)+"Order Description :[F:PSD1]ITMDES|…

  • BSIIMP representation on menu

    Would anyone know how I can remove the below from users menu?  I cannot seem to locate where this would be. 



  • show avaibility stock on sale quote screen

    Hello everybody,

    anybody can help me how to proceed if a want to add a colomn in SQH0 tht show stock avaibility of items!!!!

  • Screen Field Size

    Good day Ladies and Gents 

    Can anyone let me know if there's a way to make the fields appear larger on a screen?  It seems to dynamically change when you change the size of your screen, but ideally there are some I could make larger by default and…

  • Get the user Timezoneinfo code


    In Sage X3 V12, there is this fonction to transform a UTC datetime structure to local date time


    But how to get the current TZICOD ??

    Is there any accessible parameter, like those in the GACTX variable?