• SAGE X3 SCRIPT EDITOR - CONDITIONAL MANDATORY FIELD

    Good day all. I want to write a small specific with an action on a field. If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data. What is the command in…
  • Customizations in X3 folder

    Hello everyone We sometimes have problems when a batch job runs more than once. In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…
  • custom field

    Need help with new custom field formula. I create custom field "Net Available Stock" I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
  • Function cannot be called in this context

    Hello everyone I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows. The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…
  • Script does not update field value if the line is not entered

    $VERIF_MOD Local Char ZPRODCOD(30) Local Char ZPRODCODOLD(30) Local Integer YESNO YESNO =2 For i=0 To max([M:POH2]NBLIG -1) For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i) ZPRODCODOLD = [M:POH2]ZPRODCOD(i) ZPRODCOD=[ITM]ZPRODCOD if…
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In 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…
  • Is there an entry point or built in function to view an attachment?

    On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…
  • Recursive Funprog 4GL not working

    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…