openerp-india team mailing list archive

Thread
Date
Re: [Openerp-canada] [Bug 1068398] [NEW] [6.1 trunk] account.tax child created before its parent

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: fblauer <1068398@xxxxxxxxxxxxxxxxxx>
Date: Fri, 07 Dec 2012 14:31:22 -0000
Reply-to: Bug 1068398 <1068398@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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 <
1068398@xxxxxxxxxxxxxxxxxx> 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     : openerp-canada@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-canada
> More help   : https://help.launchpad.net/ListHelp
>


-- 
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
Follow ups

Re: [Openerp-canada] [Bug 1068398] [NEW] [6.1 trunk] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-12-07
References

[Bug 1068398] [NEW] [6.1] account.tax child created before its parent
From: Maxime Chambreuil (http://www.savoirfairelinux.com), 2012-10-19