Sage X3

Hi, I tried updating the field CRITERE on the screen EXPOBJ from 120 to 250 but something is still truncating my criteria to 120 characters. Any suggestion?

Hello, I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows: $ACTION Case ACTION When "AVANTBOUT" : gosub ZSOLCPT When default…

Hi folks We have the problem that in certain cases an IC purchase invoice is not automatically created for a customer when the corresponding IC sales invoice is released. Most of the time it works but not always. We have set up the intercompany…

Hi Everyone, I need to add a couple of fields to the criteria window. The fields in question, are the SOHNUM and CUSORDREF fields from the SORDER Table. The screen in question is the SCRITSRH screen. Adding them to the Screen was pretty easy and they…

We have a query that is primarily filtered by GACTX.USER, so that the user who is logged in can see only their orders on this query. However, for some users I would like them to be able to see the entire report. I was wondering if there was a way to filter…

Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…

Hi, Would like to know the significance of the W* prefix files in TRT folder of each Sage X3 folders. [1] Is it safe to delete W* prefix files in TRT folder on folders that is not named X3? [2] What are the W* prefix files in TRT folder? [3] How…

In the object function, the system does not allow us to add views in the environment tab, which bar us from using fields from a view on the left list. I understand that we can use field expression to call a function on the selection tab to add a customized…

We would like to index GACCENTRY for search but it looks like it is not one of the entities available for selection by default. How can we add this to the search indexing functionality?

Hi. I need to emulate pressing the tab key in a grid field, in x3 4gl language. Is this possible? I have managed to position the focus on a field with: zonsui = "[M:PTH1]LOC("+ num$(nolign-1) + ")" but now I need to emulate pressing the tab key…

Hi, I have SAGEX3 release/12.17.0 build 33 and i'm trying to run the following graphql query: { xtremX3Manufacturing { workOrderProductionReporting{ query{ edges{ node{ workOrderProductionReportingLines{ query{ edges{ node{ lot } } }…

Hi, i want to know how can I get the state of checked/unchecked from the checkbox of order selection in GESPTH function. I need to get this value to evaluate a value change of a field on receipt line, from a SPE script, on FIN-PICK action, by example…

Hi, I need to read .xls files for import customization development activity. Does anybody know if is possible or not ? Regards, Roberto

Hello! I am struggling with the task to provide a pop-up window with the comments once an existed sales order open. I have created a window and an action. Now, I need to write a script with a trigger. Here is the challenge. Once a user chooses an existed…

Hey everyone, I'm having some trouble adding the SO # to the left list of the sales invoice. Does anyone have a good any good recommendations on how I could add that? I was thinking about grabbing the SO from the SDELIVERY table but having problems…

HI All We recently upgraded a customer for the latest patch level of sage X3 V12 2023 R1 (12.0.33) , we had older code that sent out an email when the user changed the bank details of a supplier. We did this with a call to ENVOI_MAIL from AWRKMEL. Code…

After recent upgrade to V12, the "Log Reading" screens are smaller and hard to read. I can Zoom in to enlarge the screen but we would like to increase the default size.

I want to link the Product site table to Supplier Addresses table.

I have several company logo in png format that I wish to link to my SAP Crystal Report as in (Able to use the company logo on the SAP Crystal Report) by extracting the company logo from Sage X3. I would like to know how to do so. I need clarification…

Hi All, I've have created an import template for Technical Sheet. However it did not succeed in uploading the description. Mind to point out which part is wrong? Regards Meng

Can someone help me how can resolve this error. am just a novice when it comes to sage.

Good morning fellows! Today I am looking for a way to extend product info on function "Price list entry". A customer wishes to be able to see field information "Description 2" in addition to the already displayed field "Description 1" within the grid…

Would it be possible to display and select supplier addresses in a supplier table in product site?

Hello, I'd like to create a button on one of my screens. I've seen here that it's possible to do this using a field with a graphic object: https://www.greytrix.com/blogs/sagex3/2013/02/27/adding-graphic-object-on-screen-in-sage-x3/ I created my field…

We have the need to query a list of products using the new GraphQL API. The filter in specific is a list of product IDs. We already took the graphql training and this is not addressed anywhere. Could you please help? This is the query that we are trying…