Tag: Sage

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