This is an explanation for making the ‘Costing Code’ field mandatory

(Could be applied in a similar way on any other column)

1)       Define new mandatory user-defined field (on marketing documents - rows)



(the Title of the field should be meaningful, since this is the name that will appear on the error message in case the value is missing)

2)       Define the following query:
SELECE NULL

3)       Define the following query:
SELECT $[$38.30.0]

(this query retrieve the value from the system field ‘Costing Code’ in the row)

4)   Define formatted search in ‘Costing Code’ column as follows:


since a mandatory UDF has a default value – the meaning of this step is to remove it whenever a new line is added in order to force the user to put its value

5)   Define formatted search in the newly UDF column as follows:


implementing this step will male sure the newly mandatory UDF column will include always the same value of the ‘Costing Code’ column:
if a value will be inserted to ‘Costing Code’ it will be copied to the UDF
if no value was inserted to ‘Costing Code’ the UDF will remain empty  – the document will not be able to be added wince there is mandatory field that is empty
if the value will be deleted by the user from ‘Costing Code’ it will be deleted from the UDF as well  – the document will not be able to be added wince there is mandatory field that is empty

6)   To complete the solution – make the new column invisible (via From Settings)