From 97c8e0097560a861975070b6182318636e9b15d1 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 30 Jan 2010 14:57:35 +0000 Subject: [PATCH] Added Purchase tax account in en_US-new.sql and en_US-demo.sql --- CHANGELOG.txt | 5 +++++ sql/en_US-demo.sql | 3 ++- sql/en_US-new.sql | 3 ++- 3 files changed, 9 insertions(+), 2 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 8b4d777..b124896 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,11 @@ Legend: ! -> Note $ -> Affected files +30-Jan-2010 Joe Hunt ++ Added Purchase tax account in en_US-new.sql and en_US-demo.sql +$ /sql/en_US-demo.sql + /sql/en_US_new.sql + 30-Jan-2010 Janusz Dobrowolski # [0000194] Fixed tax records from journal entry (voiding problem) $ /gl/includes/db/gl_db_trans.inc diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index eca1048..73cf153 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -245,6 +245,7 @@ INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'); +INSERT INTO `0_chart_master` VALUES ('2145', '', 'Purchase Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0'); @@ -1818,7 +1819,7 @@ CREATE TABLE `0_tax_types` ( ### Data of table `0_tax_types` ### -INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0'); +INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2145', 'Tax', '0'); ### Structure of table `0_trans_tax_details` ### diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index b567ba6..2c54a30 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -227,6 +227,7 @@ INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0'); +INSERT INTO `0_chart_master` VALUES ('2145', '', 'Purchase Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0'); INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0'); @@ -1598,7 +1599,7 @@ CREATE TABLE `0_tax_types` ( ### Data of table `0_tax_types` ### -INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0'); +INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2145', 'Tax', '0'); ### Structure of table `0_trans_tax_details` ### -- 2.30.2