• Unknown warning upon login - Access to the ERPMAN badge(s) has not been granted

    Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey
  • 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…
  • Graphical Query tool - selection criteria based on Expression

    Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
  • 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…
  • Vendor or Supplier Grading

    Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…
  • 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…
  • Invoice Lines SQL Query

    anybody knows how i can get the backend SQL query for 'Invoice Lines' for <<sage X3 sale >> under invoices
  • 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…
  • 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…
  • Adding Total Deposit to Left List On Manual Remittance Screen (GESFRM)

    I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
  • Confirming of Purchase Order

    Hi All :) Good day, what are the ways to confirm PO? I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
  • 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…
  • 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…
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Patch creation - include inquiry screen

    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…
  • Editing Field to Screen

    Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this Does anyone know if I am doing this correctly? Thanks!
  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
  • Object fields

    Can i declare more than 16 fields in an object ? If positive, how ?
  • Custom drop-down list is blank

    Hello, I've created a custom drop-down list in the WT03TSA1 (Stock Change Intersite) screen, but when trying to use it, none of the options are displayed. Instead, it says "No Match": The menu is set up as follows: The field is set up as follows…
  • [X3v12-4GL] In Script editor, how to open a X3 Storage Area folder to reads its filelist names?

    Hi, 4GL Development question. Not sure the keyword to find for these. In 4GL, I know I can just manually put in the hardcode filepath to open through SYSTEME2 raw OS cmd call but it is very annoying to maintain (about 5+ scripts to update) every time…
  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
  • Add field EANCOD in the inventory screen

    Hello everyone, Please I have a problem with adding the EANCOD field in the inventory screen, when I add it in the screen the field is displayed but empty. Please help me to solve this problem. thank you