All writing

3 min read

Unraveling L4G in the ERP Sage X3

L4G is the scripting language behind Sage X3 customisation. A worked example: validating the customer code field on a sales order screen.

  • ERP
  • Internship

On my second day, I had the opportunity to delve into L4G scripting within the ERP Sage X3 environment. This powerful language allows for extensive customization and optimization of the ERP system, ensuring it meets the specific needs of businesses.

Code Example: Validating Customer Code Field

Below is a practical example of L4G code that I worked on. This script validates the customer code (BPCNUM) in a sales order screen (SOH).

Here are some of Code Exemple:

$ACTION
Case ACTION
When "AV_FIELD"
    Gosub AV_FIELD
Endcase
Return

$AV_FIELD
Case FIELD
When "BPCNUM"
    Gosub VALIDATE_BPCNUM
Endcase
Return

$VALIDATE_BPCNUM
Local Integer OK  # Define a local integer variable

# Check if the customer code is not empty
If [F:SOH]BPCNUM = ""
    Message("Customer code cannot be empty")
    OK = 0  # Validation failed
Else
    OK = 1  # Validation succeeded
Endif

# Return the validation result
If OK = 0
    Return
Endif

# Additional custom logic can be added here

Return

Explanation

To integrate this script into the sales order screen:

  • Go to Development > Script Dictionary > Screens.
  • Find the screen you want to customize (e.g., SOH).
  • Attach the script ZSOH to the screen by specifying it in the screen’s script field.

Reflection

Working on this script was an enlightening experience. It not only improved my understanding of the ERP system but also demonstrated the flexibility and power of L4G. I am excited to continue exploring this technology and to contribute to innovative solutions at Inetum.