This should be possible to do so in the Danish localization and I would think that this could be useful in al european localizations.
It should also be possible in General Journal, Purchase Invoice / Credit Memo to set up Non-deductiable VAT Percentage.
Comments
From Latvia, we fully agree, that this should be realized in VAT entries and driven by VAT Business and VAT Product Posting group combinations. The company policy may also differ - either include this amount together in the same G/L Expense Account that is inserted in purchase document lines or show it in separate G/L account.
Category: Geographies and Localization
Hi,
Any updates on this topic? This functionality is also required by one of my customers who is using the W1 version. Based on the comments below this functionality is needed in countries like Spain, Belgium, France, Slovenia, Czechoslovakia, Latvia, Lithuania and Poland. So, in my opnion, there is a general need for a W1 solution.
Category: Geographies and Localization
This is very much needed. But since VAT in BC is handled by the combination of "VAT Business Posting Group" and "VAT Product Posting Group", this setup should not be made on G/L accounts, but should be build in the VAT Posting Setup instead.
Category: Geographies and Localization
+1 for this in Spanish localization too!
Category: Geographies and Localization
Hi,
any news in that topic?
Do you have any idea how to post such transaction without mentioned functionality?
Is it possible somehow?
best regards
- Radoslaw
Category: Geographies and Localization
This is a needed function for Spain localization too. It could be managed at VAT posting configuration and should add a field in the table Vat Entry to differentiate the Deductible VAT and the VAT Amount.
This new function affects to SII process too. In invoice lines, The VAT Amount should be shown. In field Deductible VAT, the Deductible VAT amount should be shown.
Category: Geographies and Localization
We have this feature in our CZ localization as well.
Here is our scenario:
The scenario for Non-deductible VAT in CZ
Setup:
Setup is done on the VAT Posting Setup, where we can set up on VAT posting group combination Non-deductible VAT. For example for VAT business posting group DOMESTIC and VAT product posting group 21SK combination is setup Non-deductible VAT = 93.
Scenario:
Amount of invoice = 1210 CZK
Base Amount = 1000 CZK
VAT Amount = 210 CZK
VAT= 21%
ND VAT = 93% (this means, that only 7% of the VAT Amount is deductible and 93% is non-deductible)
VAT Entry :
VAT Entry Base = 1195,30 (1000 + (210 x 0,93))
VAT Entry Amount = 14,70 (210 x 0,07)
VAT Entry Base (Non-deductible) = 930
VAT Entry Amount (Non-deductible) = 195,30
G/L Entry:
G/L Amount regarding VAT = 14,70
G/L Amount regarding Purchase Account = 1195,30
G/L Amount regarding Vendor = 1210
VAT Statement:
In the VAT Statement must be the same amount as on purchase invoice, therefore we need to use the help lines in our settings to add or subtract the final amount.
1. 1 st help line for VAT Base = VAT Entry VAT Base = 1195,30
2. 2 nd help line for VAT Base = VAT Entry Amount (Non-deductible) = 195,30
3. VAT Base = VAT Base (1 help line) – VAT Amount (Non-deductible) (2 help line) = 1195,30 – 195,30 = 1000 (reported in VAT Statement)
4. 1 st help line for VAT Amount = VAT Entry Amount = 14,70
5. 2 nd help line for VAT Amount = VAT Amount (Non-deductible) = 195,30
6. VAT Amount = VAT Amount + VAT Amount (Non-deductible) = 14,70 + 195,30 = 210 (reported in VAT Statement)
Category: Geographies and Localization
Also very desired functionality in Slovenia. We need non-deductible % VAT not only for G/L Account
but also for Items, Fixed assets...
Best Regards,
Branko Sodja
Category: Geographies and Localization
Hi Alexander,
Thank you very much for your patience. I hope the detail I’m sending is enough. If not please let me know.
Regarding the Country Code it’s “PT” or is Microsoft looking for a specific code?
Regarding the detail, I’m sending a scenario that might help contextualize things.
The Goal of the functionality:
The ND VAT is a functionality that restricts the amount of VAT that can be deducted in the VAT statement
Setup:
Setup is done on the VAT Posting Setup where we can setup ND VAT %
Scenario:
Amount of invoice: 123 €
Base Amount= 100€
VAT% = 23
ND VAT% = 10%
In this scenario only 13% (23%-10%) is deductible so:
* VAT Entry
* VAT Entry Base Amount = 100€.
* VAT Entry Amount = 13€.
* VAT % = 13%
* ND VAT% = 10%
* G/L Entry
* G/L Amount regarding VAT = 13€
* G/L Amount regarding Purchase Account = 110€
* G/L Amount regarding Vendor = 123€.
For this to happen the code (which is legacy code from Microsoft itself from before NAV 2013) transfers this information to the temporary document Tables (Sales Line and Purchase Line) and during posting transfers this information to History Tables.
The possibilities to address this from a code perspective so far involves the following:
* Let MSFT Code Run and then force change data if needed to the desired output;
* Since the changes are located in more than 200 places it’s a crazy job for a small team;
* Also it’s not very pretty;
* Completely refactor the functionality;
We would like help in understanding if we really need to completely refactor the code or is there a way to do this adjusting some of the existing code.
We realize that the Code example we sent before was for the SalesLine part, but the truth is that it’s mainly used for the Purchases (The SalesLine code is legacy code that should have been removed).
Category: Geographies and Localization
At the moment the main problem concerns Non-Deductible VAT.
Currently the code is embedded in the standard code. This means that in every particular place where VAT is calculated, ND. VAT is also being calculated.
The following examples show the scenario.
Sample1: tab 36 – OnValidate from Filed Prices Including VAT
IF NOT RecalculatePrice THEN BEGIN
...
VatFactor += SalesLine."ND %" / 100; //soft,n
--These recalculations on OnValidate fields.. would it be feasible by recreating the code on OnAfterValidate triggers?
Sample2: Cod 80 - Local Function DivideAmount
LOCAL DivideAmount...
....
BEGIN
"VAT %" := TempVATAmountLine."VAT %"
"ND %" := TempVatAmountLine. "ND %";
...
Samples3: SumSalesLines2 function (also in Cod80)
DivideAmount...
BEGIN
TotalSalesLine."VAT %" := SalesLine."VAT %";
TotalSalesLine."ND %" := SalesLine."ND %";
Note that there are 3 examples in this email but the whole scenario obliges us to make changes in about 200 different places.
What would be your suggestion for this cases?
AlexanderYakunin: Please describe you problem, I assume if you don't use ND VAT it will be zero. And let us know you country code please.
Category: Geographies and Localization
Business Central Team (administrator)