# Repetition/Duplicity of the Account Charts

**URL:** <https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413>\
**Category:** User\
**Created:** [July 14, 2021, 10:30am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413 "2021-07-14T10:30:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![mimo\_Alva](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/m/a698b9/32.png) [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)\
**Post date:** [July 14, 2021, 10:30am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/1 "2021-07-14T10:30:04Z")

</div>

Hello ,

in the module `"Financial"` \> General accounts \> menu `"accounts"`, i want to work with SKR03 Chart of Accounts chart but after activating this one i found 4 of them ,knowing that i just activated one SK03.

The problem is that the SKR03 has a huge amount of different accounts so it is ridiculous to try to choose from this lists of accounts because in Account Types we have now more than 500 accounts to choose from and in Accounts more than 4000!! And it’s just because it is repeated 4 times and that’s why i want to delete the duplicates one.

 ![image](https://discuss-cdn.tryton.org/uploads/default/original/2X/d/d18e6a576dc78dd6a122fa4e44d5d486b27a91fc.png)

when i try to delete the other 3 SKR03 , there was an error tell me

`The records could not be deleted because they are used by field "Parent" of "Account".`

 ![image](https://discuss-cdn.tryton.org/uploads/default/original/2X/5/5864a1fd9a87a2fe63ce8aa5acf23d91af55b0d4.png)

i want to know why there are 4 of “Kontenplan skr03 (Germany)” and what i should do to delete the duplicated versions!.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [July 14, 2021, 10:36am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/2 "2021-07-14T10:36:39Z")

</div>

> [@mimo\_Alva](#):
>
> i want to know why there are 4 of “Kontenplan skr03 (Germany)” and what i should do to delete the duplicated versions!.

Because you have created 4 times a chart from the templates or duplicated the roots 3 times (depends if you have accounts, types and taxes duplicated or not).  
Since series 4.8, there is a warning if you try to create a new chart for a company that already have one.

---

<div class="post-metadata">

**Author:** ![mimo\_Alva](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/m/a698b9/32.png) [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)\
**Post date:** [July 14, 2021, 10:48am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/3 "2021-07-14T10:48:25Z")

</div>

Thanks for the quick response

Here i was seeing this warning " Since series 4.8, there is a warning if you try to create a new chart for a company that already have one " i was ignore it because i have create a new chart with “SKR03” because “SKR03” it was not activated yet to work and if i didn’t create this SKR03 in the wizard “create chart account” i guess i can not with SKR03 !

and about a solution !

should i delete the records of the accounts menu manually" or is there any other solution !!

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [July 14, 2021, 10:54am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/4 "2021-07-14T10:54:19Z")

</div>

> [@mimo\_Alva](#):
>
> should i delete the records of the accounts menu manually"

Yes and probably consolidate the chart to create a unique chart as you may have used account from different trees.

---

<div class="post-metadata">

**Author:** ![mimo\_Alva](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/m/a698b9/32.png) [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)\
**Post date:** [July 14, 2021, 11:39am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/5 "2021-07-14T11:39:46Z")

</div>

in the menu " Account Types" when i try to remove the duplicated one "

 ![image](https://discuss-cdn.tryton.org/uploads/default/original/2X/6/6709c467b142cf678a50a2e03772e446c24d5fac.png)

tell me :

#### The records could not be deleted because they are used by field “Parent” of “Account Type”.

should i delete first the duplicated “accounts” before deleting “Account Types”!!?

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [July 14, 2021, 11:44am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/6 "2021-07-14T11:44:17Z")

</div>

Yes you must first delete the accounts because they have a foreign key to account type.  
But also you must delete the all try of account type or at least a full branch because the type has self-referencing foreign key.

---

<div class="post-metadata">

**Author:** ![mimo\_Alva](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/m/a698b9/32.png) [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)\
**Post date:** [July 15, 2021, 9:50am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/7 "2021-07-15T09:50:40Z")

</div>

HI M. @ced again , after remove all the duplicates accounts , i was gone “account types” to delete them , but there was an error prohibit me from removing them

`The data records could not be deleted because they are used in the "Type" field of "Account".`

and in other records of “account types” when i want to remove them give me another error:

` The data records could not be deleted because they are used by "Account type" in the "Parent (account type)" field.`  
please, what does mean this and how i should correctly delete the “Account Types” !

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [July 15, 2021, 9:53am UTC](https://discuss.tryton.org/t/repetition-duplicity-of-the-account-charts/4413/8 "2021-07-15T09:53:36Z")

</div>

This means that you try to delete an account type that is used by the remaining account.  
You probably deleted accounts from different charts.  
I can not help more because at some point you ignored the warnings and thus created many difficulties.
