← Back to team overview

openerp-india team mailing list archive

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

 

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:

> It's already there:
>
> https://code.launchpad.net/~openerp-canada/openobject-addons/trunk_l10n_ca_hr_payroll/+merge/138595
>
> ;)
> --
> Maxime Chambreuil
> 1-514-276-5468 #126
>
> ------------------------------
> 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:
>
>
>
>


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

References