openerp-canada team mailing list archive

[fred blauer <fblauer@xxxxxxxxx>]

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