UK VAT Increase 4th Jan 2011

Yes, that looks right.

If you think about it, an item costing 100 GBP ex VAT, will presently cost 117.50 with tax, and will become 120.00 once VAT goes to 20%

So you need to change 117.50 to 120.00 by adding 2.50. So we need to know 2.50 as a fraction of 117.50, so we can do the same for all items.

(120.00 - 117.50) / 117.50 = 0.0212766

So multiplying all items by 1.0212766 will account for the tax raise from 17.5% to 20%.

(note I make the figure 0.02127659574 so rounds to 1.0212766 rather than 1.0212765, although I think either should be close enough to give the same result)

One important thing I think you forgot is to round the new GBP price value you're setting for each item to 2 decimal places. In most cases you won't notice the difference since Kartris will do rounding when displaying currencies anyway. But I think it is safest in case there are any internal calculations or conversions to other currencies that could be affected by a penny in some situations.

So I think it actually needs to be like this:


UPDATE tblKartrisVersions
SET V_Price = Round(V_Price * 1.0212766, 2)

Author	Message
Neil	Posted Thu 23 Dec 2010
Supreme Being Group: Forum Members Last Active: Sat 3 Nov 2018 Posts: 192, Visits: 5,220 127,205	Hi all. I have been working out the magic number for the VAT increase on the 4th and have come up with 1.0212765. This is calculated by dividing the new rate by the current rate (i.e. 1.2/1.175) If you run the following SQL all prices will go from 17.5% to 20% UPDATE [DATABASENAME].[dbo].[tblKartrisVersions] SET [V_Price] = (V_Price) * (1.0212765) You will need to disable triggers in the backend first and also don't forget to change the tax rate in regional setup to 20%. I am 99% sure this is correct so please check first and take a backup! Hope this is of help for all of you running UK based stores. Edited Thu 23 Dec 2010 by Neil
	REPLY QUOTE LIKE 362
Paul	Posted Thu 23 Dec 2010
große Käse Group: Administrators Last Active: Tue 10 Sep 2024 Posts: 807, Visits: 2,748 524,958	Yes, that looks right. If you think about it, an item costing 100 GBP ex VAT, will presently cost 117.50 with tax, and will become 120.00 once VAT goes to 20% So you need to change 117.50 to 120.00 by adding 2.50. So we need to know 2.50 as a fraction of 117.50, so we can do the same for all items. (120.00 - 117.50) / 117.50 = 0.0212766 So multiplying all items by 1.0212766 will account for the tax raise from 17.5% to 20%. (note I make the figure 0.02127659574 so rounds to 1.0212766 rather than 1.0212765, although I think either should be close enough to give the same result) One important thing I think you forgot is to round the new GBP price value you're setting for each item to 2 decimal places. In most cases you won't notice the difference since Kartris will do rounding when displaying currencies anyway. But I think it is safest in case there are any internal calculations or conversions to other currencies that could be affected by a penny in some situations. So I think it actually needs to be like this: UPDATE tblKartrisVersions SET V_Price = Round(V_Price * 1.0212766, 2) -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags VAT Edited Thu 23 Dec 2010 by Paul
	REPLY QUOTE LIKE 363
Neil	Posted Thu 23 Dec 2010
Supreme Being Group: Forum Members Last Active: Sat 3 Nov 2018 Posts: 192, Visits: 5,220 127,205	OK excellent, thanks Paul. I have already run the query but now need to round them. Can I do something like this? UPDATE tblKartrisVersions SET V_Price = Round(V_Price, 2) Edited Thu 23 Dec 2010 by Neil
	REPLY QUOTE LIKE 358
Paul	Posted Fri 24 Dec 2010
große Käse Group: Administrators Last Active: Tue 10 Sep 2024 Posts: 807, Visits: 2,748 524,958	Yes, I forgot to mention about that - that should work fine. -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags VAT
	REPLY QUOTE LIKE 353
Neil	Posted Fri 24 Dec 2010
Supreme Being Group: Forum Members Last Active: Sat 3 Nov 2018 Posts: 192, Visits: 5,220 127,205	We have also noticed that quantity discount prices will need changing also. We don't have many so they can be done manually buy have you the SQL for this?
	REPLY QUOTE LIKE 349
Paul	Posted Fri 24 Dec 2010
große Käse Group: Administrators Last Active: Tue 10 Sep 2024 Posts: 807, Visits: 2,748 524,958	The quantity discounts have their own table, so looking at the fieldnames there, the query should be UPDATE tblKartrisQuantityDiscounts SET QD_Price = Round(QD_Price * 1.0212766, 2) (i haven't tested this though, so make sure you run it on a sandbox db first!) -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags VAT Edited Fri 24 Dec 2010 by Paul
	REPLY QUOTE LIKE 363

UK VAT Increase 4th Jan 2011

UK VAT Increase 4th Jan 2011

Similar Topics

Reading This Topic