Sage X3

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…

Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages? I would like to make this visible in my Test Page

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…

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…

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…

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…

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…

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…

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…

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…

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…

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"…

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'.

Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…

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…

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…

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!

Hi, Is there a way for me to identify where a script is being used other than identify from script name and description itself (unreliable since sometimes there's no description and badly named name). In specific, I would like to know where this script…

Can i declare more than 16 fields in an object ? If positive, how ?

Hi, Was doing Patch creation (APATCH) to bring customization over. Noticed these errors: My temporary solution is to simply delete the linebreak character since if I do not do this it crashes the main screen function. Is there a way to resolve…

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…

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…

Hi guys, Could someone pls help me creating a SPE script that check if the Customer record has notes? Thanks in advance. Best Regards, Daniel

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…

On MISC RECEIPT screen SPE: Subprog AP_LOT(VALEUR) Variable Char VALEUR() The VALUER variable is empty when I use a import template, but not when I use the UI. Help please