Sage X3

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

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…

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

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 on the…

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…

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 !clalev…

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? 

Thanks in…