In LS Retail POS, the Discount is calculated on "Unit Price including VAT".
Instead discount should be calculated on "Unit Price" and then VAT should be calculate on "Discounted price"
Unit Price: 80.00
Unit Price including VAT = "Unit Price" + ("Unit Price" * 0.06) i.e: 80 + 4.8 = 84.80
Discounted Amount = (Unit Price including VAT * 0.08) i.e: 84.80 * 0.08 = 6.784
Total Including VAT = Unit Price including VAT - Discounted Amount i.e: 84.80 - 6.784 = 78.016
Discounted Amount = "Unit Price" - ("Unit Price" * 0.08) i.e: 80 - 6.4 = 73.6
TAX Amount = Discounted Amount * 0.06 i.e: 73.6 * 0.06 = 4.416
Total Including VAT = Discounted Amount + TAX Amount i.e: 73.6 + 4.42 = 78.016
Both will give Total Including VAT as same. But logically VAT must be applied on Discounted Amount and it must be printed in the same format.
Any setting to be done, to have the VAT calculation done on Discounted Amount
David are you in the middle east? If so there are a lot of issues with the new VAT rules introduced on Jan 1st. NAV and LS retail (at least the version we had last year) does not correctly work with the new VAT rules in Dubai, (where I am). And its not just the rate calculation that is wrong, it also has issues with the geographic locations.I am not sure if LS Retail have addressed this yet. I have approached a number of NAV / LS customers, and most are simply waiting it out till the first round of VAT submissions happen in June. And hoping that the tax authority wont implement the fines. IN Dubai the mistake you describe above has about a $1,200 fine PER sales document printed.
Yes..I am in middle east - Bahrain. And currently we are implementing VAT for Saudi based client. Even VAT Consultants are not clear with the rules proposed by Saudi government.So we are trying to customize LS code for VAT calculation.
Same here in Dubai. The Tax authority quite smartly have already extended filing dates by 2 months to give people time to try and figure it all out. The question is whether they will enforce fines and penalties, because I have already seen millions of dollars of potential fines due to VAT errors in retail here.I think you need to go in and customize the code to follow the laws as I don't thing it makes sense to wait for LS Retail to fix this.