Sage X3

Hi, Anyone knows if it's possible to change a record by code without leaving and entering the object? For instance, a button on a window that forces the current record to other than the one currently loaded. Is there any standard call…

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…

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

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

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

Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…

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

Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…