Using Control tables (GESACL) for email validation

We need to validate the email address entered to the field XWEB4 in the Common data, BPs, Customer (GESBPC) Function, to make sure it contains the '@ 'Symbol. The Control tables (GESACL) function, together with a logic expression, can be used to validate email address data being entered into a field in Sage X3.

1. Navigate to Parameters, General parameters, Control tables (GESACL)

2. Create a new control table entry of type expression

3. Populate the expression pat(VALEUR,"*@*") = 1

4. Populate with a suitable error message to display if the expression rules are not met and save.

5. Navigate to Development, Script dictionary, Screens and apply the expression to the field XWEB4 on the screen BPABPC

6. Save and Validate the screen

When you enter the email address in the XWEB4 Field on-screen BPC, if it does not contain the '@' Symbol the error message 'Email format Incorrect' will be displayed.