[GNC] Account Sort Order

[D.]

Eric, 

Thanks for a second idea. 

I suspect that works for you because the other accounts at that Cash account level are also currency-denominated accounts. I guess I could go that route as well, but in a single currency situation, it seems a little absurd to create yet another level of accounts just to encapsulate the commodities-- and my accounts are already rather deep in this section of the Chart. 

You and Geoff have both given me workarounds that I can consider. I'm still eager to hear from one of the developers, who might explain to me the sorting logic in play overall. I'd like to understand what is actually going on before I go mucking around with the many accounts involved. 

Thanks again, 
David T.




-------- Original Message --------
From: Eric Coates via gnucash-user <gnucash-user at gnucash.org>
Sent: Fri Feb 26 08:47:21 EST 2021
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Account Sort Order

Another idea:

Set the Cash account as a separate sub-account under the broker account. 
Please see attached screen shot. (Sorry about the rather 
over-complicated account names but they work for me!) For non-UK users 
(but of no real consequence): An ISA (Individual Savings Account) is a 
tax-light savings vehicle.

Eric
==============================

On 25/02/2021 23:12, D. via gnucash-user wrote:
> That's certainly less onerous than renumbering over and over again, but it's not great. But thank you for one idea!
>
>
> -------- Original Message --------
> From: Geoff <cleanoutmyshed at gmail.com>
> Sent: Thu Feb 25 15:43:52 EST 2021
> To: "David T." <sunfish62 at yahoo.com>, Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Account Sort Order
>
> Hi David
>
>   > Can anyone tell me if there is some way I can get the Cash
>   > account to appear before the commodities, without assigning account
>   > codes to them all? Assigning codes is out of the question because I'd
>   > have to resequence every commodity account after the purchase of any
>   > new commodity, which would get old very quickly.
>
> As a workaround, you can achieve the desired result if you assign the
> *same* account code to all of the broker's commodities (which avoids
> resequencing), and a lesser (or blank) account code to the cash account.
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =====
>
> On 26/02/2021 5:40 am, David T. via gnucash-user wrote:
>> Hello,
>>
>> I'm using GnuCash 4.4 under Windows 10, and I am wondering how GnuCash
>> sorts accounts in the Chart of Accounts window. My chosen sort order is
>> by Account Code; however, I choose not to assign account codes for a
>> large number of accounts (such as individual commodities in a brokerage
>> account). For these accounts, I assumed that GnuCash sorts accounts by
>> their names, based on an ASCII sort--which is generally what I see. The
>> result is something like:
>>
>> 1599 - Broker A
>> -- 21st Century Fox
>> -- Alphabet
>> -- IBM
>>
>> 1600 - Alphabetically Earlier Account with higher account code
>>
>> and so forth. And, indeed, that is how I see most of these accounts.
>>
>> However, I decided to change up my structure and add a cash account to
>> one of my brokerage accounts, and  no matter what I name this account,
>> it shows up after every commodity account, like so:
>>
>> 1599 - Broker A
>> -- 21st Century Fox
>> -- Alphabet
>> -- IBM
>> -- 1 Cash
>>
>> I've tried putting "*" "-" " ", and the result is the same; Cash appears
>> after the commodities. Can anyone explain to me how GnuCash is arriving
>> at this sort? Can anyone tell me if there is some way I can get the Cash
>> account to appear before the commodities, without assigning account
>> codes to them all? Assigning codes is out of the question because I'd
>> have to resequence every commodity account after the purchase of any new
>> commodity, which would get old very quickly.
>>
>> TIA,
>>
>> David
>>
>> _______________________________________________
>> 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
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




------------------------------------------------------------------------

_______________________________________________
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
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.