Sage X3

Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…

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

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…

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

I added a custom field to a table in Sage EM (OPPOR). I followed the steps in the help to also add the field to the class (OPPOR) for the table. I validated the table, synced the class, validated the modified screen, validated the object, but it still…

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.

Exeception error with Eclipse editor .Working wth Sage X3 6.5 .I opened, Developement>>Processing>>eclipse editor null/eclipse.exe java.ioExeception: Cannot run program"null/eclipse.exe": CreateProcess error=2. The system cannot find the file specified…

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

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…

I am creating a class and see a section for collections. What exactly does this do?

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