Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Adding EU Customer VAT...
Microsoft Dynamics AX forum
Answered

Adding EU Customer VAT numbers

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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?

Categories:
Administration and Setup
  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 61 on at
    RE: Adding EU Customer VAT numbers

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adding EU Customer VAT numbers

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adding EU Customer VAT numbers

    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.

  • Verified answer
    Stefan Hofmaninger Profile Picture
    Stefan Hofmaninger 520 on at
    RE: Adding EU Customer VAT numbers

    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.

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,508 Super User 2024 Season 2 on at
    RE: Adding EU Customer VAT numbers

    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

  • nunomaia Profile Picture
    nunomaia 10,684 Moderator on at
    RE: Adding EU Customer VAT numbers

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans