[GNC] Asset accounts in wrong order on Balance Sheet

[Paul Roberts]

Brilliant, Stan!!  I didn't even know there was an account code option.  
That's why I put the numbers in the account names 😳.

Thanks so much.
Paul

On 2025-03-09 1:07 p.m., Stan Brown (using GC 4.14) wrote:
> 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
> Tehachapi, CA, USA
> https://BrownMath.com
>
> 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
>>
>>
>>

-- 
This email has been checked for viruses by Avast antivirus software.
www.avast.com