Our Blog

Custom Selection Boxes

 
Sometimes, the selection boxes in Sage X3 do not have all or enough information for the users, like the address selection boxes.
In order to overcome this, a simple selection box can be written in Sage X3.
For any user that has a basic understanding of the 4GL language of Sage X3, this will be as simple as following the below.

Step 1.
Under Development > Script Dictionary > Actions > Actions, create a new action.
Add the below code.
#################
$ACTION
Case ACTION
When "SEL_TABLE" : Gosub $SEL_TABLE
When Default
Endcase
Return
###############
$SEL_TABLE

If !clalev([F:BPA]) : Local File BPADDRESS [F:BPA] : Endif
   Filter [F:BPA] Where [F:BPA]BPANUM = [M:SOH0]BPCORD   # We are using the sales order header screen in the example.

TIT(0) = "Delivery Addresses"        # Title of the selection box
NBCOL = 6   # Number of columns in our selection box

TIT(1) = "Delivery Code" : COL(1) = "[F:BPA]BPAADD"     # Add the fields that are relevant to the selection box
TIT(2) = "Delivery Name" : COL(2) = "[F:BPA]BPADES"
TIT(3) = "Address Line 1" : COL(3) = "[F:BPA]BPAADDLIG(0)0"
TIT(4) = "Address Line 2" : COL(4) = "[F:BPA]BPAADDLIG(1)"
TIT(5) = "Address Line 3" : COL(5) = "[F:BPA]BPAADDLIG(2)"
TIT(6) = "Postal Code" : COL(6) = "[F:BPA]POSCOD"

SIZING = 100 : SIZCOL = 250
Return

Step 2.
Add the newly created action as a selection on the screen field where you are wanting the new selection.
For more information on Sage X3 integration and services, please contact us at 08 8366 6511 or on ebsolsupport@ebsol.com.au.
We will be glad to assist you.
Tags: , ,

This is a unique website which will require a more modern browser to work! Please upgrade today!