Dear All,
Good day!
I am looking for fields to add customers / vendors VAT Number in AX 2009.
I can't seem to find such a field. Could you help me find such a field or create one.
*This post is locked for comments
Hi. The setup was made for Saudi Arabia.
I used the "Tax Exempt Number" field under customers - setup to enter the VAT numbers for all customers as we discussed on this thread. Then as per Saudi regulations, I have to print the VAT number of the customer on each Sales Order / invoice.
I added the field company.info.vatnum to print the customer's VAT Number (Tax Exempt Number) on my invoice. The screen-print shows that the field is blank on generating the invoice and the empty field on being right-clicked shows the form Tax Exempt Numbers but does not pick the VAT number for that customer from the said form.
Hi,
The setup that you made is for which country?
What does the screenprint above show?
Best regards,
Ludwig
Any help, anyone please? :)
Hi! I am able to find the field in companyinfo.VATnum
However, the number does not appear. It brings up the form name when I right click on the generated invoice. Screenshot below. Am I missing something?
As Dr. Ludwig mentioned, I am using the TAX Exempt Number field to enter my customers VAT numbers, which need to appear on the invoice.
Please check the fetch method of the report to see the vatNum value is retrieved from tables either custTable (or) custInvoiceJour (or) CompanyInfo.
Relation to custTable:LogisticsAddressCountryRegion:TaxVATNumTable.CountryRegionId == LogisticsAddressCountryRegion.CountryRegionId;CustTable:custTable.postalAddress().CountryRegionId == TaxVATNumTable.CountryRegionId;vatNum = custTable.vatNum;
Relation to custInvoiceJour:LogisticsAddressCountryRegion:TaxVATNumTable.CountryRegionId == LogisticsAddressCountryRegion.CountryRegionId;custInvoiceJour:LogisticsPostalAddress::findRecId(custInvoiceJour.InvoicePostalAddress).CountryRegionId;vatNum = custInvoiceJour.vatNum;
Relation to companyInfo:LogisticsAddressCountryRegion:TaxVATNumTable.CountryRegionId == LogisticsAddressCountryRegion.CountryRegionId;CompanyInfo:companyInfo.postalAddress().CountryRegionId = TaxVATNumTable.CountryRegionId;vatNum = companyInfo.vatNum (or) vatNum = companyInfo.ImportVATNum
Hope this information helps you.
Dr. Ludwig, Good day! I am trying to have this VAT number / Tax Exempt number printed in our sales invoice. I am having difficulty identifying the table and data field. The table under information of Tax Exempt Number is TaxVatNumTable, however, when I select Data Field "Vat Num", it does not return the VAT number I entered for the particular customer. Any input is appreciated. Screenshot below.
Thank you for your support! :)
I think this is the right field. If you Switch the language of your application from en-us to en-gb, the field name is VAT number
Probably make the setup in a demo system and run some tests on those customers.
Hi Dr. Ludwig. Yes I understand. My country requires that I enter the VAT numbers for all customers. My doubt is, is it the correct field to enter the VAT numbers for all customers? What I don't understand from this is, why is it called Tax "Exempt" number instead of Tax Number or VAT Number? I believe exemption means those customers to who VAT does not have to be charged. I actually just need a field to enter & record the VAT numbers of all customers and not just customers that are exempted from Tax.
Hi oldman.logan,
It depends. In some countries, the government requries to print those number on invoice documents, which would require to enter those tax numbers for all customers. This is something you would have to clarify.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Guy Terry 2 Moderator
Martin Dráb 2 Most Valuable Professional
Community Member 2
