Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Customised VAT Report

Posted on by Microsoft Employee

Hey All, 

Please can anyone help me?

I need to build a VAT report that for the UK that includes some other orders in our system that don't exactly match with UK addresses on billing. 

Is there a smart list or report i can build to help do this? 

Currently using 2015 but in process of upgrading to 2018.

Any help would be grateful at this time. 

TIA. 

Categories:
  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Customised VAT Report

    Lu, need more information about how you setup VAT to handle both warehouses, to work on your desired report first it's important to understand working scenario, If you want you can contact me in person and I will try to help you in your report writing.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customised VAT Report

    Dear  Cheryl,

    Thank you for your response.

    We have 2 warehouses. one in Netherlands and one in UK. Both sets of orders are processed by our Europe hub. we have other orders that fit between the two.

    I need a Customised report  to include the ones that fit in between. in the UK ones as they come under the UK VAT but i cannot see how to include ones in that.

    Hope that clears it up.

    Lu

  • RE: Customised VAT Report

    Hello Lu H,

    The details of what you need are very vague, so it's difficult to respond to your post as is.

    All documents that have a tax code on them should be in the 'Tax History' table (TX30000).   You will find a Smartlist already on this table under Smartlists | Company | Tax Detail Transactions.

    Otherwise you will need to build customized reporting per the data you need.  

    I hope that helps,

    Thank you

    Cheryl Waswick

    Microsoft Dynamics GP Support

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans