web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

UK VAT 100 report and boxes 8 and 9 (Northern Ireland to EU)

(1) ShareShare
ReportReport
Posted on by 221
Hello!

Can anyone provide me with what the setup should look like in order to amounts in boxes 8 and 9?
If there exist a detailed setup information I would be happy to receive a link
 
  1. Does the customer or vendor need to have any adress specific setup, for state ets?
  2. How should the Sales Tax Code look like?
  3. Can I setup a sales tax group like SNI and PNI (Sales Nothern Ireland/Purchase Northern Ireland)
  4. Should a separate Item sales tax group be created?

     
Thank you in advance for you kind helt 
I have the same question (0)
  • Suggested answer
    KK-29041429-0 Profile Picture
    221 on at
    UK VAT 100 report and boxes 8 and 9 (Northern Ireland to EU)
    I Have now been able to create and get numbers populated in box 8 and 9.

    it is important to take a look at adress setup format, it format 0030
    Yoy need to verify that Sales Tax Code is set for EU
    You need to add this NI in Country region setup




     
  • KK-29041429-0 Profile Picture
    221 on at
    UK VAT 100 report and boxes 8 and 9 (Northern Ireland to EU)
    The description in the suggested answer does not solve my issue. 

    I have set up a vendor with the adress in Northern Ireland Like this

     
    I put a purchase of an item 

    I have this VAT postings


     
    But in the VAT report the amount still popups in Box 7 and not in 9 as I would like.

    Is there something in the adress setup that is needed in order see the state of the vendor?
    Is the solution to setup Northern Ireland as a new country?
    Is there something in the configruation setup for Excel VAt for UK that I have to take a look at?

     
  • Suggested answer
    Adis Profile Picture
    5,403 Super User 2025 Season 2 on at
    UK VAT 100 report and boxes 8 and 9 (Northern Ireland to EU)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans