From a5604d526ea006b1f8cb4c0b02b55547ba5dc405 Mon Sep 17 00:00:00 2001 From: tetragon Date: Sun, 24 Feb 2008 19:01:18 +0000 Subject: Updating GST rate to current value git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2084 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Canada-English_General-chart.sql | 2 +- sql/Canada-Quebec_General-chart.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/Canada-English_General-chart.sql b/sql/Canada-English_General-chart.sql index 26122124..2f10ce8f 100755 --- a/sql/Canada-English_General-chart.sql +++ b/sql/Canada-English_General-chart.sql @@ -64,7 +64,7 @@ insert into chart (accno,description,charttype,gifi_accno,category,link) values insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','Utilities','A','8812','E','AP_amount'); insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licenses','A','8760','E','AP_amount'); -- -insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06); +insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.05); insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.08); -- diff --git a/sql/Canada-Quebec_General-chart.sql b/sql/Canada-Quebec_General-chart.sql index 2849c5f8..b05caa2d 100755 --- a/sql/Canada-Quebec_General-chart.sql +++ b/sql/Canada-Quebec_General-chart.sql @@ -76,7 +76,7 @@ INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800', 'Taxes d\'affaires, droits d\'adhésion et permis', 'A', 'E', 'AP_amount', '8760'); INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810', 'Perte sur change', 'A', 'E', '', '8231'); -- -insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.06); +insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.05); insert into tax (chart_id,rate,pass) values ((select id from chart where accno = '2320'),0.075,1); -- INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520')); -- cgit v1.2.3