openerp-canada team mailing list archive

[Launchpad Bug Tracker <1068398@xxxxxxxxxxxxxxxxxx>]

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.