With the extension NCVV VAT Reg. No. Validation you can easily and quickly import the values confirmed by FinanzOnline into your master data ( customers, vendors and contacts), as you can store an individual address format for each country.
For many countries concerned, the formats are provided as a download with this app. However, you can extend or adapt them individually.
On the NCVV Address Formats page you can store a separate address format for each country.
This address format is used to link the data reported by FinanzOnline (FON) to the relevant fields in Business Central.
For more information, see Appendix, Data Structure.
Tip
However, the extension of the address formats can be set up not only per country, but in extreme cases even related to individual customers, vendors or contacts.
Important
The prerequisite for this function is the use of the validation service of FinanzOnline.
Fields
Die folgenden Felder stehen in der Tabelle zur Verfügung.
Country/Regioncode
Specifies the Country/Region Code with which this Address Format record is associated.
Länder-/Regionsname
Shows the Country/Region Name, this field is automatically filled when you select the Country/Region Code.
Address Format configured
Shows if a configuration has already been created for this address format
Actions
Download
This action starts the download of the suggested address formats. The data comes from the navax download site.
Import
With this action you start the import from already existing files.
Export
With this action you start the export of your address formats into an XML file, which you can import at a later point.
Address Format Lines
When retrieving the data from FinanzOnline (FON), the address data as well as the name of the creditor/debitor/contact to be validated are confirmed in the response of the service. The address data is divided into several lines, one address format line corresponds to one address data line that has been confirmed by FinanzOnline.
For more information, see Appendix, Data Structure.
Address Format Lines, Fields
The following fields are available in the table.
Country/Regioncode
Specifies the Country/Region Code with which this Address Format record is associated.
Country/Region Name
Shows the Country/Region Name, this field is automatically filled when you select the Country/Region Code.
Address Line
Specifies the value of the address field returned from VAT Reg. No. Validation service. You can set up the mapping of the address fields to fields from Business Central on the NCVV Address Field Mappings page, the page is accessible via the AssistEdit function of the Field Mapping field.
Field Mappings
Shows the value of the field mappings. You can set up the mapping of the address fields to fields from Business Central on the NCVV Address Field Mappings page, the page is accessible via the AssistEdit function.
Address Format Lines, Actions
Address Field Mappings
The action opens the Address Field Mappings page where you can assign the address lines to the fields in the master data.
Up
Moves the currently selected line upwards.
Down
Moves the currently selected line down.
Address Field Mappings
The address data confirmed on FinanzOnline can be automatically imported into your Business Central master data. In order to do this, the address fields have to be assigned to the master data fields, this is done by using address field mappings.
For more information, see Appendix, Data Structure.
Address Field Mappings, Fields
The following fields are available in the table.
Field No.
Specifies the Field No. in Business Central, this is the Field No. associated with the address field sent from FinanzOnline.
Field Name
Shows the name of the field.
Separator
Specifies the delimiter, this delimiter is added after the value of the mapped field. If you need to assign multiple fields to an address line, each line - except the last one - must have a separator specified. If the value Custom is selected, the separator in the Custom Separator field will be used.
Custom Separator
Specifies a custom separator. If the value Custom is selected in the Separator field, the separator can be specified here as text with length 10.
Address Field Mappings, Actions
Up
Moves the currently selected line upwards.
Down
Moves the currently selected line down.
Steps to set up Address Formats
To create or edit a new address format, proceed as follows:
Open the NCVV Address Formats page. You can access the EU VAT Registration No. Validation Service Setup page via the Address Formats field.
Note
The NCVV Address Formats page cannot be searched for with "Tell me what you want to do".
Select a record from the list or click New to create a new record.
The NCVV Address Format page will open.
Tip
In the column Address Format configured you can see if you have already created a customized Address Format for this country.
For more information, see Appendix, Data Structure.
In the field Countries/Region Code specify the code of the country for which you want to create an address format, when you edit the record the field is already filled.
Note
As soon as you leave the field, the Country/Region Name will be suggested automatically. The value comes from the Countries/Regions table.
Switch to the lines and assign the address lines to the fields of the master record.
Tip
An Address Line corresponds to an Address Line that is reported back by FinanzOnline.
Select the desired address line in the Address Line column.
Assign the corresponding fields of the record to the address lines which should be transferred when the validation details are applied. To do this, click in the line in the Field Mapping column.
The NCVV Address Field Mappings page opens.
Select the relevant Business Central master data field in the Field ID field. The field name will be updated automatically after the selection. If an Address Line of FinanzOnline (FON) contains several values (e.g. Post Code and City), you can also create multiple lines in this facility.
To separate the individual fields, the Separator field provides a few defaults. Choose Custom to specify a custom separator if you don't find it in the list.
In the Custom Separator field you can then define this separator. There are 10 characters available.
Important
If you need to assign multiple fields to an address line, each line - except the last one - must have a separator specified.
Note
Also pay attention to the following special case:
There are countries where there is even a space in the zip code (e.g. Prague: 100 00) and the city is also specified in the same field (reported value: 100 00 Prague). Here an exact analysis in the validation details in the infobox NCVV FON Address Data is necessary. This is because the city can be separated from the ZIP code by two spaces - as in the Prague example. Thus, in the address line setup with the ZIP code, enter two spaces in the separator column, and the application will be able to transfer ZIP code and city correctly.