Sage X3

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 have a sales order that has multiple lots allocated to the first SOQLIN. When i try to create a delivery via importing it, it is creating the delivery for one of the lots, and leaving the other lot allocated to the sales order. For example, if i…

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…

I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?

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, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…

Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…

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

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

Hi, as mentioned in the subject when i try to modify a screen with a new picking list row inserted it returns to me this error: WNUMDOC-WLINDOC Undefined Parameter But i can't find these parameters anywhere I tried in OPOH window in Sage X3 V11

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?

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

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?

Where are blob files stored on the sql server? (Like the actually physical image)