These settings specify the format string and what characters are ignored for a valid amount.

Invoice Processing Agility recommends that the following default value is used.

However, you can slightly modify the string to include additional ignore characters to cover a wider variety of currency symbols.

Format

This is a simple expression that defines the format of an amount. For more information on Simple Expressions, see the Transformation Designer Help.

This is set to #[2-10] by default. This means that a string with between two and ten digits is expected.

Ignore Characters

These are special characters that may appear in an amount, but can be ignored.

This is set to ,.'-_$£¥*^€ by default.

For example, a value of 999.99 is accepted as an amount because it is between two and ten digits in length. The decimal point is ignored.

Deactivate Cross Validation

If selected, the mathematical checks applied to the extracted invoice amounts in Validation are deactivated.

This setting is cleared by default.

Export Thousand Separator

The thousand separator character that is used when formatting the amount for data export.

This is set to "," by default.

Export Decimal Separator

The decimal separator character that is used when formatting the amount for data export.

This is set to "." by default.