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 protected]> 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 protected] > Unsubscribe : https://launchpad.net/~openerp-canada > More help : https://help.launchpad.net/ListHelp > -- Fred Blauer CA, CA.IT, CISA http://openacct.ca [email protected] 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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
