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…

I want to pass the sales order qty field to the delivery to compare and control the delivery qty(control table ) i see the control table work on the same screen.

I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it. The…

Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…

Good morning I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present. The problem is when you go back into the function and…

Hi, how can I add custom view fields 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…

Good afternoon I am trying to move data from one field to another. Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field. I believe…

Hello, i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!! please help!! i'm under X3 V11

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…

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!

Hi everybody. Any Knows if exists function to read Barcode 128? to pickup all the inforormation? Thanks!

Is there a way to update the credit status field of a sales order on creation? I have tried setting the value on in APRES_CRE "[M:SOH1]CDTSTA = 4" without any luck. I have also tried using the entry point TRTVENCDT > CALCREDIT also without any luck. …

I am trying to make the Company Name field on a screen Capitals/Upper Case only. There is an Option column on the Screen dictionary that contains Capitals (selection A). When I set it to A and validate the CPYNAM field, it will covert any text entered…

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

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

Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…

I added a custom date field to a table in Sage X3 (OPPOR). I have added the field to the table and class, I have also added the AM code to the SPE. After validation I enter a value in the field on the screen, when exiting the field, the value reverts…

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

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…

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…

The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…

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…

Does anyone have any detail documents or writeup regarding allergen in Sage X3? Partner would like to extend the allergen characters from single character to two characters and they faced some challenges. Any documents/experience sharing is greatly appreciated…