Comment 0 for bug 1068398

Revision history for this message
Maxime Chambreuil (http://www.savoirfairelinux.com) (max3903) wrote : [6.1] account.tax child created before its parent

Using latest revision of OpenERP 6.1 server, web and addons:
* Create a new database in english without demo data
* Install account_accountant and choose Canada
* Choose the english template and the GST + TVQ sales and purchases taxes
* Check the GST + TVQ for purchase tax, it has one child

In the database, in the table account.tax.template, check the GST + TVQ for purchase tax, it has 2 children

Children taxes are generated from the template before their parent, resulting in an empty parent_id field.

Account.tax.template

             name | id | parent_id
-------------------------------+----+-----------
 GST + PST for sales (MB) | 1 |
 PST for sales - 7% | 2 | 1
 GST for sales - 5% (MB) | 3 | 1
 GST + PST for sales (PE) | 4 |
 GST for sales - 5% (PE) | 5 | 4
 PST for sale - 10% | 6 | 4
 GST + TVQ for sales | 7 |
 GST for sales - 5% (QC) | 8 | 7
 TVQ for sales - 9.5% | 9 | 7
 GST + PST for sales (SK) | 10 |
 GST for sales - 5% (SK) | 11 | 10
 PST for sales - 5% (SK) | 12 | 10
 TVH for sales - 12% | 13 |
 TVH for sales - 13% | 14 |
 TVH for sales - 13.5% | 15 |
 TVH for sales - 15% | 16 |
 GST for sales - 5% | 17 |
 GST + TVQ for purchases | 18 |
 TVQ for purchases - 9.5% | 19 | 18
 GST for purchases - 5% (QC) | 20 | 18
 GST + PST for purchases (MB) | 21 |
 GST for purchases - 5% (MB) | 22 | 21
 PST for purchases - 7% | 23 | 21
 GST + PST for purchases (PE) | 24 |
 GST for purchases - 5% (PE) | 25 | 24 <- parent
 PST for purchases - 10% | 26 | 24
 GST + PST for purchases (SK) | 27 |
 GST for purchases - 5% (SK) | 28 | 27
 PST for purchases - 5% (SK) | 29 | 27
 TVH for purchases - 12% | 30 |
 TVH for purchases - 13% | 31 |
 TVH for purchases - 13.5% | 32 |
 TVH for purchases - 15% | 33 |
 GST for purchases - 5% | 34 |

Account.tax

             name | id | parent_id
------------------------------+----+-----------
 GST for purchases - 5% | 1 |
 GST for purchases - 5% (PE) | 2 | <- no parent
 GST + PST for purchases (SK) | 3 |
 GST for purchases - 5% (SK) | 4 | 3
 TVH for purchases - 12% | 5 |
 TVH for purchases - 13% | 6 |
 TVH for purchases - 13.5% | 7 |
 TVH for purchases - 15% | 8 |
 GST + PST for sales (MB) | 9 |
 GST for sales - 5% (MB) | 10 | 9
 GST + PST for sales (PE) | 11 |
 GST for sales - 5% (PE) | 12 | 11
 GST + TVQ for sales | 13 |
 GST for sales - 5% (QC) | 14 | 13
 GST + PST for sales (SK) | 15 |
 GST for sales - 5% (SK) | 16 | 15
 TVH for sales - 12% | 17 |
 TVH for sales - 13% | 18 |
 TVH for sales - 13.5% | 19 |
 TVH for sales - 15% | 20 |
 GST for sales - 5% | 21 |
 GST + TVQ for purchases | 22 |
 GST for purchases - 5% (QC) | 23 | 22
 GST + PST for purchases (MB) | 24 |
 GST for purchases - 5% (MB) | 25 | 24
 GST + PST for purchases (PE) | 26 |
 PST for sales - 7% | 27 | 9
 TVQ for purchases - 9.5% | 28 | 22
 PST for purchases - 7% | 29 | 24
 PST for sales - 5% (SK) | 30 | 15
 PST for sale - 10% | 31 | 11
 PST for purchases - 10% | 32 | 26
 PST for purchases - 5% (SK) | 33 | 3
 TVQ for sales - 9.5% | 34 | 13