Browse By Tags

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 was wondering how it would be possible to disable the print icon so that documents may not be printed in a specific window. I have tried using Call VIREBOUT(CHAINE,E) but it unfortunately doesn't work. Is there a different subprogram that handles icons…

I have this code which reads the given file and attempts to write it to the lines on the purchase screen. The issue is that it is populating the data into the fields, but it isn't actually "creating" the line on the screen, the same way that it does…

Hello Everyone, Can anyone let me know that how to download SEPA (FRA legislation) XML file after posting payments through manual remittance. I am not sure whether any other software required to download SEPA XML bacs file or any special setup required…

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…

On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…

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

We have set up the Purchasing dashboard for staff across the business to use and access orders. The issue we are facing is that the default gadget on the home page that displays the orders to receipt shows all available orders - this needs restricting…

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

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…

How do I write the following statement in 4GL? if date$ > 05/01/2019 do this endif Thanks, Chris

Has anybody tried to create a new quality control record via 4GL? If so, can you give me some guidance on how to do it? Thanks, Chris

What does this error message mean? I am getting this returned when I try to do a save call with my web services publication. (ZSOH is the name of my publication)

Hello I have design the master detail for testing purpose. I am not able to save the data in the grid (details table) but master table data gets saved Can i get some help?

How do I go about having a button execute on a misc. screen? I have added the button on the right list, and I usually use the AVANTBOUT action to get the button to work, but that action is only executed on an object driven screen. I am not sure how…

Is it possible to have sage run javascript code? Maybe write the code in the 4GL script? Anybody have any ideas that may work?