Categorie
Sage X3 Tips & Tricks

Split function

Split a string into an array of string
Parameters:
PPSTR: The complete string to split
PDELIMITER: The string defined as content separator / delimiter of the string
XXTMP: The array that will contains the separated strings
Returned value: Number of separated elements

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