VAT Validation: Processing settings

You have the option of setting some settings for the VAT Validation on the tab. These are taken into account during processing. These settings are described in detail below.

ID Validation Settings VAT Processing

Attempts

You have the option to set the number of retries of a validation by entering the value of the tests. Repetition of the request can be triggered if the remote office of the Federal Central Office for Taxes is busy or your network connection will cause a timeout. Each attempt is stored in the audit log, if enabled.

Delimiter

The delimiter is only relevant for the import of CSV files for the VAT Validation (regardless of whether batch processing or background processing). The data is converted into individual values using this delimiter and can be used to check processed. When setting the delimiter to a Occurrences in your master data. A comma or semicolon may appear in a Company names occur and lead to an error in processing. We have defined the pipe character “|” as the default value. This delimiter is not necessary for JSON and XLSX.

Spaces

If spaces are allowed in your master data when entering VAT number, this may result in errors in the validation. This setting gives you the Possibility that the validation ignores them.

case-sensitive

If the entry of lowercase letters in your master data is allowed when entering VAT number, this may result in errors in the validation. This setting gives you the Possibility that the validation is case-sensitive and automatically set to the correct format.

Clean up VAT ID

If this option is set, the adjusted VAT number (spaces, uppercase and lowercase) in the export file. This means that in log files (these have the same structure as the imported CSV file) the VAT number will be returned without this incorrect spelling. When re-importing into your ERP system, the data set can be cleaned up.

Mark valid VAT ID as incorrect

The interface of the Federal Central Office automatically checks in the event of a faulty qualified validation to see if the VAT number is still correct (simple validation). That Return is marked as valid. Want to If you disable this option, you have the option to do so. In the log files, this results in error 900.

Character encoding of the output

With this setting, you have the option to change the code page of the CSV output of the VAT Validation control. By default, UTF-8 is specified here. If the CSV file is used with Microsoft Excel, it is recommended to use Win1252 (this corresponds to the ANSI encoding).

If the data records in the output file of the VAT Validation are not displayed correctly in your text editor or in Microsoft Excel, e.g. with umlauts, please also set this parameter to a value other than the one you are currently using. correctly, please set this parameter to a different one than the one you are currently using. This will solve display problems in most cases.