Sage X3

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 need to read .xls files for import customization development activity. Does anybody know if is possible or not ? Regards, Roberto

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…

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.

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…

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

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…

When creating a menu item that is just an external link, the iframe fails to load. I even tried just rendering a simple page from a local apache web server and i cannot get it to work, regardless of how I configure the meta CSP values. Browser shows…

Hello! I am a beginner at creating new custom screens/windows/objects, etc. I have researched for hours but I cannot figure out what the cause of my issue is, hopefully someone can help! I have a header table and a detail table. I also have a header…

Hi togehter, we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system. Unfortunately we cannot choose inquiry screens as an object in the patch creation…

Context: Current folder is created from X3 Add new button on OBIC Window (Customer BP invoice) Issue: When creating a new Customer BP invoice (that has not been saved or created yet), our customized button remains enabled. However, it…

Hi, Is there a way for me to identify where a script is being used other than identify from script name and description itself (unreliable since sometimes there's no description and badly named name). In specific, I would like to know where this script…

Hi I am just going to leave this here for Sage to hopefully acknowledge. I know its not mission critical or stopping the system working but seriously that I have to tell users Sorry you have to choose one of these is becoming quite offensive …

Hello, I'd like to know if it's possible to run a specific script during the creation of a purchase order only when modifying a particular field. When the supplier (BPSNUM) field is filled, I want to automatically fill the BPAINV field according to…

FAQ I've seen multiple requests on how to add custom columns to Web Scheduling and thought a quick guide to this case and Brickscould help everyone: Log in to the scheduler and select the Wrench -> Advance Configuration . Automatically,…

Hello, I created a new ZCHECKBOX field in the OPPOR and BPCUSTOMER tables. By default I want the ZCHECKBOX field in the OPPOR table to have the same value as the BPCUSTOMER field when a new project is created. Users can then change it if necessary…

In X3 V_12 is there a way to disable a custom button (non Predefined buttons) in a Miscellaneous window (no Object)? If it was a window with a object I would use Call VIREBOUT(CHAINE,"X") From GOBJET but this is a Miscellaneous window. Thanks, …

Hi guys, Could someone pls help me creating a SPE script that check if the Customer record has notes? Thanks in advance. Best Regards, Daniel

We'd like to put the read-only pages on visual processes so that we can limit the number of locks generated on objects like customers and sales orders. The process is reasonably straight-forward - set the link type to URL and copy and paste the relevant…

After reviewing the product status options under product setup (Active, Obsolete, not usable, on shortage.. etc), we have decided that certain options are not applicable to our business process. To avoid confusion to our users, we'd like to hide some…