Browse By Tags

  • 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…
  • pass a field from sales order to sales delivery based on the sales order number

    I want to pass the sales order qty field to the delivery to compare and control the delivery qty(control table ) i see the control table work on the same screen.
  • Adding Field to transaction grid

    I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it. The…
  • Non-Conformance - help needed to add custom fields

    Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…
  • 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 - Left List Personalization

    Hi, how can I add custom view fields into standard (browser) object Left List ? It's easy to add other tables but , what about views ? Example:this is a standard object I've added my custom view into Viste tab: But in Selezione tab (Selection…
  • Update Transaction

    Good afternoon I am trying to move data from one field to another. Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field. I believe…
  • calculate available stock

    Hello, i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!! please help!! i'm under X3 V11
  • LEDES 1998B Timekeeper Custom Field

    I am getting this error message on my bills "The field " " for Timekeeper cannot be blank". I understand that I need to change the Timekeeper Classification setting in the LEDES set up box, and in order to do that, I need to create a custom field. However…
  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
  • Error adding Custom Description field to BOMs and Work Order Screens

    BOMs I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - I've added a "Before Field" Action to the ITMREF field and added this as the script. Subprog AV_ITMREF(VALEUR) Variable…
  • Looking for the sales FOB field in sage x3

    Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
  • Optional Field Value. entering error

    Optional Field Value. Attempt to modify a different record than was retrieved. Im getting this error while trying to enter new value for the optional field. Kindly help. Thank you
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • Read Ean128 function

    Hi everybody. Any Knows if exists function to read Barcode 128? to pickup all the inforormation? Thanks!
  • Update Credit status field (CDTSTA)

    Is there a way to update the credit status field of a sales order on creation? I have tried setting the value on in APRES_CRE "[M:SOH1]CDTSTA = 4" without any luck. I have also tried using the entry point TRTVENCDT > CALCREDIT also without any luck. …
  • Field Option for Capitals

    I am trying to make the Company Name field on a screen Capitals/Upper Case only. There is an Option column on the Screen dictionary that contains Capitals (selection A). When I set it to A and validate the CPYNAM field, it will covert any text entered…
  • Simulated Keystroke

    Hi, Is there a way in X3 4GL to simulate a CTRL+F4 Keystroke or any other key combination? Thanks.
  • Change Browser's label dynamically

    FormerMember
    FormerMember
    Hi, does anyone know how to change a browser label dynamically? At the moment, I´m using the variables TITLIS and TITSEL(1) at $TITRE action. Both variables change values but don´t display the new value. Best regards, Afonso Carvalho
  • What is the maximum number of UDF's you can create for the Sales Order Detail table?

    In general is there a maximum number of UDF's per table. And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
  • Sage X3 V11 Autoamtic Journal (GLCO) - Post line company as dimension

    FormerMember
    FormerMember
    Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…
  • Custom date field in table OPPOR (Sage X3)

    I added a custom date field to a table in Sage X3 (OPPOR). I have added the field to the table and class, I have also added the AM code to the SPE. After validation I enter a value in the field on the screen, when exiting the field, the value reverts…
  • 4GL - Reading a field value and formatting

    Hi all, I would like to read a value from a field (TEXT) and If the user entered a value different than only numbers the system will replace all non number characters to blank. something like : replaceAll( ' [^0-9] ' , ' ' ) is it possible? …
  • sage one cant export bank details

    FormerMember
    FormerMember
    Hi everyone. I am struggling to export the bank details I spent hours loading into Sage one. You can extract Allot of details but not what I need. I tried creating a user field which I named Bank account, Br code and bank name and was hoping there…