Browse By Tags

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…

Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…

Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…

Hello, I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM: Unfortunately, this script does not exist in the…

Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…

Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…

I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?

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…

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…

Hi, How do you subtract time with the 4GL language? Thanks, Chris

Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…

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…

How can I show a quote in a string? I am not looking for answer like you can have a single quote and then the quotes inside the single quotes. Is there a 4GL command that will add a " into a string without ending the string In java, we would put…

Is there a way convert a Datetime value to Date type in the 4GL language? I need to compare a date with a datetime variable in 4GL but it does not work. Therefore, I would need to convert the datetime to a date.

I created a alpha numeric field on the screen that is suppose to calculate the time difference between UPDDATTIM and CREDATTIM. In the 4GL i wrote this, but it is throwing an incompatible type: [m]myfield = num$([F]UPDDATIM - [F]CREDATTIM) I am assuming…

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…

I have a recurring task that exports invoices to our EDI system and I'm trying to implement a selection criteria to separate out invoices from selected customers. I have tried variations on the script below but it is constantly rejected by the formula…

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

Hi, I am trying to get a value display on a field on the PO line screen. This is the concept: field description data type [M:POH2]GROPRI entered md8 (internal type: decimal) [M:POH2]DISCRGVAL entered md8 (internal type…

I am trying to do a query soap call on the quality control screen (STQ Object). I keep getting this error message. Does anybody know what this error means? I only see one mask in our system so I am not sure where the system thinks there are 2.... …

What is the difference between ETAT and ETATN when it comes to automatically printing out reports? ETAT () from AIMP3 ETATN () from ETAT

I am running into an issue where the I can't print a pick report and packing report based on the delivery number that I specify. It seems like it is not reading the delivery number that I specify and just the STOFCY value I created a subprogram, and…

I wrote some 4GL code to have paper automatically print via 4GL code. When the job gets sent to the printer, the printer is asking to select the manual feeder with plain paper letter on the physical device. The user would have to press the automatically…

I have a icon and I have set up a script to make it clickable. When I click on the icon, it isn't loading anything. This is the code I have. Is this not possible with icons? Subprog CL_ZPICDOWNLOAD(VALEUR) Variable Char VALEUR() Callui RETOUR="" With…

Has anyone released products from quality control using web services? If so, can you provide some details on how you did it? Thanks, Chris