<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Chart Updates in Official FA Repo]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5911&amp;type=atom" />
	<updated>2015-08-29T07:46:12Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5911</id>
		<entry>
			<title type="html"><![CDATA[Chart Updates in Official FA Repo]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=24132#p24132" />
			<content type="html"><![CDATA[<p>Updates to the various Chart of Accounts (CoAs) from the Official FA Repo have been incorporated along with <strong>other fixes</strong> in <a href="https://github.com/apmuthu/frontaccounting/commit/884777e1f738f0b119b52d3cfa227df0cb3877e8">my GitHub Repo</a>.</p><p>Those using the following CoAs:<br /></p><div class="codebox"><pre><code>ar_EG-8digits.sql
en_GB-general.sql
id_ID-4digit.sql</code></pre></div><p>will need to follow these instructions if they have already used the old CoAs:<br /></p><div class="codebox"><pre><code>ar_EG-8digits.sql
=================
`0_purch_orders`.`total` should be after `delivery_address` field and not at the end.
`0_suppliers`.`tax_included` should be after `payment_terms` field and not at the end.

INSERT INTO `0_sys_prefs` (`name`, `category`, `type`, `length`, `value`) VALUES
`0_sys_prefs`  VALUES (&#039;bcc_email&#039;, &#039;setup.company&#039;, &#039;varchar&#039;, 100, &#039;&#039;);

UPDATE `0_sys_types` SET `type_no` = 1;

`0_bank_accounts`.`bank_account_name`: varchar(60) =&gt; varchar(120)
`0_chart_types`.`name`: varchar(100) =&gt; varchar(120)

en_GB-general.sql
=================
Drop field: `0_bank_trans`.`bank_trans_type_id`
Remove dashboard_* tables
Outdated fiscal year entries
`0_currencies`.`auto_update` should be after `hundreds_name` field and not at the end.
`0_cust_branch`.`branch_ref` should be just after the `br_name` field
`0_stock_category`.`inactive` should be just before the last field.
UPDATE `0_sys_types` SET `type_no` = 1;

`0_chart_master` table:
Replace all account_code values of 00xx with 10xx
Change 8601 Profit and Loss account code to 9990 to conform to en_US-new

id_ID-4digit.sql:
=================
Replace all instances of dimension0 with dimension2</code></pre></div>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-08-29T07:46:12Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=24132#p24132</id>
		</entry>
</feed>
