Comment 5 for bug 1068398

Just wanted to remind you that there will be a small change to the TVQ on
Jan 1/2013. Are you aware of the change?

On Fri, Dec 7, 2012 at 8:02 AM, Launchpad Bug Tracker <
<email address hidden>> wrote:

> You have been subscribed to a public bug by Maxime Chambreuil (
> http://www.savoirfairelinux.com) (max3903):
>
> 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: Confirmed
>
>
> ** Tags: 6.1 account trunk
> --
> [6.1 trunk] account.tax child created before its parent
> https://bugs.launchpad.net/bugs/1068398
> You received this bug notification because you are a member of OpenERP
> Canada Team, which is subscribed to the bug report.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-canada
> Post to : <email address hidden>
> Unsubscribe : https://launchpad.net/~openerp-canada
> More help : https://help.launchpad.net/ListHelp
>

--
Fred Blauer CA, CA.IT, CISA
http://openacct.ca
<email address hidden>
514-667-1555