Must Have Specific Value Function

If you choose the “Must have specific value” type, a matrix appears in the configuration allowing you to tell which items/columns that need to have a value and – if needed – what values are valid values.

Field

Description

Item UID

The items Uid that must have a value.

Column Uid

If the above item is a matrix, you will need to include which column you wish to have values in.

Description

Your description of the chosen item. This description is the one being used in the warning of the customer.

Ignore last row

The ignorer last row checkbox is created to enable the add-on to do checks on document columns. SAP Business One always leaves an extra line for new data on sales and purchase documents, and the last row needs to be ignored here. Remove only the check if you work with a matrix that does not leave such extra lines.

Value Type

Here you can define how your empty and valid values should be treated, and how the tested value should be converted.

Please note the following format definition used in the valid values and empty values when comparing the data.

Type	Description
String	Strings are compared as is
Number	Always define here without thousands separator
Date	Always define in the following format yyyy-mm-dd
Currency	Always define here without thousands separator and with “.” as decimal separator (The global invariant separator)

Valid values

Here you define values you set as valid for the item. You have two options here (Cannot be combined):

Option

Description

Specific Values

Values are separated by “;” so if a, b or c is the valid values you should enter a;b;c.

NB: PLEASE NOTICE THAT THE SYSTEM IS CASE SENSITIVE.

Range values

(Only used in Number and Currency)

Here you define a range of values using “-“ as separator. As an example, if you want values to be between 1 and 10, you should set valid values to 1-10. If nothing is entered in the valid values, any value is valid except the one defined in the empty value column.

Empty value

Here it is possible to enter what is considered an empty value (if no valid values are defined). For most fields there is nothing entered. But some combo boxes have different empty values.

EXAMPLE: THE SALES EMPLOYEE COMBO BOX "- NO SALES EMPLOYEE - " HAS VALUE -1 AS EMPTY VALUE (VALUE CAN ALSO BE SEEN ON DEBUG INFORMATION AS THE VALUE IS SHOWN BEFORE THE FORM TYPE)