X3 4GL function that returns the end-date of a month
Sage X3 convert RTF to plain text
Here a function to convert a Clob rtf text to plain text
Sage X3 trasfom Prospect to Customer, in Sales Contract
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 :
Continue reading “Sage X3 trasfom Prospect to Customer, in Sales Contract”
Sage X3 how get the Description of a Local Menu
This function return the description of a local menù
Continue reading “Sage X3 how get the Description of a Local Menu”
Sage X3 How to send an e-mail
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
Sage X3 how get the ‘available quantity’
The function below returns the available quantity of an item in a site
Sage X3 Input Box
Here how to open an Input Box and get the value inserted by the user
Sage X3 procedure to launch a report
Here how-to run an X3 report programmatically.
Sage X3 Create a new CLOB Text
Here how to create a CLOB text
Sage X3 how get a list of client running processes
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
Continue reading “Sage X3 how get a list of client running processes”