diff options
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')); |