Do you have a VAT group defined for your products? Sounds weird as the code in the blog is actually some code we use in production :) Is your new vatgroup id saved in the db?
The VAT group is set on the Master product only. Set as group 1 (VAT).
Yes the new group is in the DB.
I can now see that the orders VAT Group is getting set correctly (I've written it to the screen) and, the ManipulatedVATGroupID field on the order is being set to 2 (0%) in the DB.
The ManipulatedVATGroupID field on the order lines remain as 1 (VAT).
What's confusing me is although the order's VAT has been set to group 2 (0% = 0% for all countries) the value of order.TotalVATFormatted is 158,33 Euro as shown below.
You also have to set the VAT group for the orderlines - because an orderlines can have its own special VAT group. Try and set it and see if it works. Did you somewhere in your code previous set the VAT group id for the orderlines - because these should "inherit" from the order if not specific is set for the orderline.
I understand more about how the VAT Group stuff works now. Each product had its VAT Group configured to 1 (VAT) in the content so that was overriding the VAT Group on the order. I thought every product needed this to be set but now that I know it will inherit its value from the order if it's not I can see that it is best left blank in most cases.
Anyway, deselecting the VAT Group from the products has produced the required results.
Dynamic VAT
I'm hoping to implement dynamic VAT as illustrated in this blog entry however setting the order.VATGroupID is having no effect.
I've two VAT groups defined:
1) VAT = 20%
2) 0% = 0%
Setting the order's VATGroupID = 2 is still adding VAT of 20%.
Regards,
Matt
Hi Matt
Do you have a VAT group defined for your products? Sounds weird as the code in the blog is actually some code we use in production :)
Is your new vatgroup id saved in the db?
Kind regards
Anders
The VAT group is set on the Master product only. Set as group 1 (VAT).
Yes the new group is in the DB.
I can now see that the orders VAT Group is getting set correctly (I've written it to the screen) and, the ManipulatedVATGroupID field on the order is being set to 2 (0%) in the DB.
The ManipulatedVATGroupID field on the order lines remain as 1 (VAT).
What's confusing me is although the order's VAT has been set to group 2 (0% = 0% for all countries) the value of order.TotalVATFormatted is 158,33 Euro as shown below.
Cheers, Matt
Hi Matt
You also have to set the VAT group for the orderlines - because an orderlines can have its own special VAT group. Try and set it and see if it works. Did you somewhere in your code previous set the VAT group id for the orderlines - because these should "inherit" from the order if not specific is set for the orderline.
Kind regards
Anders
Hi Anders,
I understand more about how the VAT Group stuff works now.
Each product had its VAT Group configured to 1 (VAT) in the content so that was overriding the VAT Group on the order.
I thought every product needed this to be set but now that I know it will inherit its value from the order if it's not I can see that it is best left blank in most cases.
Anyway, deselecting the VAT Group from the products has produced the required results.
Cheers,
Matt
is working on a reply...