Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / VAT tax multicurrency
Microsoft Dynamics GP (Archived)

VAT tax multicurrency

(0) ShareShare
ReportReport
Posted on by Charles Abetz 935

Hi Community

 

I am currently facing an issue with a client where the subtotal seems to be substituted from the functional currency to the Taxable sales in the originating currency and there giving false VAT amounts.

Here is an example, VAT is calculated at 20% on sales.

The exchange rate is  functional currency x .8066  to the originating currency ie: F1 = O.8066

 


 Functional Currency Originating Currency
Subtotal 456.84 566.38
Tax 73.71 91.38
Total 530.55 657.76
Taxable Sales 368.49 456.84
Tax 73.71 91.38

The Tax Detail Id has been set to have Taxable tax

 

If any one could help me out on this that would be much appreciated as it has me stumped as to why it has done this.

 Charles

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: VAT tax multicurrency

    Hi Arthur,

    Thats good - It figured it had to be an integrated transaction.

    How is the transaction being integrated? eConnect, Integration Manager or a custom table import?

    If the values are not being supplied by the integration, then they are defaulting from GP set up - but it could still be a problem with the import.

    Ian.

  • Arthur Iskandar Profile Picture
    Arthur Iskandar 30 on at
    Re: VAT tax multicurrency

    Hi Ian,

    I'm working with Charles on this issue.

    On further investigation, this appears to be affecting a single Debtor. It also appears that only RM Invoices with more than 1 line items are affected.

    Manually duplicating the transactions worked fine. These transactions were integrated from an outside source - Which had led me to believe the incorrect numbers were brought over from the source file. This does not seem to be the case as the source file does not include such numbers and there are other debtors in the same file.

    The affected transactions display the same pattern, which corresponds to what Charles mentioned in his original post: [Originating taxable sales = Originating subtotal * Exchange rate]

    I hope this makes sense to you.

    Arthur.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: VAT tax multicurrency

    Hi Charles,

    Understood on all accounts.

    Was the transaction manually entered or integrated in some way?

    If you recreate the exact same transaction - does the issue reoccur? You can just create a new transaction - no need to post - and check the distributions.

    After that - I would really need to review the transaction in your system to see if I spot anything, as I haven't seen this behaviour before. I am quite happy to take a look if you want - but you would need to set me up with remote access. PM me if you want to do this.

    Ian.

  • Charles Abetz Profile Picture
    Charles Abetz 935 on at
    Re: VAT tax multicurrency

    Hi Ian

    Thanks for your reply.

    Yes it is a UK sale.

    How many line items are on this sales invoice?   4 lines in the invoice

    Has one of the line items got an extended price of 88.35? No there isn't any item with the extended price of 88.35

    Is every line item got the same Tax Detail on it? Yes they do have the same Tax Detail ID

    Is it possible that someone adjusted the Tax Detail entry before posting? I have performed a test when modifying this and it doesn't cause the issue I am describing here.

     

    Kind Regards

    Charles

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: VAT tax multicurrency

    Hi Charles,

    The Taxable Tax option should not be an issue - I guess. There would only be one Tax detail on this sale as its a UK sale? (I'm guessing its UK due to the FX rate and the 20% VAT).

    How many line items are on this sales invoice?

    Has one of the line items got an extended price of 88.35?

    Is every line item got the same Tax Detail on it?

    Is it possible that someone adjusted the Tax Detail entry before posting?

  • Charles Abetz Profile Picture
    Charles Abetz 935 on at
    Re: VAT tax multicurrency

    It is viewed from the Sales Transaction Enquiry screen in Microsoft Dynamics GP.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: VAT tax multicurrency

    Hi Charles,

    Where are you seeing this data? Is it on a VAT Daybook report? Or in the AX detail window on a transaction or some other report?

    Ian.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans