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?
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.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148