VAT Validation: Processing settings
On the tab card you have the possibility to define some settings for the VAT Validation. These will be taken into account during processing. These settings are described in detail below.
Via the entered value of the attempts you have the possibility to set the number of repetitions of a check. A retry can be triggered if the remote station of the Federal Central Tax Office is busy or your network connection results in a timeout. Each attempt, if enabled, is stored in the audit log.
The separator is only relevant for the import of CSV files for the VAT registration number check (regardless of whether batch processing or background processing). The data is split into individual values based on this separator and prepared for checking. Please consider when setting the separator to an occurrence in your master data. A comma or a semicolon can possibly occur in a company name and lead to an error in the processing. We have defined the pipe character “|” as default. For JSON and XLSX this separator is not necessary.
If spaces are allowed in your master data when entering VAT registration numbers, this can lead to errors during the check. This setting gives you the possibility that these are ignored during the check.
If you are allowed to enter lowercase letters in your master data when entering the VAT registration number, this can lead to errors during the check. This setting gives you the possibility that the check ignores the upper and lower case and is automatically set to the correct format.
Clean up VAT ID
If this option is set, the cleaned VAT registration number (spaces, upper and lower case) will be returned in the export file. This means that in log files (these have the same structure as the imported CSV file), the VAT registration number is output without this incorrect spelling. When re-importing into your ERP system, the data record can thus be cleaned up.
Mark valid VAT ID as incorrect
In the event of an incorrect qualified query, the interface of the Federal Central Office automatically checks whether the VAT registration number is nevertheless correct (simple query). The return is marked as valid. If you want to prevent this, you can do so with this option. In the log files, this leads to error 900.
Character encoding of the output
With this setting you have the possibility to control the code page of the CSV output of the VAT registration number check. UTF-8 is specified here by default. If the CSV file is further processed 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, for example with umlauts, please also set this parameter to a different one than the one currently set for you. This will solve display problems in most cases.