• Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • Execute ACTION from STD on Sage X3

    Using Sage X3 v12 (2021R3), I try to execute on a TRT the $APRES_CHOI action from STD and SPE. My process is the following : Object called ZDK, I'm opening an action AZDK1 that opening a custom selection popup (with screens and backend-code). GACTION…
  • Custom messages in standard flyout?

    Hi folks I'd like to know if there's an easy way to show custom messages using the standard flyout banner (e.g. shown if record has been updated)? I know I can use Infbox to achieve a similar result, but the user should not be forced to click a…
  • ALOG No working on scheduled tasks

    I have a script using ALOG class to write to a log file. It works fine when I manually run the script but nothing is logged when it runs on scheduled task. Please help
  • Field data not present until Update clicked

    Good morning I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present. The problem is when you go back into the function and…
  • SageX3 - Selection List

    Hi, in a custom selection script like this: GSELFAC = 1 : # campo che deve ritornare Filter [F:YPROD] CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'" NBCOL = 0 NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL) = "Cod.Produttore…
  • Inquiry Screen Custom Fields Missing on Export

    I added a new column to an inquiry screen. Since the field is from a table not included in the inquiry, I used SPE code to populate the field in the inquiry. This works fine, but when I export it via Excel, that field isn't populated. Does anybody know…
  • Reversal Journal Entry - Line Description to Capture Original Journal Line Description

    The client would like to request for a change in the logic of the Line Description of the reversals In Journal entry function (GESGAS), while clicking reversal from the right side button, the system will create reversal journal. In that Journal the…
  • RDSEQ NOT READING LINE CORRECTLY

    Hi, We are planning on upgrading our system from V11 to V12 P29. One thing I noticed is that sage is not able to detect a new line when reading the trace file. When I read the trace file, sage thinks that everything is in 1 line when it is not. Is…
  • Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?
  • Product image on other screens

    What I would like to accomplish is that ability to tunnel quickly to what a product looks like without sending our users to the Product screen. The screen I would like to implement changes is the Sales Order entry screen. Initially I was thinking that…
  • Set Column Titles Dynamically

    Is there a way to dynamically set column titles for a grid on a screen? I can do this: But I want to make it more dynamic, like this, but X3 doesn't like it.
  • Implementation problems with specific inquiry

    Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…
  • Field Data Type AIN Issue

    Good morning I have added a field to SORDER, and then added that to SOH0. I am then receiving a heap error, but not sure what to do next. Anyone have any advice?
  • Generic Object Read

    I need to create a generic function to read an object in X3. I'm thinking some of the standard object functionality could be used, or maybe even a dynamic query, but I'm not completely sure how to approach it. For example, I want to pass a table name…
  • Affzo not working without mask abbreviation?

    Hi When I use the following line of code Affzo [M]ITMDES2(NLIG) I get the following exception According to the documentation at https://online-help.sageerpx3.com/erp/12/staticpost/affzo/ this should be working If I check the value of the…
  • 4GL Left list picking - number of selected items

    Hi folks I'm looking for a possibility to get information about how many items are selected in a picking left list on action $PICKE and $DEPICK. My goal is to allow the user to only select one item and show an exception message if he tries to select…
  • Web service returning "Process[WS_NAME] - No return code (status[6]) "

    I'm getting the following message on some web services responses. Just in some times. "Process[ZWS_NAME] - No return code (status[6]) " The web services its a Subprogram web service. Has anyone known what is it? And how to fix it?
  • Quick Representations/Class Setup for X3V12

    Hi, I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…
  • I need help verifying a variable on creation of Sales Invoice

    I there, I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty Here is my…
  • Subprogram to Create Delivery and Invoice

    I want to build a few subprograms to be executed through web services. Basically, from a given picklist in GESPRH2, I want to click the buttons for 'Deliverable' and then 'Delivery' to create the delivery, and then in GESSDH I want to click the 'Invoice…
  • 4GL Calculate Fields

    I am trying to do a simple calculation where I need to multiply two fields and the total is displayed in another field. I believe this can be easily done through 4GL programming, but have some questions. My thinking is I would add an action to the screen…
  • Previous record loaded after refresh

    Hello everyone Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards. After clicking the right menu entry the following code is executed: This creates the new plan based…
  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone, For our customer we developed a specific screen to manage plans. In order to edit a plan the user has to press a check out button. The user who checked out the plan can modify the plan. In the FILTRE action we use the global Variable…
  • Transfer custom fields from STOALL to STOJOU

    I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…