diff options
author | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-24 19:01:18 +0000 |
---|---|---|
committer | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-24 19:01:18 +0000 |
commit | a5604d526ea006b1f8cb4c0b02b55547ba5dc405 (patch) | |
tree | 1ad05ff0f25dc33bb9e56e375dc25834aaca7313 /sql | |
parent | ad853136bb1ca4841c09a70379bbafbefe098fa5 (diff) |
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
Diffstat (limited to 'sql')
-rwxr-xr-x | sql/Canada-English_General-chart.sql | 2 | ||||
-rwxr-xr-x | sql/Canada-Quebec_General-chart.sql | 2 |
2 files changed, 2 insertions, 2 deletions
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')); |