You’re offline. This is a read only version of the page.
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
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.
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
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.
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.
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:
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (