Adding EU Customer VAT numbers

(0) Share

Report

Posted on by Community Member

When users trying to add VAT numbers to the Customer account set up for reference, the field doesn't accept entries typed straight into it. If you manually enter something, you get a message saying that 'the value xxxxxxxxxxx in field VAT number is not found in the related table 'VAT number table'.

If you right click the box and 'view details' you get a blank drop down list in which you can add a line, but it asks again for Country / customer name / and VAT number which concerns me as Country and name are already set up elsewhere.

Is there something wrong with the set up of this field, or do I need to change the parameters?

Also I found the parameter that states VAT number required for EU country customers but this doesn't seem to work as I can still set up a new customer without it asking.

We don't do any EC sales lists, its just for recording the VAT number for future reference for foreign customers.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

nunomaia 25 Moderator on at

Like (0)

Report

In Accounts receivable parameters, in General tab, you can define if VAT is mandatory or optional. The available options are. None / Domestic + EU member states and EU member states

The VAT Number is a list that you can populate in General Ledger.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi AXfinance,

The VAT number that you enter on the Customer record comes from a setup table, and it must exist in this setup table before you can use it. Getting to the setup table using View details seems to be the most efficient (and recommended) way to do it:

technet.microsoft.com/.../aa551488.aspx

Once you know that this field is known as 'Tax exempt number' in US English, its easier to find information about it. You might stumble across this blog post, by one of the contributors to this communnity, which explains that you are probably not seeing a warning on missing VAT numbers because of some Country setup in the Foreign trade parameters:

kaya-consulting.com/how-to-solve-the-tax-exempt-number-must-be-specified-error-on-creating-customers-and-vendors-in-ax-2012

Was this reply helpful? Yes No
Verified answer

Stefan Hofmaninger 520 on at

Like (0)

Report

The VAT numbers are maintained in a seperate list -> so the Standard way in AX is as you described: new customer -> right click on the VAT number field -> details -> add a new Dataset with all the informations you Need (Country and VAT number) and then add this number to the customer.

Concerning your problem with the mandatory field:

In AX standard this works only if you add a new customer directly in the listpage "all customers" -> in our case we create customers from the global adressbook -> in this case the Parameter for mandatory VAT numbers is not working.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Guy, this seems a bit bonkers to me to create another list of VAT numbers somewhere else, but if that is what you have to do............

Yes I did stumble over that article but got side-tracked on whether the address was marked as the Primary one or not (IT was) which seemed to be the cause of someone elses problem. I will revisit the Foreign trade set up bits.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

For info, once the country in question had been added to the foreign trade parameters list and designated an EU country, the validation worked and it requested a VAT number when I didn't put one in, thanks all

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

Just one additional comment - the country you see on the VAT table is NOT stored anywhere else.

The country on the VAT table indicates the country where the client is registered for VAT filing.

Keep in mind it is completely possible (at least in in the EU) for a client to have address/primary address in country A, but to be registered for VAT in another country - hence the need to keep "country of registration" in the VAT numbers table.

Was this reply helpful? Yes No