Skip to main content

Notifications

Microsoft Dynamics NAV forum
Suggested answer

Multiple VAT rates in one line on Purchase Invoices?

Posted on by 22

Hi,

I got a question about purchase invoices and VAT. We have both a VAT code for high VAT rates and low VAT rates for invoices. Could I do something to allow NAV to actually give in the real amount of VAT on the invoices in one line instead of calculating it. We work with a capture tool and it's manual intensive to go in and add a second line with a new VAT code. There is no use for the different codes as our tax authority doesn't make a difference in the refundable tax. Whether it's 6 of 19% we still fill it in on the same line in our VAT filing. So it cost quite some effort, with no real use.

 I will give an example to make my question easier to understand as I find it somehow hard to describe it properly.

Example:

Total invoice with VAT € 1.720

Total Invoice ex VAT € 1.500

VAT high rate (1000 x 19%) = € 190

VAT low rate (500 x 6%) = € 30

What we do now:

Line 1: 1000 Vat code VAT19

Line 2:  500 Vat code VAT6

What I would like

Line 1: 1.500 Vat code VATNEW + enter the real VAT amount € 220

Would this be possible somehow?

  • Roy1987 Profile Picture
    Roy1987 22 on at
    RE: Multiple VAT rates in one line on Purchase Invoices?

    Hi Steven,

    That combined with your first suggestion indeed works. But it's still a lot of clicks, so I am not sure if it will be faster than using 2 lines.

    I assume there is no direct way of editing the amount without coding.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple VAT rates in one line on Purchase Invoices?

    Roy,

    On the Purchase Invoice, after you enter the line, click Statistics and you will see the Lines Fast Tab. In this section you have a field VAT Amount. Modify the value there.

    pastedimage1618508453719v1.png

    Hope this helps.

    Thanks,

    Steve

  • Roy1987 Profile Picture
    Roy1987 22 on at
    RE: Multiple VAT rates in one line on Purchase Invoices?

    Hi Steven,

    Thanks for the reply. I do try in one line. I did what you suggested but it doesn't work for me:

    - in my line I can add 'Amount including VAT' but it's grey and can't be adjusted.

    - 'VAT amount' is not a field I can add in my columns.

    - I don't see a summary of VAT based on the VAT identifier.

    4263.screen.PNG

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple VAT rates in one line on Purchase Invoices?

    Roy,

    Based on what you are asking for I have a questions first... On the Purchase Invoice, are you entering 1 line or 2 to breakout the Item or Service? So does it look like this:

    Type      No.        Description      Cost      VAT PPG

    Item      1234      High Item       1000       19% VAT

    Item      2345      Low Item         500         6% VAT

    Or is it 1 line of 1500?

    The reason I ask is you could implement the Allow VAT Difference on Purchase & Payable Setup and on the General Ledger Setup (Max. VAT Difference Allowed) to manually enter the VAT amount. What this feature does is the total VAT amount for the invoice, grouped by VAT identifier, is displayed in the lines. You can manually adjust the amount in the VAT Amount field on the lines for each VAT identifier. When you modify the VAT Amount field, the program checks to ensure that you have not changed the VAT by more than the amount you have specified as the maximum difference allowed. If the amount is outside the range of the Max. VAT Difference Allowed, a warning will be displayed stating the maximum allowed difference. You will be unable to proceed until the amount is adjusted to within the acceptable parameters. Choose OK and enter another VAT Amount that is within the allowed range. If the VAT difference is equal to or lower than the maximum allowed, the VAT will be divided proportionally among the document lines that have the same VAT identifier.

    If you enter 2 lines, this would be tough since it is added up to total. A Single line obviously will work because you can manually enter the 220 figure in your example on the line.

    Hope this helps.

    Thanks,

    Steve

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans