1 Topic by apmuthu (edited by apmuthu 01/08/2015 11:53:24 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

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:
==================
0_stock-category.inactive
0_suppliers.supp_ref
0_cust_branch.branch_ref

Changes in Indexes:
===================
0_supp_trans
0_tax_types
0_cust_branch
0_debtor_trans

Field Type / Size / defaults changes:
=====================================
0_users.query_size
0_debtor_trans_details.src_id
0_cust_branch.notes
0_audit_trail.stamp

Optional
========
0_users.print_profile
0_users.startup_tab

Delete fields:
==============
0_bank_trans.bank_trans_type_id

New Fields:
===========
0_currencies.auto_update

Needless tables in default install:
===================================
0_dashboard_reminders
0_dashboard_widgets

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.

apmuthu's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Charts of Accounts from Official Repos - Errors

The en_GB-general.sql Chart of Accounts have been thoroughly cleaned up for FA v2.3.22+ and made in synch with the en_US-new.sql CoA and attached herewith. compare with a diff tool like WinMerge to see the details.

View the commit in my GitHub repo.

It now sports the new GRN Clearing Account (1003) and set in the sys_prefs table as well and all field sequences match the standard US CoA.

@joe: Can include in official repo.

Post's attachments

en_GB-general_cleaned.zip 10.8 kb, 8 downloads since 2015-01-08 

You don't have the permssions to download the attachments of this post.

apmuthu's Website