Sage X3

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…

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…

Hi there, I have a need to add a custom field to the grid array in screen PAY1, but I noticed the screen itself it is marked as "Templ. screen" and the verification button is greyed out. I tried adding the field anyways and verifying entry transaction…

Hello I would like to dynamically hide a column in a table (in the SOH4 screen). I manage to do it for a single field of the screen with the Chgfmt command, but not for a complete column. Is there another command or another syntax?! For info I am…

Hi, Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table. So I am trying to make the selection of itmref field in the line tab in order filter…

Hi, Is there a way in X3 4GL to simulate a CTRL+F4 Keystroke or any other key combination? Thanks.

Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…

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

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

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 would I write 4Gl code that will create a new record in the stock table? Thanks, Chris

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

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.

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.

Hi, How do I write this 4gl statement for a Date Datatype? Subprog C_DAT(VALEUR) Variable Date VALEUR If VALEUR = "" mkstat=2 GMESSAGE = "Date is Mandatory" Endif End This is throwing an incompatibility error because I think you cant write…

Hi, Is there a way to convert an integer to represent days in 4GL? For example, I have an integer that says 40. How can I make it so it represents 40 days? Thanks!

Can somebody tell me if the SPESTOALL is actually the SPE script for the STOALL screen? I have been writing code in it and I have not been receiving a response back from the screen.

Hi, There is something wrong with my code and I am not sure what is wrong with it. The E represents the standard button, save, code for the screen. Thanks! ########################################################## $AVANT_E If [M:ALL]STA(nolign…

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