openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #19292
Re: [Openerp-canada] [Bug 1068398] [NEW] [6.1 trunk] account.tax child created before its parent
OK, thanks. (I was confused by the directory named hr_payroll)
On Fri, Dec 7, 2012 at 10:15 AM, Maxime Chambreuil <
maxime.chambreuil@xxxxxxxxxxxxxxxxxxxx> wrote:
> Regarding the first 2 points, change is here:
>
> http://bazaar.launchpad.net/~openerp-canada/openobject-addons/trunk_l10n_ca_hr_payroll/revision/7851
>
> I don't think that last 2 have any consequences on the module.
>
> Regards,
>
> --
> Maxime Chambreuil
> 1-514-276-5468 #126
>
> ------------------------------
> I am talking about sales tax - not payroll :
>
> *Changes to the Quebec Sales Tax on January 1, 2013<http://www.levifca.com/>
> *.
>
>
>
> Read about
>
> - QST increases to 9.975% on January 1, 2013
> - QST no longer calculated on GST
> - Changes affecting financial services
> - All federal and provincial departments now pay the tax
>
>
> On Fri, Dec 7, 2012 at 9:54 AM, Maxime Chambreuil <
> maxime.chambreuil@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>
>
>
--
Fred Blauer CA, CA.IT, CISA
http://openacct.ca
fred@xxxxxxxxxxx
514-667-1555
--
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 trunk] account.tax child created before its parent
Status in OpenERP Addons (modules):
Confirmed
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
References