<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Chart Updates in Official FA Repo]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=5911</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5911&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Chart Updates in Official FA Repo.]]></description>
		<lastBuildDate>Sat, 29 Aug 2015 07:46:12 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Chart Updates in Official FA Repo]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=24132#p24132</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 29 Aug 2015 07:46:12 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=24132#p24132</guid>
		</item>
	</channel>
</rss>
