Topic: Charts of Accounts from Official Repos - Errors
As a sample, the en_GB-general v2.3.0-5 from the official repo was taken as of 2014-12-28.
Many CoA's suffer from similar issues including the Canadian CoA.
Here are a few of the changes required with respect to the Standard en_US-new CoA:
Position of field:
Changes in Indexes:
Field Type / Size / defaults changes:
Needless tables in default install:
New Account - GRN Clearing Account needs to be in the chart_master and also set in a record in the sys_prefs table.
Hence after installing your chosen CoA from the official repo, please compare it with the official en_US-new.sql one and partake of the changes in my FAMods sql folder as desired before creating a new company with it.
A sample en_GB-general CoA with only whitespace and table sequencing done (all 00xx account numbers made into 10xx) with all the errors in place but made for easy comparison with the standard en_US-new.sql has been made as an interim commit for others to make changes in similar CoAs.
Make sure that all tables with AUTO_INCREMENT fields are set to AUTO_INCREMENT=1 so that they will auto grab the correct value based on the number of records in them. Do this before the INSERT statements directly in the CREATE TABLE statement itself.