openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #16740
[Bug 1068398] [NEW] [6.1] account.tax child created before its parent
Public bug reported:
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.
As a workaround, I change the order of the tax in the xml file. The
problem moved to another tax (GST + PST for purchases (PE)). See
database table content below:
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
** Affects: openobject-addons
Importance: Undecided
Status: New
** Tags: 6.1 account
** Description changed:
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.
+ As a workaround, I change the order of the tax in the xml file. The
+ problem moved to another tax (GST + PST for purchases (PE)). See
+ database table content below:
+
+
Account.tax.template
- name | id | parent_id
+ 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 |
+ 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
+ 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
+ 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
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1068398
Title:
[6.1] account.tax child created before its parent
Status in OpenERP Addons (modules):
New
Bug description:
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.
As a workaround, I change the order of the tax in the xml file. The
problem moved to another tax (GST + PST for purchases (PE)). See
database table content below:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1068398/+subscriptions
Follow ups
-
[Bug 1068398] Re: [6.1 7.0] account.tax child created before its parent
From: Amit Parik (OpenERP), 2013-10-21
-
[Bug 1068398] Re: [6.1 trunk] account.tax child created before its parent
From: Jignesh Rathod(OpenERP), 2013-02-11
-
[Bug 1068398] Re: [6.1 trunk] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-12-12
-
Re: [Openerp-canada] [Bug 1068398] [NEW] [6.1 trunk] account.tax child created before its parent
From: fblauer, 2012-12-07
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-12-07
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-11-27
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-11-13
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-10-19
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Jignesh Rathod(OpenERP), 2012-10-19
-
[Bug 1068398] Re: [6.1] account.tax child created before its parent
From: Jignesh Rathod(OpenERP), 2012-10-19
-
[Bug 1068398] [NEW] [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-10-19
References
