Categorie
Sage X3 Tips & Tricks

Sage X3 end-date of a month

X3 4GL function that returns the end-date of a month

Categorie
Sage X3 Tips & Tricks

Sage X3 convert RTF to plain text

Here a function to convert a Clob rtf text to plain text

Categorie
Sage X3 Tips & Tricks

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 :

Categorie
Sage X3 Tips & Tricks

Sage X3 how get the Description of a Local Menu

This function return the description of a local men├╣

Categorie
Sage X3 Tips & Tricks

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

Categorie
Sage X3 Tips & Tricks

Sage X3 how get the 'available quantity'

The function below returns the available quantity of an item in a site

Categorie
Sage X3 Tips & Tricks

Sage X3 Input Box

Here how to open an Input Box and get the value inserted by the user

Categorie
Sage X3 Tips & Tricks

Sage X3 procedure to launch a report

Here how-to run an X3 report  programmatically.

Categorie
Sage X3 Tips & Tricks

Sage X3 Create a new CLOB Text

Here how to create a CLOB text

Categorie
Sage X3 Tips & Tricks

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