• FILTRE Entry Point / CRITSPE

    I'm trying to add an additional Criteria (using the CRITSPE field) to filter which Remittances should be posted. The current code is below: $FILTRE If dim([F:PYH]FIELD1)>0 CRITSPE = "FIELD1=2 & FIELD2=2 " Endif Return As far as I understand the…
  • Disabling all the fields in GESSRH function except the Returned Qty field based on function profile

    Hi, I have a request to disable all the fields from GESSRH function except the returned quantity field in the Grid for certain function profiles. I have tried Grizo all the fields and actzo the qty field but it does not seem to be working with Grid…
  • Is it possible create new keyboard shortcuts in Sage?

    I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey
  • ZONSUI no works

    Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…
  • How to call action flags in "Standard Processing" types of functions - FUNCLEAR (Close & Reopen Purchase Orders)

    Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
  • Question on importing 100 function profile's functional authorization

    Hi, I would like to update 100 function profile's functional authorization. I developed an import template (based on AFP and GESAFP; I did something on AFP object to allow import) but I got this error for special supervisor functions like: AIMP or…
  • "Entry impossible: the preparation code for this site has not been set up!"

    Hello, I have a need to explore the usage of "preparation codes", however, when I try to set one up, I get an error: How do I bypass this, or set up a preparation code at the site as mentioned? I cannot click in the preparation code box. A site…
  • VIREBOUT DON'T DISABLE NEW BUTTON

    Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • SAGE X3 UP 9

    Hello Hello to all the Sage Community, I introduce myself i m from TUNISIA and i work on Sage Solutions since 1998 so about 26 years and i wonder if in this Community of philantrop and experience is there a Virtualmachine or Plateform to access to…
  • Use table from another folder

    Hello everyone In X3 documentation it is described that it is possible to use a table from Folder A in Folder B. https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html I tried it like this: Unfortunately it doesn't work with the period between…
  • Call script method from another folder

    Hello folks Is there any way I can call in folder A a method from a script in folder B? Something like this? I'm writing an entry point which must be written in X3 folder. We have library scripts in not X3 folder. Instead of copying those library…
  • Adding custom fields to PAY1

    Hi there, I have a need to add a custom field to the grid array in screen PAY1, but I noticed the screen itself it is marked as "Templ. screen" and the verification button is greyed out. I tried adding the field anyways and verifying entry transaction…
  • Entry point not called

    Hello everyone I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE. I created the entry point and the processing script in the X3 folder…
  • 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…
  • 404 not found error when creating new request object

    In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…
  • How to disconnect web client session via 4GL?

    I am looking for the possibility to terminate a web client session via 4GL code. If I am doing so via X3 GUI, there's a REST POST fired using the representation "sessionStates" with the endpoint "disconnect". Is there any chance to do this by code? I…
  • [4GL] Screen's field action on import template for UPC Code to Product Code.

    Hi, 4GL question. I have a custom import template. There are two identifiers, Header and Lines. For Header identifier, it will always be one row in the import file. For Lines identifier, it can have multiple dimensions (translated: it can have…
  • Error Table in the process of modification

    Hi, For context: - There are two custom scripts each using own custom import template. -- The only difference between the two custom script is just the custom import template used. Both opens same tables for import. - Both are scheduled in Recurring…
  • Manual Matching (LETTRAGE) screen - actions are not being called?

    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…
  • Convert GMT datetime to local datetime

    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…
  • View Archive Folder scripts from the Web Service script editor

    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…
  • Entry point when report is finished printing

    Hello We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code: For a custom development we are looking for an Entry Point which…
  • Create a delivery from a pickticket using webservice?

    Hello All, We have the need to trigger/automate the creation of a delivery (from a given PickTicket) to an external system using webservices. Could you please provide some guidance / sample subprogram code to get us going? Thank you so much
  • Error 26 : Internal error Inconsistent reference value (11026)

    Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…