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 All, I have been using table fields to upload and connect it to its respective screens while working on an import template. But in address tab it uses "Screen fields" Does anyone understand the purpose or difference between the following fields…

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…

Good day all. I want to write a small specific with an action on a field. If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data. What is the command in…

Hello everyone, Please I have a problem with adding the EANCOD field in the inventory screen, when I add it in the screen the field is displayed but empty. Please help me to solve this problem. thank you

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 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!

When trying to add comments in the "Delivery Comment" box of the "Delivery" tab on the Order Management screen, I encounter the error message in the attached screenshots. This seems to occur when trying to add several comments. I'm trying to shorten the…

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…

I tried with all possible keys, but I still have a problem with the connections in between the table. Please, can anyone help me? I intend to create a query that presents all shipments and all production follow-ups made on a date and the respective accumulated…

I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1. How do I get it to display in the ITU screen so that…

Hi, In the sales order signature workflow, I want to update a field in the ORDER table when the user validates the order. I tried to add the action AWRKUPDFLD in the action tab of SOHSIG workflow, but I couldn't because the grid is already full of standard…

i have a problem with the number of decimals. The COE type ( coefficient) has 6 decimal precision but the quantity has only 5 . I deliver quantities in units but sometimes I find 0.9 because of the difference between the precision number between the…

Hello, I would like to have a calculated field in SOH4. SUM QTY of all the lines in SORDERQ which has the same PJTNUM (opportunity). Not only the lines on the screen. I would like to Sum all the lines from all the Sales Orders. I need to do same…

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, Please I was trying to add a new field to a table when trying to save it pops up this error..please help me Thank you .

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

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…

I would like to make a bundle in node.js, for Webservice consumption and add to X3.

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'm trying to add field to screen ,in the first level i add a field to table then i used it in screen but an error has displayed thank for helping me to solve the problem

Hello, I'm implementing EDI on SEM V11. When I'm adding properties in my representation, they do not appear in the file mapping or sequential file aliases list . Is there a necessary action to make new representation's properties appear in a preexisting…

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…