X3 4GL function that returns the end-date of a month
Here a function to convert a Clob rtf text to plain text
This tip has been tested on SAGE X3 version 6.
In Sales Orders it is possible to select a Prospect, X3 ask you if you want to transform it in customer. If you reply yes X3 opens the object BPC (Customer) populated with all the data of the prospect and by clicking Save you can create the customer.
This function is not present in Contracts.
Here how to enable it on Contracts :
This function return the description of a local menù
Sometimes X3 developers needs to send e-mail messages at the end of a batch procedure or from a custom form.
To facilitate these tasks I’ve written a simple Subprog that can be use where you need.
That’s the Subprog
The function below returns the available quantity of an item in a site
Here how to open an Input Box and get the value inserted by the user
Here how-to run an X3 report programmatically.
Here how to create a CLOB text
The following Subprog returns into an Integer array the list of all running processes of clients connected to X3 application server.
The Subprog needs this two local variables as parameters:
XPROCID, an Integer array in which are inserted the numbers of running processes
XNUM, an Integer which returns the count of running processes