Topic: en_GB general CoA error - FA 2.4.1
27-Aug-2009 Joe Hunt
# bank_trans_type_id removed from bank_trans in en_US-demo.sql and en_US-new.sql.
The official pkg distribution for en_GB-general.sql has the field bank_trans.bank_trans_type_id which needs to be removed.
The field budget_trans.memo_ is missing in the official distribution. It should be:
DROP TABLE IF EXISTS `0_budget_trans`; CREATE TABLE IF NOT EXISTS `0_budget_trans` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tran_date` date NOT NULL DEFAULT '0000-00-00', `account` varchar(15) NOT NULL DEFAULT '', `memo_` tinytext NOT NULL, `amount` double NOT NULL DEFAULT '0', `dimension_id` int(11) DEFAULT '0', `dimension2_id` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`) ) ENGINE=InnoDB;
The order of the fields auto_update and inactive are switched in the currencies table.
The order of the fields cust_branch.branch_ref, debtors_master.debtor_ref, stock_category.inactive and suppliers.supp_ref needs to be corrected.
The tables dashboard_reminders and dashboard_widgets should not be in this CoA.
The deprecated table sys_types is present and needs to be removed.
The table tax_types has
UNIQUE KEY `name` (`name`,`rate`)
in the GB CoA that is not present in the standard CoA sqls - it should be there to avoid ambiguities in select boxes.
$SysPrefs->base_sales cannot be "-1". It can be either 0, 1 or 2. Hence change the field value to be so where the field sys_prefs.name='base_sales' AND category='setup.company'.
There is no grn_clearing_act account defined in the official GB CoA.