[GNC] Asset accounts in wrong order on Balance Sheet

[Stan Brown (using GC 4.14)]

Gyle,

I was replying to Paul Roberts, the person with the difficulty, not
having a difficulty myself.

I assume you meant /"Account Code" title/, not /"Account Code Title"/. I
do indeed have my accounts sorted by account code. (It just seemed too
silly to have Expenses come between Equity and Income.)

But maybe you meant something different? I'm having trouble
understanding what you mean by "sort on that account" in /If you click
on the "Account Code Title" it will sort on that account./

In addition to the Account Code, you can edit Placeholder and Hidden in
place, which is quite useful when marking accounts that were active last
year but are now obsolete. I wouldn't be surprised if any other field
can be edited in place, but I haven't tried any but those three.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2025-03-09 14:52, Gyle McCollam wrote:
> Stan,
> The Accounts pane or page can be sorted by the account code.  If you
> click on the "Account Code Title" it will sort on that account.  Yours
> is probably set to the description.
> 
> Thanks for the tip about editing the Account Code in Place, I didn't
> know you could do that.  We all learn something new sometimes!> 
> gmccollam at live.com <mailto:gmccollam at gyleshomes.com>
> 
> ------------------------------------------------------------------------
> *From:* gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org>
> on behalf of Stan Brown (using GC 4.14) <stan+gc at fastmail.fm>
> *Sent:* Sunday, March 9, 2025 4:07 PM
> *To:* Paul Roberts <proberts at letter-perfect.ca>
> *Cc:* GnuCash User List <gnucash-user at gnucash.org>
> *Subject:* Re: [GNC] Asset accounts in wrong order on Balance Sheet
>  
> Paul,
> 
> You made your account numbers part of the account names. I don't have
> any explanation why they are not sorting alphabetically,(*) but I do
> have something easy you can try.
> 
> All of my accounts have four-digit numeric Account Codes in the Accounts
> tab. Without my doing anything special in Gnucash, the accounts appear
> in Account Code order in every report I've tried. So my suggestion is to
> assign your account numbers as Account Codes to the accounts that aren't
> sorting as you wish, and see if that helps. You need not remove the
> numbers from the account names.
> 
> You don't have to click the Edit button for each account in turn. Just
> make Account Code one of the columns on the Accounts tab, and then a
> double-click in that column will let you edit the Account Code in place.
> I suggest doing this initially for just your six Current Assets
> subaccounts, because if it doesn't work as desired then I think
> something else must be going on.
> 
> The account picker that pops up when you enter transactions sorts
> alphabetically rather than by Account Code; so does the Accounts pane
> itself. If your account numbers are the first part of your account
> names, as they are now, I'm pretty sure the account picker will be
> ordered by account code, which might be helpful. However, I don't have
> account numbers as part of my account names, and I've observed when
> entering a transaction I can type either the Account Code or the
> beginning of the account name when entering a transaction; the Account
> Code (if I type it) automatically  changes to the associated account name.
> 
> (It would have been a good idea to tell us which version of GC and which
> operating system you're using.)
> 
> (*) You wouldn't have different non-printing characters at the start of
> your account names, would you?
>
> Stan Brown
> 
> On 2025-03-09 11:34, Paul Roberts wrote:
>> When I print a Balance Sheet, the asset accounts appear in an order
>> different from the order they appear in the Chart of Accounts; i.e., not
>> alphanumeric order.
>> 
>> 1200 Current Assets
>>     1205 Float in Cash Box $30.00
>>     1202 Lost Chords Fund $1,903.91
>>     1203 Devon James Bolton Mental Health Fund $4,610.84
>>     1206 ISCU Shares $6.56
>>     1201 Checking Account $9,086.44
>>     1204 Savings Account $100,037.92
>> 
>> I have specifically prefixed my account names with numbers so that they
>> would be sorted correctly.
>> 
>> The order of accounts in the rest of the Balance Sheet is correct.
>> 
>> Any ideas?
>> 
>> Paul