• ZONSUI no works

    Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…
  • How to call action flags in "Standard Processing" types of functions - FUNCLEAR (Close & Reopen Purchase Orders)

    Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
  • Looking for the sales FOB field in sage x3

    Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
  • Simulated Keystroke

    Hi, Is there a way in X3 4GL to simulate a CTRL+F4 Keystroke or any other key combination? Thanks.
  • Change Browser's label dynamically

    FormerMember
    FormerMember
    Hi, does anyone know how to change a browser label dynamically? At the moment, I´m using the variables TITLIS and TITSEL(1) at $TITRE action. Both variables change values but don´t display the new value. Best regards, Afonso Carvalho
  • 4GL - Reading a field value and formatting

    Hi all, I would like to read a value from a field (TEXT) and If the user entered a value different than only numbers the system will replace all non number characters to blank. something like : replaceAll( ' [^0-9] ' , ' ' ) is it possible? …
  • Sequential number on custom field

    Hi all, I am trying to create a sequential number logic for a custom field, and I appreciate if someone helps me with a step by step to how to create a sequential number structure for a custom field. The field is on SIH and PIH screen, currently…
  • material pick adc location change

    I was wondering how is the location changing on adc material picking screen? Is there a stock change transaction happening?
  • Get REST webservice photo

    Hi, I created a specific table to store some information.. One of the columns is a photo (blob)... How can I consume them via web service to show the photo on an external HTML page? In the picture below, BLOB_0 is my field where the photo is. How…
  • detailed allocation lot, location, status information

    Hello, When I do detailed allocation and look into the STOALL table, the lot, location, and status aren't being recorded in the STOALL table. Is there a way to get this data captured into the STOALL table/create its own stock record on the stock table…
  • how to create a new stock record via 4GL?

    How would I write 4Gl code that will create a new record in the stock table? Thanks, Chris
  • ADC Soap API

    Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris
  • does GPE=1 work on ouvre

    Hi, I added GPE=1 to a OUVRE action, but it is still reading the standard script. Does GPE=1 not work on the action OUVRE? I am doing this for the SUBENTL script. I created a ouvre in the SPEENTL script.
  • syntax for reading a string starting from the right

    What 4GL command would I use if I want to start reading a string from the right. I kind of want it to work how left$ works. Right$ is not what I am looking for since you have a define the number of characters starting from the left. Thanks.
  • Printing a A NEWLY field in a new SAGE X3 SINVOICE table

    Good day. I created a new field called RTNCODE which is seen in figure ask1 from the directory : Development>Data and parameters>Tables>Tables FIGURE ASK1 ON printing a crystal report of the sales invoice, THE NEWLY CREATED FIELD CAN NOT BE SEEN.…
  • Where can I find the logic for product status?

    Where do I find the logic for all of these options (see picture)? I looked in the standard script for this screen and it is not there. The screen is ITM0 and it is located on Common Data -> Products -> Products. Using Sage x3 version 11 patch 2. …