# Error while upgrading - multiple vat rates

**URL:** <https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420>\
**Category:** Questions\
**Created:** [December 7, 2018, 7:49am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420 "2018-12-07T07:49:09Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [December 7, 2018, 7:49am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/1 "2018-12-07T07:49:10Z")

</div>

While upgrading to Litium 7 (from version 6.2) we get the following error message (multiple times). The link in the error message leads nowhere (http error 404); where can I read more about this problem?

_Error-Base Product with Article Number = “abc123” has multiple price lists in “NOK” and VAT is not the same. If products has several pricelists then VAT must be the same per currency. Read more on [https://docs.litium.com/links/upgrade/multiple-vat](https://docs.litium.com/links/upgrade/multiple-vat)_

Litium version: _7_

---

<div class="post-metadata">

**Author:** ![anusha.ganegoda](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/anusha.ganegoda/32/58_2.png) [@anusha.ganegoda](https://forum.litium.com/u/anusha.ganegoda)\
**Post date:** [December 18, 2018, 10:47am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/3 "2018-12-18T10:47:39Z")

</div>

This is a known issue, which will be fixed in a comming service release to Litium 7. The links points incorrectly as at now to non-existing articles.  
It is being fixed.

---

<div class="post-metadata">

**Author:** ![marten](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/marten/32/11_2.png) [@marten](https://forum.litium.com/u/marten)\
**Post date:** [December 18, 2018, 11:01am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/4 "2018-12-18T11:01:13Z")

</div>

The bugfix will be adjustment of the link, the source problem need to be fixed in your data before running the upgrade.

You need to check that articles only have one VAT-rate per currency.

---

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [December 18, 2018, 4:54pm UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/5 "2018-12-18T16:54:20Z")

</div>

We will have a look, but could you please verify that the query (in Upgrade\_PreRequires.sql) that produces this warning is correct? From our initial investigations it seems to give false positives, i.e. articles that don’t have multiple VAT rates in a specific currency, but that do have different VAT rates for different currencies, are still flagged.

---

<div class="post-metadata">

**Author:** ![hans](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/hans/32/31_2.png) [@hans](https://forum.litium.com/u/hans)\
**Post date:** [December 20, 2018, 2:42pm UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/6 "2018-12-20T14:42:22Z")

</div>

@anusha.ganegoda, @marten Can you confirm whether or not the sql query in the upgrade script works as intended if you have multiple pricelists?

---

<div class="post-metadata">

**Author:** ![ton.nguyen](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ton.nguyen/32/989_2.png) [@ton.nguyen](https://forum.litium.com/u/ton.nguyen)\
**Post date:** [December 20, 2018, 7:28pm UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/7 "2018-12-20T19:28:43Z")

</div>

You are right, the script does not work correctly. We have identified the problem and will release it as soon as possible.

---

<div class="post-metadata">

**Author:** ![ton.nguyen](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ton.nguyen/32/989_2.png) [@ton.nguyen](https://forum.litium.com/u/ton.nguyen)\
**Post date:** [December 21, 2018, 6:37am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/8 "2018-12-21T06:37:24Z")

</div>

It has been released in 7.0.1 [https://docs.litium.com/documentation/release-notes](https://docs.litium.com/documentation/release-notes)

---

<div class="post-metadata">

**Author:** ![jinesh](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jinesh](https://forum.litium.com/u/jinesh)\
**Post date:** [December 24, 2018, 5:55am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/9 "2018-12-24T05:55:48Z")

</div>

Hi,

VAT issue seems to be fixed now. I’m posting a new error which happens while upgrading  
Error-Could not convert Content Property “Link” in table dbo.CMS\_PageTypeProperty to field because it has multiple definitions. Please make sure to have one defintion for each content property. Read more on [https://docs.litium.com/documentation/upgrading-to-litium-7/upgrading-the-database#Fields](https://docs.litium.com/documentation/upgrading-to-litium-7/upgrading-the-database#Fields)

But it seems, this error is being displayed when we have same PropertyName in different PageTypes.  
Could you please have a look on this, as well?  
Or the property name should be unique, irrespective of pagetype?

---

<div class="post-metadata">

**Author:** ![ton.nguyen](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ton.nguyen/32/989_2.png) [@ton.nguyen](https://forum.litium.com/u/ton.nguyen)\
**Post date:** [December 24, 2018, 9:00am UTC](https://forum.litium.com/t/error-while-upgrading-multiple-vat-rates/420/10 "2018-12-24T09:00:24Z")

</div>

Yes, the property name, which is used to generate the field type id should be unique.
