Small and medium business | Business Central, N...

Multiple VAT rates in one line on Purchase Invoices?

(0) Share

Report

Posted on by Roy1987

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?

All responses (4)

Answers (0)

Roy1987 22 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.

Hope this helps.

Thanks,

Steve
Roy1987 22 on at

Like (0)

Report

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.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

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