[GNC] Asset accounts in wrong order on Balance Sheet

[sunfish62 at yahoo.com]

Gyle was referring to your comment:

"The account picker that pops up when you enter transactions sorts alphabetically rather than by Account Code; so does the Accounts pane itself."

You misspoke is all. 

You can also edit Description. Many columns (last reconcile date, balances, etc.) are derived from the data itself and thus not editable. 

⁣David T. ​

On Mar 10, 2025, 2:38 AM, at 2:38 AM, "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm> wrote:
>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
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-----
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.