Sage X3

Good day all. I want to write a small specific with an action on a field. If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data. What is the command in…

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…

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…

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…

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

Hello! I have created a simple workflow and script to display fields that have been modified in a PO where the cost is over $10,000. This works by checking the [M] field against the base [F:POH] field, and using RETVAL to display the changed information…

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

Hello, I have a process that sends workflow mail via existing product sites with safety stock, and after it runs, I'd like to set their respective safety stocks to 0. I've marked where I would like to implement this code in my code snippet. I tried…

Good afternoon! I am looking to set up a new workflow rule which will automatically email all of the affected product-sites when a product status is changed. So far, I have managed to set up a rule that will detect when the custom status field we…

Hello everyone Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards. After clicking the right menu entry the following code is executed: This creates the new plan based…

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…

Hi all, how can i remove, via 4GL, an ITMREF row on a Screen, for example, knowing only row's index number on Sage X3 V11?

Hello, Is it possible to make a for-loop with a SQL "group by" or "select distinct" statement? Br, Carl

Hi everyone, We have the following situation: We will like to use a .ps1 (PowerShell File) as a Batch task in order to avoid the Windows Task Scheduler. We have found this in X3 help Should we compile the script to convert it in a .src file? …