• SageX3 - Left List Personalization

    Hi, how can I add custom  view fileds into standard (browser) object Left List ?

    It's easy to add other tables but , what about views ?

    Example:this is a standard object 

    I've added my custom view into Viste tab:

    But in Selezione tab (Selection…

  • 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
    NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL…

  • RDSEQ NOT READING LINE CORRECTLY

    Hi, 

    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…

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

  • Delete/insert lines with SOAP web service

    Hi,

    I don't understand how to set up the parameters to insert and delete lines via web service; actually, I can't find much on those parameters in general (their definition, when should I use which, etc). A simple example would do the job as well, I can…

  • Generic Object Read

    I need to create a generic function to read an object in X3.  I'm thinking some of the standard object functionality could be used, or maybe even a dynamic query, but I'm not completely sure how to approach it.

    For example, I want to pass a table…

  • Affzo not working without mask abbreviation?

    Hi

    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…

  • Any Easy way to exclude weekend from date calculation in 4GL?

    Is there any easy way to exclude the weekend from my date calculations in X3?

    For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…

  • Web service returning "Process[WS_NAME] - No return code (status[6]) "

    I'm getting the following message on some web services responses. Just in some times.

    "Process[ZWS_NAME] - No return code (status[6]) "

    The web services its a Subprogram web service.

    Has anyone known what is it? And how to fix it?

  • Is there a documentation for useful standard x3 functions?

    Hello Slight smile

    As a Sage X3 developer, I have found that there are many useful standard X3 methods.

    One example is closing a purchase order with 4GL code via script.
    https://www.greytrix.com/blogs/sagex3/2020/12/29/how-to-close-po-programmatically-using-4gl-script…

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All,

    We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API…

  • Subprogram to Create Delivery and Invoice

    I want to build a few subprograms to be executed through web services. Basically, from a given picklist in GESPRH2, I want to click the buttons for 'Deliverable' and then 'Delivery' to create the delivery, and then in GESSDH I want to click the 'Invoice…

  • Error adding Custom Description field to BOMs and Work Order Screens

    BOMs

    I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - 

    I've added a "Before Field" Action to the ITMREF field and added this as the script. 

    Subprog AV_ITMREF(VALEUR)
    Variable…

  • 4GL Calculate Fields

    I am trying to do a simple calculation where I need to multiply two fields and the total is displayed in another field. I believe this can be easily done through 4GL programming, but have some questions. My thinking is I would add an action to the screen…

  • Previous record loaded after refresh

    Hello everyone Smiley

    Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards.

    After clicking the right menu entry the following code is executed:

    This creates the new plan based on the…

  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone,

    For our customer we developed a specific screen to manage plans.

    In order to edit a plan the user has to press a check out button.

    The user who checked out the plan can modify the plan.

    In the FILTRE action we use the global Variable GCONSULT…

  • How to change Screen Input type from "Enter" to "Display" via 4GL?

    I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field.

    I know how I could suppress it conditionally, but that's not what I want to do.

    Basically... if I were writing the suppress for…

  • ADC location override

    So I have been presented with an interesting challenge.

    In our company we've set X3 to batch allocate all available stock to meet all demand in the system.

    We also heavily leverage X3's ADC functionality.
    Our warehouse users are able to override…

  • 4GL Subtracting Time

    Hi, 

    How do you subtract time with the 4GL language?

    Thanks,
    Chris 

  • How to skip one iteration in a loop ("Repeat" statement) with 4GL?

    Hi

    I'm iterating trough a list of objects using a repeat statement. If a specific criteria matches, I want to skip the code for the current object in the loop.

    How do I achieve this? The "break" statement ends the whole repeat statement, I just want…

  • workflow and lock

    Good morning, We are experiencing an issue where users are locking during creation of a document (quotation, order, invoice etc..). We have tested this across other areas of the system and we have the same problem. I report an example: We had 5 users…

  • SAFE X3 studio auto-updating fails

    Since yesterday, I get the following exception every time I open eclipse editor to script code for x3:

    Does anyone else have the same issue?

    Regards, Benjamin

  • How import assembly doc?

    Hi everybody.

    I need import assembly doc, but now in X3 V12 this object hasn't active import check.

    I try to active and create import template, but all time system says that first line are not completed, and don't create doc.

    First, in BBY Object…

  • Delivery Locking after validating

    I trying to validate my deliveries using the  VALIDATION() subprogram in the TRTVENLIVV file. 

    Whenever, I successfully validate a delivery, the record is locked up. 

    I added the Unlock = "SDH"+delivery_number command, but the record is still locked up.…