Automate the log checking of scheduled jobs in Sage X3 and be calm!
Who manage Sage X3 ERP software doesn’t alert you for scheduled job error of MRP execution? Are you the Sage admin and you don’t have time to check all the logs day by day?...
Category: SageX3
Are you a developer? Do you want to learn programming in Sage X3’s language?
Here you will find lots of information and examples to quickly deal with the various problems that may arise
Tables Join in Sage X3 adonix with Link instruction
The instruction that Sage X3 makes available to make a join between two tables is Link. Here we see how to create a join between the TAB1 table and the TAB2 table; TAB1 is...
How to recover the current sage x3 folder name: nomap ()
We have already seen how to recover the basic path of a folder. To find the name of the current folder, use the instruction: nomap(NUMBER) In detail, if the current folder is the third...
2 ways for obtaining the current window name
To obtain the name of a window in Sage X3 there are at least two ways. The first one consists in recovering current mask name with F6 key ( ESC-F6 from v7 version), then...
To go in a new line in the middle of a adonix code instruction
To go in a new line in the middle of a code instruction just put & as first character (without any spaces before) of the new line. Here an example: [M:YTX]YFIELD1(nolign-1) = [F:YTM]YFIELD2 +...
3 ways to send a mail from code in Sage X3, with more attachments too
In this post I’ll show you how to send a mail from adonix code in Sage X3. The points we will face are: 1) Meladx/Send introduction 2) Sending through meladx (the best way for...
How to use time and date
Let’s see today how to use time and date in Sage X3. To get the current date in a Date variable, use the date$ function. In the same way to have current date and...
Loops and conditions
Conditions If Then Else The following scripts are equivalent: If I=1 Then J=2 Else J=3 : Endif If I=1 : J=2 Else J=3 : Endif # the “:” allow to write one instruction after the other...
Sorting an array in Sage X3
To sort an array use Sorta with the following syntax: SORTA NUMVALUE_ToORDER ARRAY [Desc] SORTA NUMVALUE_ToORDER ARRAY1, array2 [Desc] (array2 ordered following the order of ARRAY1) Example: Local Char STR(255)(0..4) Local Integer NUMBER(0..4) Local...
Master/detail pattern management
Sage X3 allow to create the management of a new object practically with only parameterization. But if tou need to achieve an object with master/detail pattern you must follow a very precise procedure that...