<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Changing sorting of Accounts list]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=779&amp;type=atom" />
	<updated>2009-08-20T20:24:16Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=779</id>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3294#p3294" />
			<content type="html"><![CDATA[<p>Thanks Janusz!&nbsp; How exciting <img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" /></p>]]></content>
			<author>
				<name><![CDATA[tomhallman]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=406</uri>
			</author>
			<updated>2009-08-20T20:24:16Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3294#p3294</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3293#p3293" />
			<content type="html"><![CDATA[<p>I will consult this with Joe, why not.</p><p>Janusz</p>]]></content>
			<author>
				<name><![CDATA[itronics]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=89</uri>
			</author>
			<updated>2009-08-20T20:16:06Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3293#p3293</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3292#p3292" />
			<content type="html"><![CDATA[<p>Whoa!&nbsp; Nice <img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" />&nbsp; Thanks!</p><p>Will you be able to get this set up as a preference in the 2.2 release?</p>]]></content>
			<author>
				<name><![CDATA[tomhallman]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=406</uri>
			</author>
			<updated>2009-08-20T20:11:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3292#p3292</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3291#p3291" />
			<content type="html"><![CDATA[<p>If you want to order account list by account group id apply following changes to gl_all_accounts_list() function code:</p><div class="codebox"><pre><code>diff -r1.23 ui_lists.inc
1498c1498
&lt;         $sql = &quot;SELECT chart.account_code, chart.account_name, type.name
---
&gt;         $sql = &quot;SELECT chart.account_code, chart.account_name, type.name, type.id
1505c1505
&lt;         $sql = &quot;SELECT chart.account_code, chart.account_name, type.name
---
&gt;         $sql = &quot;SELECT chart.account_code, chart.account_name, type.name, type.id
1514c1514
&lt;         &#039;order&#039; =&gt; array(&#039;name&#039;,&#039;account_code&#039;),
---
&gt;         &#039;order&#039; =&gt; array(&#039;type.id&#039;,&#039;account_code&#039;),</code></pre></div><p>That&#039;s all folks <img src="https://frontaccounting.com/punbb/img/smilies/wink.png" width="15" height="15" alt="wink" />.<br />Janusz</p>]]></content>
			<author>
				<name><![CDATA[itronics]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=89</uri>
			</author>
			<updated>2009-08-20T20:05:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3291#p3291</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3290#p3290" />
			<content type="html"><![CDATA[<p>Hi Joe,</p><p>&nbsp; Thanks for the thoughts.</p><p>&nbsp; When Janusz returns, I&#039;d love to have his insight.&nbsp; If this is something I can help with, please let me know.&nbsp; It would make our accounting folks very happy <img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" /></p><p>~Tom</p>]]></content>
			<author>
				<name><![CDATA[tomhallman]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=406</uri>
			</author>
			<updated>2009-08-20T18:52:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3290#p3290</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3201#p3201" />
			<content type="html"><![CDATA[<p>Hello,<br />Janusz has built our ui_lists and he is out of office at present. This will be a change in db structure, so we have to wait until 2.2 release.<br />I guess he can fix that for us.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2009-08-08T07:25:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3201#p3201</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3200#p3200" />
			<content type="html"><![CDATA[<p>Hi Joe,</p><p>&nbsp; Okay, that&#039;s a possible workaround.</p><p>&nbsp; It sounds like others have requested this feature.&nbsp; So, if I offered to make it an option that people could select, would that be something you&#039;d be interested in incorporating?&nbsp; I don&#039;t think it would be hard; just a flag in the user&#039;s preferences or possibly in the company setup?&nbsp; Then the code that generates the accounts list would just check the flag and call a SQL query that does a different sort.&nbsp; (At least that seems right to me.)&nbsp; What do you think?</p><p>~Tom</p>]]></content>
			<author>
				<name><![CDATA[tomhallman]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=406</uri>
			</author>
			<updated>2009-08-08T02:01:02Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3200#p3200</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3198#p3198" />
			<content type="html"><![CDATA[<p>Unfortunately this is not possible at present. I know of people who has put the id in front of the name to solve it.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2009-08-07T22:39:17Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3198#p3198</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Changing sorting of Accounts list]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=3197#p3197" />
			<content type="html"><![CDATA[<p>Hi guys,</p><p>&nbsp; Sorry if this isn&#039;t the right forum for this question - I wasn&#039;t sure where else to put it.</p><p>&nbsp; Is it possible to modify the sorting of the accounts list (such as on the &quot;Chart of Accounts&quot; page, &quot;Journal Entry&quot; page, and so on) to be by Account Group ID instead of Account Group name?</p><p>&nbsp; If not, could that be added as a configuration option?&nbsp; Our accountants set up the Account Groups in such a way as to group things logically by ID rather than name, so that would be a big boost in productivity.</p><p>&nbsp; I could probably add this tweak myself if you could point me in the right direction.</p><p>&nbsp; Thanks very much for such a great product!</p><p>~Tom</p>]]></content>
			<author>
				<name><![CDATA[tomhallman]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=406</uri>
			</author>
			<updated>2009-08-07T20:43:01Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=3197#p3197</id>
		</entry>
</feed>
