• Customer BP Invoice Function , Field (TAX) allows for display/input.

    Hi Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process. I already changed the input to enter, but still no luck. Any of you know this process?
  • Setting Zones in Sage X3

    Hey All, My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…
  • 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…
  • 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…
  • Filter of registers to be exported by Script from model export

    Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx
  • 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…
  • Use SOAP Web Service to create quote issue.

    I have a integration service do so a series integration. If there is any error, when create quote SQH, it will give error: @X3.TRT/SUBSFIT$adx (149) Error 7 : Class Non-existent [M:SFIT] 0 : Sage X3 errors After restart the X3 SOAP Web Service then…
  • Default value for specific components

    Hello, Im looking for solution to add default component value in function GESDBY Disassembly. I tried to use something like this: $APRES_CRE For i=0 To max([M:DBY1]NBLIG -1) if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…
  • 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…
  • 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…
  • 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…
  • Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • Left Join with is null check

    Hello I want to write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…
  • 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…
  • 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…
  • 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…
  • Hiding Product status List Options

    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…
  • "Tax Excluded" invoicing element still charges tax

    Hey Everyone, About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…
  • 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…
  • 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…